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

Flashback Database after Resetlogs in data guard

In this Post, We will see How enabling Flashback helps us in case of Primary Database resetlogs. Flashback Database and it’s Benefits in Data Guard Environment Here I am simulating a scenario of Point in Time Recovery. My standby database is in sync with Primary Database and I have restored an old backup in Primary Database […]

Read More

Flashback Database and it’s Benefits in Data Guard Environment

Let us first understand Flashback Database : With Flashback Database technology of Oracle, you can quickly bring your database to an earlier point in time by undoing all changes that took place since that time. This operation is fast because you do not need to restore backups. Oracle Flashback Database, lets you quickly recover the […]

Read More

Restoring physical standby backup to create new standby database

RMAN Physical Standby Database backup is used to create another physical standby database. Offloading Backup to Standby in Data Guard I have already taken backup of one of my physical standby database. Use following steps to restore physical standby backup to create a new physical standby database. Step 1: Create the directory on the server […]

Read More

Offloading Backup to Standby in Data Guard

As Oracle Data Guard came up with many advantages, One of its benefits is we can offload backup to Physical Standby Database. Using the RMAN Recovery Catalog in a Data Guard Configuration   We need to user Recover Catalog to offload backup to the standby database. We will offload backup to the physical standby database […]

Read More

Using the RMAN Recovery Catalog in a Data Guard Configuration

Recover Catalog: A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. Benefits and Restrictions of RMAN in DataGuard In easy words, RMAN metadata is stored in a different database instead of the control file. That database works as a repository. Recovery catalog and data guard : Use of the RMAN recovery […]

Read More

Benefits and Restrictions of RMAN in DataGuard

As we use RMAN to backup and restore the database in Simple scenarios. We can use it in Data Guard Environment same way. Oracle Dataguard Even we can use Physical Standby database backup to restore the Primary database and to recover the Primary database. But with some consideration as follow : The recovery catalog is […]

Read More

Benefits of Using Data Guard Broker

Oracle Data Guard Broker automates configuration and monitoring tasks for data guard. Data Guard Broker Architecture With Oracle Data Guard Broker we can enable FAST_START FAILOVER which helps in case of crash scenario or inoperativeness of production, it directs Primary Database role to standby database in this scenarios. It provides simplified switchover and failover operations. […]

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