June 2013
Beginner
404 pages
9h 40m
English
Follow these steps to complete a failover on the physical standby Data Guard environment:
SQL> alter system flush redo to INDIA_UN;
Use DB_UNIQUE_NAME of the standby database so that redo will be sent to the respective standby database.
MOUNT state, check the maximum archive log sequence that has been generated as shown in the following code:SQL> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
462