Oracle
Data Guard
Switchover

Assumptions

  • A Physical Standby Exists

  • Data Guard Broker is configured and enabled (and using Oracle Wallet)

  • Commands below will be executed from the Primary database environment

Check

dgmgrl /@ORCL1 'SHOW CONFIGURATION'

dgmgrl /@ORCL1 'VALIDATE DATABASE ORCL2'

Switchover

dgmgrl /@ORCL1

SWITCHOVER TO ORCL2;

SHOW CONFIGURATION;

Primary & Standby

Troubleshooting

You may not run Oracle ADG recovery because it is not supported on this public cloud

Client is running on host ORCL1, not the current host ORCL2

If you get this on bare metal, I believe this is a bug in the 18-Jul2017 (170718) BP/DBRU. The workaround seems to be to restart the standby database.