Upgrading Oracle Database with a Physical Standby Database

In this article, we can upgrade the 11g database to 12c with the help of DataGaurd Primary DB Name Standby DB Name Database Version Upgrade Version UPGDB UPGDB 11.2.0.4.0 12.1.0.2.0 Step 1: Install 12.1.0.2 binaries on both Primary and Standby Server. Step 2: Shut down Primary Database. Step 3: Shut down Standby Database. Step 4: […]

Read More

Recover Datafile in Standby Database in Data Guard Environment

In the previous article, we have to seen Recovering Primary Database Datafile using Standby Database if it’s not deleted from Standby Database. Recover Data File in Primary Database in Data Guard Environment Here we will see what if datafile gets corrupted or deleted from Standby Database. Step 1: In the below code, we can see […]

Read More

Understanding and managing client connectivity

While managing Data Guard Standby databases in our environment one of the key responsibility of DBA is End-user connectivity to a proper database or we can say clients connect to the correct database even in case of failover. To know Oracle DataGuard Oracle Dataguard Architecture   Your client connectivity should be managed in such a […]

Read More

Recover Data File in Primary Database in Data Guard Environment

Recovering Data File in Primary Database from the standby database. You have two approaches for data file restoration when your data file gets corrupted or deleted in data guard environment. Restore from RMAN backup Recover it from Standby Database. In our routine, we use the first approach where we simply restore it using RMAN restore command […]

Read More

DGMGRL error ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

A common error we face while doing switchover operation using DGMGRL.

We can see in above code switchover operation is not completed it needs manual startup of new DR database. To overcome this check your static connect identifier for DR and production database.

Change according to your database and server details.

Now […]

Read More

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