<<Back to Oracle DataGuard Main Page

How to Create Broker Configuration

Here is the details of my Primary database for which I want to configure the Physical Standby database

Hosts and Databases Used in this Example
DB_ROLE PRIMARY STANDBY
HOST_NAME test1 test2
DB_UNIQUE_NAME TST1TP TST1TS
DB_NAME TST1T TST1T
Step1> Set the parameter dg_broker_config_file1 and dg_broker_config_file2 on all instances of primary and standby.
NOTE: In case of RAC database, set broker configuration file location to shared location and same value on all the instances
for ASM
SQL>ALTER SYSTEM SET dg_broker_config_file1 = '+DG_TEST_DATA/TST1TS/drc1.dat' scope=both sid='*';
SQL>ALTER SYSTEM SET dg_broker_config_file2 = '+DG_TEST_DATA/TST1TS/drc2.dat' scope=both sid='*';
OR in case of file system use:
SQL>ALTER SYSTEM SET dg_broker_config_file1 = '/u01/app/admin/TST1T/drc1.dat' scope=both sid='*';
SQL>ALTER SYSTEM SET dg_broker_config_file2 = '/u01/app/admin/TST1T/drc2.dat' scope=both sid='*';
Step2> Enable Broker on Both Primary and Standby
SQL>ALTER SYSTEM SET DG_BROKER_START=TRUE scope=both sid='*';
Step3> Ensure that you have TNSENTRY for Primary and for all Standby databases on all servers
Connect to DGMGRL on primary
Step4> Create Broker Configuration
$ dgmgrl /
Welcome to DGMGRL, type "help" for information.
Connected to "TST1TP"
Connected as SYSDG.
DGMGRL> CREATE CONFIGURATION DG_TST1T AS PRIMARY DATABASE IS TST1TP CONNECT IDENTIFIER IS TST1TP;
Configuration "dg_tst1t" created with primary database "tst1tp"
Step5> Add all physical Standby Databases to the Configuration
DGMGRL> ADD DATABASE TST1TS AS CONNECT IDENTIFIER IS TST1TS;
Database "tst1ts" added
DGMGRL> show configuration;
Configuration - dg_tst1t
  Protection Mode: MaxPerformance
  Members:
  tst1tp - Primary database
    tst1ts - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
Step6> Enable Configuration
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration;
Configuration - dg_tst1t
  Protection Mode: MaxPerformance
  Members:
  tst1tp - Primary database
    tst1ts - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS   (status updated 59 seconds ago)