關於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

Oracle 12C dgbroker 配置

相關文章