9-3 Data Guard - Configure the Observer

Data Guard Broker utility (DGMGRL) is used to manage the data guard in Oracle. This tool uses the data guard configuration file to manage both physical and standby databases.

 

 

To start the Data Guard Broker Process (DMON), set this parameter on both databases.

To create a broker configuration on the primary database, run CREATE CONFIGURATION command.

/* on node1 */
dgmgrl

CONNECT sys/oracle

CREATE CONFIGURATION dg_conf AS PRIMARY DATABASE IS oradb CONNECT IDENTIFIER IS oradb;

then, add standby database to data guard broker.

ADD DATABASE oradb_s2 AS CONNECT IDENTIFIER IS oradb_s2;

show configuration;

 

 

 

Observer is a client program that runs on a different computer from the primary and standby database and monitors the availability of the primary database.

start observer;

 

 

 

 

 

 

References

Oracld Docs 19c, Data Guard Broker

ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set