If you’re looking to create Oracle Data Guard Broker Configuration, this step-by-step guide will walk you through everything you need—from setting parameters to enabling configurations. Ideal for DBAs managing Oracle environment
Step-by-Step Configuration
Step 1: Set Broker Configuration Files
On both Primary and Standby, configure the broker files:
Default location: $ORACLE_HOME/dbs or $ORACLE_HOME/database
For a custom path (shared path for RAC):
ALTER SYSTEM SET dg_broker_config_file1 = '<path/file_name>.dat' SCOPE=BOTH SID='*';
ALTER SYSTEM SET dg_broker_config_file2 = '<path/file_name>.dat' SCOPE=BOTH SID='*';If using ASM:
ALTER SYSTEM SET dg_broker_config_file1 = '+<disk_group>/<file_name>.dat' SCOPE=BOTH SID='*';
ALTER SYSTEM SET dg_broker_config_file2 = '+<disk_group>/<file_name>.dat' SCOPE=BOTH SID='*';Skip this step if you’re fine with the default path.
Step 2: Enable the Broker
Enable the Data Guard broker on both databases:
ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH SID='*';Step 3: Connect to DGMGRL
On the primary server:
$ dgmgrl
DGMGRL> CONNECT sys/<password>;
Step 4: Create Configuration
Run the following on the Primary:
DGMGRL> CREATE CONFIGURATION 'PROD_CONF' AS PRIMARY DATABASE IS 'PROD' CONNECT IDENTIFIER IS PROD;
Step 5: Add Standby Database
DGMGRL> ADD DATABASE 'STDBY' AS CONNECT IDENTIFIER IS STDBY MAINTAINED AS PHYSICAL;
Step 6: Enable the Configuration
DGMGRL> ENABLE CONFIGURATION;
Verify:
DGMGRL> SHOW CONFIGURATION;
You should see output like:
Configuration
Name: PROD_CONF
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
PROD - Primary
STDBY - Physical Standby
Status: SUCCESS
Step 7: Check Standby Redo Logs (SRLs)
If you encounter this warning:
ORA-16789: standby redo logs configured incorrectly
Make sure your Standby Redo Logs are properly configured on both sides.
Final Notes
Always replace PROD and STDBY with your actual DB unique names.
To troubleshoot, use:
SHOW DATABASE VERBOSE '<db_unique_name>';
Check logs:
For official prerequisites and deeper insights, check out the Oracle Data Guard Broker Documentation.
Comments 1