Thursday, November 12, 2009

Enable Active Standby on a database with Dataguard Broker

# Stop apply on the standby
dgmgrl
connect sys
edit database pl01ref set state=apply-off;
exit

# open the standby
sqlplus / a sysdba
alter database open;
exit

# start apply on the standby
dgmgrl
connect sys
edit database pl01ref set state=apply-on;
exit