Failover a standby database

on August 27, 2008 at 2:19 pm
Posted In: Oracle Data Guard Notes (Cat)

Check archive log gaps

SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;

ALTER DATABASE REGISTER PHYSICAL LOGFILE ‘filespec1‘;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE OPEN; OR SHUTDOWN IMMEDIATE and STARTUP;

Â