You can use the same steps to switchover for single data guard or multiple data guard configuration.
Switchover operation will convert primary side to data guard and data guard to primary side.
You have to control listeners whether it is running before switchover steps.
Switchover Steps
Primary Side
SQL> alter system archive log current; SQL> alter database commit to switchover to standby with session shutdown; SQL> shutdown immediate; SQL> startup mount;
Data Guard Side
SQL> alter database recover managed standby database cancel; SQL> alter database commit to switchover to primary with session shutdown; SQL> shutdown immediate; SQL> startup;
Primary Side
SQL> alter database recover managed standby database disconnect; If you create standby log files you can use real time apply with below command. SQL> alter database open read only; SQL> alter database recover managed standby database using current logfile disconnect;
1 thought on “Oracle 11g R2 Data Guard Manual Switchover Steps”