Posts

Showing posts from June, 2017

Configure oracle public YUM for oracle RPM's

Most of the DBA's struggle while setting up virtual box setup due to yum repository issues, here i am collected steps to setup yum repo we need to download  the repository config file (OEL6)   cd /etc/yum.repos.d/ wget http://yum.oracle.com/public-yum-ol6.repo Install Oracle 12cR1/12cR2, Based on your requirementw yum install --nogpgcheck oracle-rdbms-server-12cR1-preinstall yum install --nogpgcheck oracle-database-server-12cR2-preinstall yum install oracle-validated yum update Verifcation Step to install firefox  yum list yum install firefox Detailed information on http://public-yum.oracle.com/

RealTime Scenario using Flashback technique

SQL> select * from scott.newtab;     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ----------       7369 SMITH      CLERK           7902 17-DEC-80        800                    20       7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30       7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30       7566 JONES      MANAGER       ...

Change Protection Mode for Active Dataguard (11GR2)

Change Protection Mode for Active Dataguard (11GR2) Primary Database :  TESTDB Standby Database :  TESTDBDR Database version   :  11gR2  The database is running under Maximum Performance mode. SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE ------ ------------- ------------- -------------------- OPEN    TESTDB        PRIMARY       MAXIMUM PERFORMANCE In order to change the protection mode to either MAXIMUM AVAILABILITY/MAXIMUM PROTECTION, we need to have the standby redo logs configured on the standby database. Also, the redo shippment parameter (log_archive_dest_2) on the primary database should be configured to use SYNCHRONOUS (“SYNC”) mode. Let’s check the number of online redo logs and it’s size on primary database ...