[Oracle] ADG单实例系列搭建之（Data Guard Broker）

--both databases (primary and standby)
ALTER SYSTEM SET dg_broker_start=true;

dgmgrl sys/oracle@orcl
##pri是configuration名称，随意
##第一个orcl是db_unique_name
##第二个orcl是TNSNAME
CREATE CONFIGURATION pri AS PRIMARY DATABASE IS orcl CONNECT IDENTIFIER IS orcl;
##第一个orcl_stby是db_unique_name
##第二个orcl_stby是TNSNAME
ADD DATABASE orcl_stby AS CONNECT IDENTIFIER IS orcl_stby MAINTAINED AS PHYSICAL;
ENABLE CONFIGURATION;

SHOW CONFIGURATION;
SHOW DATABASE orcl;
SHOW DATABASE orcl_stby;

vi $TNS_AMDIN/listener.ora
##GLOBAL_DBNAME是db_unique_name+DGMGRL
##primary add
  (SID_DESC =
    (GLOBAL_DBNAME = orcl_DGMGRL)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db)
    (SID_NAME = orcl)
  )
##standby add
  (SID_DESC =
    (GLOBAL_DBNAME = orcl_stby_DGMGRL)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db)
    (SID_NAME = orcl)
  )

SWITCHOVER TO orcl_stby;

ALTER DATABASE FLASHBACK ON;
ALTER SYSTEM SET db_recovery_file_dest_size=5G;

##备库DGMGRL操作
FAILOVER TO orcl_stby IMMEDIATE;

##备库DGMGRL操作
REINSTATE DATABASE orcl;

##主库DGMGRL操作
CONVERT DATABASE orcl_stby TO SNAPSHOT STANDBY;

##主库DGMGRL执行
CONVERT DATABASE orcl_stby TO PHYSICAL STANDBY;