Oracle Data Guard 11gR2 Administration Beginner's Guide

Time for action – preliminary tests before performing switchover

In order to perform switchover, we have to prepare and verify both the primary and standby databases. Perform the following steps:

1. Check the standby redo logfile status on the primary database as follows:

   SQL> select group#,member,type from v$logfile where type='STANDBY';
   
       GROUP# MEMBER                                            TYPE
   ---------- ---------------------------------------------- -------
           ..   ........
        14 /u01/app/oracle/oradata/orcl/standby_redo05.log    STANDBY
        16 /u01/app/oracle/oradata/orcl/standby_redo06.log    STANDBY
   6 rows selected.

   Standby redo logfiles should have been created on the primary database; this is so that after performing switchover, the new standby database can receive redo using standby redo logfiles. ...