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

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

Recovering OCR using physical backup

Step 1: Identify OCR physical backup using the following command

Step 2: ocrdump

Step 3:  Bring down all instance and database before performing recovery of OCR.

Step 4: Restore backup using OCR file we have got in ocrconfig -showbackup command.

Step 5: Start CRS service on all node.

Step 6: Run […]

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