Oracle Solution : Dataguard Switch over step
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
source :Dataguard Switch over step