CONFIGURE DATAGUARD BROKER IN ORACLE DATAGUARD
Check the status of parameter db_broker_start. If it is set to FALSE, then set it to TRUE
kish@PRIM>show parameter dg_broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /u01/oracle/product/12.1.0/db/
dbs/dr1dbx00.dat
dg_broker_config_file2 string /u01/oracle/product/12.1.0/db/
dbs/dr2dbx00.dat
dg_broker_start boolean FALSE
kish@PRIM>alter system set dg_broker_start=true;
System altered.
Refer below link for a common error while creating configuration file for broker.
Invoke dgmgrl utility and create configuration file for the broker
kish@PRIM>!dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/password
Connected as SYSDG.
DGMGRL> create configuration dgb AS primary database IS dbx00 CONNECT IDENTIFIER IS dbx00;
Configuration "dgb" created with primary database "dbx00"
Add the service of standby database as connection identifier
DGMGRL> add database dbx01 AS CONNECT IDENTIFIER IS dbx01 MAINTAINED AS PHYSICAL;
Database "dbx01" added
Enable the configuration to make broker effective.
DGMGRL> enable configuration;
Enabled.
Verify the configurations of primary and standby
DGMGRL> show configuration
Configuration - dgb
Protection Mode: MaxPerformance
Members:
dbx00 - Primary database
dbx01 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 2 seconds ago)
Check the status of primary and standby databases
DGMGRL> show configuration
Configuration - dgb
Protection Mode: MaxPerformance
Members:
dbx00 - Primary database
dbx01 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 8 seconds ago)
DGMGRL> show database dbx01
Database - dbx01
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 15.00 KByte/s
Real Time Query: OFF
Instance(s):
dbx01
Database Status:
SUCCESS
DGMGRL> show database dbx00
Database - dbx00
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
dbx00_1
Database Status:
SUCCESS
