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 : DGMGRL> EDIT DATABASE TESTDB […]
Category: DATAGUARD
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]