Oracle Database Dataguard Switchover
?#############?Switchover?Preparation??##############
1)?Take?full backup of?Database?
2) Take backup?of?Controlfile?
3)?srvctl config database -d primary -a?
##############???Switchover?Without Datagurad Broker??##############
1.1 Start Oem?Blackout?
emctl start blackout?blackout_name?-nodelevel?
emctl?status blackout?
1.2?Perform some?log switch??
Alter system archive log current?;?
Alter system archive log current?;?
Alter system archive log current?;?
?2.1 On Primary Database, Verify That it Can Be Switched to the Standby Role
?SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
---------------------------------
TO STANDBY
?2.2 Initiate the Switchover
?On Standby?Database,
?SQL> alter database recover managed standby database cancel;
SQL>?alter database recover managed standby database finish;
?On Primary Database, Initiate the Switchover
?SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
SQL> SHUTDOWN ABORT;
SQL> STARTUP MOUNT;
SQL> SELECT OPEN_MODE, DATABASE_ROLE FROM V$DATABASE;
?2.3 On Standby Database, Verify That it Can Be Switched to the Primary Role
?SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
---------------------------------
TO PRIMARY
?2.4 On Standby Database, Switch Standby Database Role to the Primary Role
?SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
SQL> ALTER DATABASE OPEN;
SQL> SELECT OPEN_MODE, DATABASE_ROLE FROM V$DATABASE;
?Below?is?one of good features we never used but good to me included?
?ALTER DATABASE SWITCHOVER TO CHICAGO VERIFY;??( pre??switchover )?
ALTER DATABASE SWITCHOVER TO BOSTON FORCE;
?##############??Switchover?With Datagurad Broker??##############
?2.1??Connect to Primary?
?DMGRL >??show configuration
DMGRL >??show database?verbose primary??
DMGRL >??show database??primary?inconsistantproperties?
DMGRL >??show database?verbose?standby?
DMGRL >??show database??standby inconsistantproperties?
DMGRL >??switchover to standby?
?##############??Switchover?Post task ##############
?We need to update right role of database in Crs?
?1)?srvctl config database -d primary -a???
?Verify Service is started on New primary?
?2)?srvctl status?service -d primary
?##############?Tracing for switchover?##############
?We had one of?case where switchover was not complete?and oracle suggested to?enable below tracing .
?SQL> alter system set log_archive_trace=8191;?-- enabling trace
SQL> alter system set log_archive_trace=0;???-- disabling trace
?##############?Known Issues?##############
?Primary Instance Fails To Mount W/ Ora-19970 After Switchover Interrupted (document ID 2256447.1)
DGMGRL>switchover to <standby> Fails with ORA-12514 (Doc ID 1582927.1)
##############?References??##############