<<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 |
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)
Comments
Post a Comment