12c Create Dataguard Broker Configuration - DGMGRL

Goal

This Document offers step by step method to create broker configuration.

Example configuration,

Dg configuration : 12c
Primary db_unique_name : boston
Standby db_unique_name : chicago

Solution

 1. Prerequisits,

Start the Dataguard broker DMON process.

On Primary and Standby,

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

2. Connect to 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

 

Thanks

Srini