DG Broker Configuration

 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';