Oracle Solution : Dataguard Switch over step

by cryst · Published March 16, 2011 · Updated March 1, 2011

Oracle Solution : Dataguard Switch over step

1. Initiate the switchover operation on the primary database (On the original primary database)

– Verify database role

SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE
—————-
PRIMARY

– Switch database role from primary to standby database

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN WAIT;

Database altered.

– Shutdown database

SQL> SHUTDOWN IMMEDIATE

– Startup database

SQL> STARTUP

– Verify database role

SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE
—————-
PHYSICAL STANDBY

– Start apply log process for standby database

SQL> ALTER DATABASE RECOVER MANAGE STANDBY DATABASE DISCONNECT;

2. Switch standby database to primary database (On the original standby database)
– Verify database role

SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE
—————-
PHYSICAL STANDBY

– Switch database role from standby to primary database

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

– Shutdown database

SQL> SHUTDOWN IMMEDIATE

– Startup database

SQL> STARTUP

– Verify database role

SQL> SELECT DATABASE_ROLE FROM V$DATABASE;

DATABASE_ROLE
—————-
PRIMARY