The concept of data guard broker and the configuration process of data guard broker

DG Broker Is a distributed management framework , It can organize and integrate the main database and the standby database according to certain logic
In the management , Including the creation of 、 Maintenance and monitoring Data Guard Etc . management Broker Settings can be used EM Enterprises
Manager or DGMGRL Command line .

To configure Broker There are the following steps ：

  One 、 Modify in the main database dg_broker_start Parameter is true Enable Broker;

Two 、 Create... On the master library DGMGRL Dedicated static monitoring , Restart the listener after completion ;

3、 ... and 、 Repeat steps 1 and 2 on the standby database ;

Four 、 Create the primary database on the standby database tnsname;

5、 ... and 、 Set the local_listener Parameters , Specify the listening name of the standby database ;

6、 ... and 、 Use DGMGRL Connect to the main library , Create a new DG To configure , Include Broker Configuration name , Main database name and main database
Of tnsname;

7、 ... and 、 Add standby database information to Broker Configuration in progress , Including the name of the standby database and the name of the standby database tnsname;

8、 ... and 、 Enable and verify the configuration