Data Guard Physical Standby Setup in Oracle11.2 & 后加 Data Guard Broker 之04(配置dg Broker)

1.開啟flashback（主備）

#主库
SQL> select log_mode,open_mode,flashback_on from v$database;
LOG_MODE     OPEN_MODE		  FLASHBACK_ON
------------ -------------------- ------------------
ARCHIVELOG   READ WRITE 	  NO

SQL> alter database flashback on;

SQL> select log_mode,open_mode,flashback_on from v$database;
LOG_MODE     OPEN_MODE		  FLASHBACK_ON
------------ -------------------- ------------------
ARCHIVELOG   READ WRITE 	  YES


#备库
#停實時日誌應用
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> alter database flashback on;

SQL> select log_mode,open_mode,flashback_on from v$database;

LOG_MODE     OPEN_MODE		  FLASHBACK_ON
------------ -------------------- ------------------
ARCHIVELOG   READ ONLY		  YES

#開啟實時日誌應用
SQL> recover managed standby database using current logfile disconnect from session;

SQL> select log_mode,open_mode,flashback_on from v$database;
LOG_MODE     OPEN_MODE		  FLASHBACK_ON
------------ -------------------- ------------------
ARCHIVELOG   READ ONLY WITH APPLY YES
#主库
SQL> select log_mode,ope