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 […]
Category: DATAGUARD
Steps to recover the standby database’s datafile using a backup of the primary database’s data file
Recently we have faced an issue for one of our data guard environment, we will discuss those steps here which we followed to fix this issue. For our Physical standby database, one of the filesystems (/u01/data/) got corrupted, due to which when we added datafiles in primary, the changes not applied on the standby and […]
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’; […]
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 […]
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 […]
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 […]
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 […]
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: […]
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 […]
Managing Client Connectivity using DBMS_SERVICE package and After Startup Trigger
In the previous Article, we have seen understanding and managing user connectivity in Data Guard Environment. Understanding and managing client connectivity In this Article, we will see Creating After Startup Trigger which will manage service for different database roles. Step 1: Create services in a Primary database with DBMS_SERVICE package. Note: We need to […]