Data Guard Broker Configuration

Primary: arch

Standby: archgrd

 

1. In primary & Standby

SQL> alter system set dg_broker_start=true;

 

2. In primary

DGMGRL> connect sys

DGMGRL> CREATE CONFIGURATION dgmgrl_arch AS PRIMARY DATABASE IS arch CONNECT IDENTIFIER IS arch;

DGMGRL> ADD DATABASE archgrd AS CONNECT IDENTIFIER IS archgrd MAINTAINED AS PHYSICAL;

DGMGRL> ENABLE CONFIGURATION;

DGMGRL> SHOW CONFIGURATION;

DGMGRL> SHOW DATABASE arch;

DGMGRL> SHOW DATABASE archgrd;