DG BROKER Activities Part – II

We have seen SWITCHOVER, FAILOVER and REINSTATE database in the previous article. DG Broker Activities Part – I In this article, we will see changing protection modes with DGMGRL and disabling and removing the configuration. Change protection modes Step 1: Change LOGXPTMODE to suitable option as per Protection mode.

Step 2: Change Protection mode […]

Read More

DG Broker Activities Part – I

We have configured DG Broker in the Previous article. In this article, we will see scenarios that we can handle with DGMGRL command prompt. To see how to configure DG broker. Configure DG broker 1. Change LogXptmode We can set LogXptMode to SYNC or ASYNC as per protection mode. Syntax :

2. Enable/disable APPLY […]

Read More

Prerequisites a Data Guard Broker Configuration

Before configuring Data Guard Broker, following prerequisites must be fulfilled. To know about DG Broker Architecture Data Guard Broker Architecture 1. To configure Data Guard Broker , we need an enterprise edition of a database. 2. We can configure data guard broker on a single instance and RAC [multiple] instance. 3. DG_BROKER_START initialization parameter must […]

Read More

Data Guard Broker Architecture

Before understanding, Architecture let us first understand the components of Data Guard Broker. To know more about it Oracle Dataguard Data Guard Components : Oracle Data Guard Broker consists of Client side and Server side components. Client Side Components Oracle Enterprise Manager DGMGRL [command line interface] 2. Server Side Components DMON Process Configuration Files DMON Process […]

Read More

Configure DG broker

The 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. You can manage a broker configuration using either the Oracle Enterprise Manager graphical user interface or the Data Guard command-line interface. To know more about it […]

Read More