Disabling FAST_START Failover

To know about Fast Start Failover in Data Guard To disable Fast_Start failover apply following command :

When we perform above command Fast_Start failover is first disabled on target standby database with data guard broker then it is disabled from the primary database. Then these changes are propagated to all standby database present in the […]

Read More

Simulating and Restriction After enabling FAST_START failover

Here I am simulating scenario for fast-start failover. Configuring Fast-Start Fail Over Step 1: View fast_start failover is enabled or not.

Step 2: I am aborting the Simulating and Restriction After enabling FAST_START failoverdatabase.

Step 3: Check observer

Step 4: Now again I am starting a primary database.

Step 5: check […]

Read More

Configuring Fast-Start Fail Over

We have seen overview and prerequisites of fast-start failover in the previous post. Fast Start Failover in Data Guard Steps to configure fast start fail over . Step 1 : Connect to dgmgrl and check the configuration

Step 2 : set faststartfailovertarget property.

Step 3 : set protection mode if not already set […]

Read More

Fast Start Failover in Data Guard

Oracle Data Guard work on two database roles Primary and Standby. In the previous article, we have seen switching the role of Primary and standby database and failover Primary role to Standby database manually. To see Manual Switch Over Manual SwitchOver in Oracle To see Manual Fail Over Manual Failover in Data Guard With Oracle Data Guard […]

Read More

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

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