Mar 28 2017

Oracle 11g R2 Data Guard Manual Switchover Steps

Category: Administration,Backup And RecoveryFatih Acar @ 09:47

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;

2,327 total views, 6 views today

Tags: Database Administration, Oracle Administration, Oracle Data Guard, Oracle Data Guard Switchover

facebook comments:

One Response to “Oracle 11g R2 Data Guard Manual Switchover Steps”

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.