Step by Step Creation of Cascading Standby

Cascading Standby Database works in two layers. As per normal the standby configuration, standby database receives redo from the primary database. In Layer 2 standby database will receive redo from another standby database rather than directly from the primary database. With Cascading standby database we can minimize the load of Primary Database. As per Oracle […]

Read More

Creating Fast Incremental Backup

Creating Fast Incremental Backups :  We have seen how block change tracking is enabled. Enable block change tracking on the physical standby database The motive of Incremental backup is to backup only those blocks which are changed since the last zero or level 1 incremental backup. Block change tracking provides a boost to this. If […]

Read More

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