My Oracle Support Banner

WAN Zero Data Loss Failover with Oracle Data Guard 11.2 using a Near-DR Strategy (Broker version) (Doc ID 1489359.1)

Last updated on JANUARY 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
This procedure requires the installation of patches for Bug 13492916 and Bug 13774313 to all Oracle Database Homes involved.


Provide the ability to do a zero data loss failover to a remote standby without the impact of synchronous redo transmission over the WAN and without the necessity of creating a full local standby database.


 Database Administrators with a working knowledge of Data Guard who require remote zero data loss failovers.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
 Part #1 - Creating a minimal 'Near DR' standby.
 Step 1 - Create the audit directory
 Step 2 - Create the data and recovery directories
 Step 3 - Create a backup of the SYSTEM data files
 Step 4 - Create or copy the necessary files of the primary database on the Prod system
 Step 5 - Copy the files to the Near DR system
 Step 6 - Distribute and modify the files
 Step 7 - Mount the Near DR standby instance
 Step 8 - Offline/drop data files excluding the SYSTEM datafiles
 Step 9 - Restore the backup
 Step 10 - Configure TNSNAMES on the Near DR system
 Step 11 - Setup a LOG_ARCHIVE_DEST_n parameter to the Far DR standby on the Near DR database
 Step 12 - Configure TNSNAMES on the Prod system
 Step 13 - Add the NEARDR standby to your Broker configuration and configure its properties.
 Step 14 - Elevate the protection mode
 Step 15 - Verify the Near DR standby
 Part #2 - Failing over to the Far DR standby with Zero Data Loss
 Step 1 - Check #1
 Step 2 - Check #2
 Step 3 - Perform a zero data loss failover

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.