Oracle 11g Data Guard Role Transition (Switchover)

ORACLE 11G DATAGUARD MANUAL ROLE TRANSITION

After Successful implementation of Oracle 11g Data Guard, next step is to check role transition.

Steps on Primary Database.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

--------------------

TO STANDBY

SQL> alter database commit to switchover to physical standby with session shutdown;

Database altered.

Now perform Shut down to change role of primary database into standby database.

SQL> shutdown immediate;

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1241513984 bytes

Fixed Size                  1273420 bytes

Variable Size             318767540 bytes

Database Buffers          905969664 bytes

Redo Buffers               15503360 bytes

Database mounted.

SQL> alter database open read only;

SQL> recover managed standby database disconnect using current logfile;

Steps on Standby Database.

SQL> alter database commit to switchover to primary with session shutdown;

Database altered.