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 11.2.0.3 to 11.2.0.4 [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.

Purpose

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.

Scope

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

Details

	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.