DG Broker Configuration
Primary
-----------------------
alter system set dg_broker_start=false scope=both sid='*';
alter system set dg_broker_config_file1='+DATAC1/etmsaipx/dr1_etmsaipx.dat'
scope=both sid='*';
alter system set dg_broker_config_file2='+RECOC1/etmsaipx/dr2_etmsaipx.dat'
scope=both sid='*';
alter system set dg_broker_start=true scope=both sid='*';
=====================================================================
STANDBY
---------->>>
alter system set dg_broker_config_file1='+DATAC1/etmsldtn/dr1_etmsldtn.dat'
scope=both sid='*';
alter system set dg_broker_config_file2='+RECOC1/etmsldtn/dr2_etmsldtn.dat'
scope=both sid='*';
alter system set dg_broker_start=true scope=both sid='*';
show parameter dg_broker_config_file1
show parameter dg_broker_config_file2
show parameter dg_broker_start
alter user sys identified by M1leH1gh;
=====================================================================
PRIMARY
---------->>>
$ dgmgrl
DGMGRL> connect sys/****@ETMSLDTO
Connected.
DGMGRL> show configuration;
ORA-16532: Data Guard broker configuration does not exist
Configuration details cannot be determined by DGMGRL
DGMGRL> create configuration 'ETMSLDTO' as primary database is ETMSLDTO
connect identifier is ETMSLDTO;
Configuration "ETMSLDTO" created with primary database
"etmsldto"
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - ETMSLDTO
Protection Mode: MaxPerformance
Databases:
etmsldto - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL
DGMGRL> ADD DATABASE ETMSAIPX AS CONNECT IDENTIFIER IS ETMSAIPX MAINTAINED
AS PHYSICAL;
Database "vpprodrr" added
DGMGRL> show configuration;
Configuration - OCI_VPPRODR
Protection Mode: MaxPerformance
Databases:
vpprodr - Primary database
vpprodrr - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration;
DGMGRL> show configuration;
DGMGRL> show database verbose 'vpprodr';
