Change SYS password in Data Guard environment

Today we are going have look at changing the password of SYS in the Data Guard environment. Normally we have seen how to change the password of the normal user. That seems a game of kids,  Now we must learn new things in Oracle RDBMS. Let’s have look at the steps we use to change […]

Read More

Steps to Create,Drop and Flashback Guaranteed restore point in Dataguard

CREATE GUARANTEED RESTORE POINT: Stop redo transport and redo apply a)If broker is not configured: On primary database: SQL> alter system set log_archive_dest_state_2=’defer’; On standby database: SQL> alter database recover managed standby database cancel; b)If broker is in place: DGMGRL> edit database db set state = ‘TRANSPORT-OFF’; DGMGRL> edit database db01 set state = ‘APPLY-OFF’; […]

Read More

MUST_RENAME_THIS_DATAFILE on RAC Standby

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 DGMGRL> disable configuration; Disabled. Step 2: set dg_broker_start parameter to a false value. SQL> alter system set dg_broker_start=false; System altered. Step 3: upgrade database using dbua Step 4: Start dg_broker by setting dg_broker_start to the true value. SQL> alter system set dg_broker_start=true; System altered. Step […]

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 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