Oracle 12C dgbroker 配置

关于DGbroker的配置网上有太多资料了，此处在不做详细介绍配置，贴一片metalink上的文章共大家参考学习。
1. Prerequisits,

Start the Dataguard broker DMON process. ----------启动dg_broker

On Primary and Standby,

SQL> alter system set dg_broker_start=true sid='*'; 

 

2. Connect to DGMGRL    ---------------------------连接dgmgrl，进行配置

Primary,

$dgmgrl 
DGMGRL>connect sysdg
password: *****

3. Create configuration,   ----------------------------创建配置

 

DGMGRL> CREATE CONFIGURATION '<configuration name>' AS PRIMARY DATABASE IS '<primary db_unique_name>' CONNECT IDENTIFIER IS <primary connect string>;

ex,

DGMGRL> CREATE CONFIGURATION '12c' AS PRIMARY DATABASE IS 'boston' CONNECT IDENTIFIER IS boston;

 

NOTE : If create configuration fails with ORA-16698 refer to
Note 1582179.1: Create Configuration Failing with ORA-16698

Verify configuration,

DGMGRL> show configuration;

Configuration - 12c

  Protection Mode: MaxPerformance
  Databases:
  boston - Primary database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

4. Add Standby,    -------------------------------添加备用环境

DGMGRL>  add database <standby db_unique_name> as connect identifier is <standby connect string>;

ex,

DGMGRL>  add database chicago as connect identifier is chicago;

 

DGMGRL> show configuration;

Configuration - 12c

  Protection Mode: MaxPerformance
  Databases:
  boston  - Primary database
    chicago - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

5. Enable Configuration,

DGMGRL> enable configuration;

6. Verify configuration,

DGMGRL> show configuration;

Configuration - 12c

  Protection Mode: MaxPerformance
  Databases:
  boston  - Primary database
    chicago - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

 

DGMGRL> show database boston;

Database - boston

  Role:              PRIMARY
  Intended State:    TRANSPORT-ON
  Instance(s):
    boston

Database Status:
SUCCESS


DGMGRL>  show database chicago;

Database - chicago

  Role:              PHYSICAL STANDBY
  Intended State:    APPLY-ON
  Transport Lag:     0 seconds (computed 1 second ago)
  Apply Lag:         0 seconds (computed 1 second ago)
  Apply Rate:        2.54 MByte/s
  Real Time Query:   ON
  Instance(s):
    chicago

Database Status:
SUCCESS

 

 

Datagurd configuration details recorded in binary file,

 

SQL> show parameter config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_1/dbs/dr1boston.dat
dg_broker_config_file2               string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_1/dbs/dr2boston.dat

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28612416/viewspace-2120010/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28612416/viewspace-2120010/