switchover a standby database

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

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

to standby /* NOT – SESSIONS ACTIVE */

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;

SHUTDOWN IMMEDIATE;

STARTUP MOUNT

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

to primary

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

SHUTDOWN IMMEDIATE; /* or */ ALTER DATABASE OPEN;

STARTUP

ALTER SYSTEM SWITCH LOGFILE;

 

Â