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 AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
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
Purpose
Scope
Details
 Overview
 Requirements
 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.