<<Back to Oracle Data Guard Broker Page
Understanding Oracle Data Guard Broker and DGMGRL Utility
Oracle Data Guard Broker is an Utility which logically groups all the dataguard members in oracle dataguard configuration to centrally manage and monitor them together as an integrated unit.Oracle Dataguard Broker stores the necessary information in a file locally on each dataguard member server. The file location is configured using following database parameters
dg_broker_config_file1
dg_broker_config_file2
The content of above the file is accessed and managed by Dataguard Monitor (DMON) Process. The DMON process is an Oracle background process that runs on every database instance that is managed by the broker. The start/stop of DMON process (which interns enables or disables) broker is managed by database parameter called dg_broker_start, the value of which is TRUE (enabled) or FALSE (disabled).
The broker configuration can be queried and/or modified using Oracle Data Guard command-line interface called DGMGRL or OEM.
The content of broker file (ie many of the Dataguard related configuration) can also be queried and modified using SQL*PLUS, however this is not a recommended way if Dataguard Broker is enabled.
Oracle Data Guard Broker and Multitenant Architecture (CDBs)
Oracle Data Guard broker supports multitenant container databases (CDBs) within abroker configuration.
When a broker configuration is made up of CDBs, all broker actions execute at the
root level and not at the individual pluggable database (PDB) level.
After a role change (switchover), the broker opens all active instances of the new primary.
The broker also opens all active instances of a snapshot standby, a logical standby and the first instance of a physical standby (if the former physical standby was open for read).
The broker also opens all PDBs on all instances it opens.
Benefits of Oracle Data Guard Broker
Using Dataguard Broker to manage Dataguard configuration provides several benefits. I am listing some of them here.- Simplified, centralized, and extended management
- Easy configuration of additional standbys
- Simplified switchover and failover operations
- Built-in monitoring and alert and control mechanisms
- Well integration with oracle RAC
NOTE: We will explore all these points later in others posts, how Dataguard Broker achieves them
Comments
Post a Comment