Turn on active Data Guard

Before you configure active data guard, the phycial standby must be in one of the following two states:

(1) Standby is in Mount state, and redo apply is running

(2) Standby is cleanly closed, redo apply is stopped

1. Configure Active Data Guard

Prerequisites : Standby is in Mount state, and redo apply is running

Using the SQL command line:

sql> Recover managed standby database cancel; #停止redo applysql> ALTER DATABASE open read only; sql> Recover managed Standby database disconnect using current logfile; #重启redo apply

Use Broker:

dgmgrl> Edit Database ' standby_name ' set state= ' Apply=off '; # stop redo applysql> ALTER DATABASE open read only; #使用sqlpl The US command executes dgmgrl> edit database ' standby_name ' set state= ' Apply=on ';

2. Configure Active Data Guard
Prerequisites : Standby is cleanly closed, redo apply is stopped

Using the SQL command line:

Sql> startupsql> Recover managed standby database disconnect using current logfile;

Use Broker:

dgmgrl> startupsgmgrl> Edit Database ' standby_name ' set state= ' Apply=on ';

Turn on active Data Guard