Embedded Files
Oracle
Assumptions
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
Check
dgmgrl /@ORCL1 'SHOW CONFIGURATION'
dgmgrl /@ORCL1 'VALIDATE DATABASE ORCL2'
Switchover
Switchover
dgmgrl /@ORCL1
SWITCHOVER TO ORCL2;
SHOW CONFIGURATION;
Primary & Standby
Troubleshooting
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.
Page updated
Google Sites
Report abuse