Overview: Oracle Data Guard Broker

In this blog post, we’ll be covering the Overview of Oracle Data Guard Broker including its functions and components.

Oracle Data Guard

Oracle Data Guard is a feature that was introduced in Oracle Database 10g. In Data Guard, there is a primary database and one or more standby databases that are constantly kept in sync with the primary database that prevents loss of data in situations of data disasters and corruption. It provides comprehensive services that create, manage and monitor one or more standby databases. Data Guard can switch any standby database to the production unit, minimizing the downtime associated with the outage.

What Is The Oracle Data Guard Broker?

The Oracle Data Guard Broker logically groups these primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit. The user can manage a broker configuration using either Oracle Enterprise Manager Cloud Control (Cloud Control) or the Oracle Data Guard command-line interface DGMGRL. It supports multitenant container databases (CDBs) within a broker configuration.

Oracle Data Guard Broker Functions

The Data Guard Broker performs the following functions:
a) Creates Data Guard configuration that includes one primary, one or more new or existing standby databases, redo transport service, and log apply service.
b) Adds an additional new or existing standby database to an existing data guard configuration.
c) Manages Protection Mode (Maximum Performance, Maximum Availability, Maximum Protection) for the broker configuration.
d) Invokes Switchover or Failover with a single command.
e) Monitors the status of the entire configuration, captures diagnostic information, reports statistics such as the Redo Apply rate and the redo generation rate.
f) Assesses whether a database is ready to become a primary.

Oracle Data Guard Broker Components

a) Client Interface: DGMGRL (CLI) and OEM Cloud Control (OEM CC) are broker client-side interfaces to define and manage a configuration consisting of primary and standby databases.

Related/Further Readings

• Oracle EBS (R12) On-Premise to OCI Migration (Lift & Shift): 10 Things You Must Consider
• OCI vs OCI -C: IaaS from Oracle
• Oracle EBS Cloud Manager: New Release (19.3.1) Is Now Available
• Introduction to Performance Tuning In Oracle Database
• Database Performance Tuning On-Premise & Cloud: Step by Step Hands-On Lab Exercise

Next Task For You

If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and wants to clear Oracle Cloud Database Service Specialist[1Z0-1093-21] & Oracle Cloud Autonomous Database Certification[1Z0-931-21] with 18 Hands-On labs, then register for a FREE class, and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA.