Few days ago i got the activity to create the 2 NODE RAC DR on EXADATA for 2 NODE RAC Production. Here I am listing few issues that made this activity perfect case for Data Guard beginners Environment:Production Database Name: Financedb_unique_name : finance Standby Database Name : Finstandbydb_unique_name : finstandby Production OS Node: agoracledba1 agoracledba2Standby […]

Read More

Upgrading an Oracle Data Guard Broker Configuration

Step 1: Login to dgmgrl and disable configuration before upgradation

Step 2: set dg_broker_start parameter to a false value.

Step 3: upgrade database using dbua Step 4: Start dg_broker by setting dg_broker_start to the true value.

Step 5: connect to dgmgrl

If you want to be updated with all our articles […]

Read More

Creating Data Guard with 2 node RAC Primary and 2 node RAC standby

In this article, we will see the creation of DataGuard with 2 node RAC Primary Database and 2 node RAC Standby database. Primary Database Standby Database Primary Instance Standby Instance RACDB DGRACDB RAC1 DGRAC RAC2 DGRAC1 What I have already done 1. My production database is up and running with 2 node RAC Oracle Version […]

Read More

Using DBMS_ROLLING to Upgrade the Oracle Database

We know the pain of Upgrading Database, taking hours of downtime. But, Oracle comes with a new feature called DBMS_ROLLING from 12C Release 1. If you are having a license for Active Data Guard this method will minimize your downtime for upgrade or patching. This method is well automated. You just need 90 seconds 120 […]

Read More

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 Step 1: Install 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