My Oracle Support Banner

Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID 1075908.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Net Services - Version 11.2.0.4 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
Information in this document applies to any platform.
Checked for relevance on 21-AUG-2015



Goal

Step by step guide on how to create a physical standby database using RMAN DUPLICATE FROM ACTIVE DATABASE command without shutting down the primary and using primary active database files (No need to take a backup)

This is feature available in Oracle11g onwards.

In case you may want or need more about your current topic - please also access the Backup & Recover Community of Customers and Oracle Specialists directly via:
https://community.oracle.com/community/support/oracle_database/database_backup_and_recovery


Database Name :- chicago
Primary db_unique_name :- chicago
standby db_unique_name :- Boston

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.


For duplicating a NON-Standby database, see :
   <Note 452868.1> RMAN 'Duplicate From Active Database' Feature in 11G

Solution

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
Goal
Solution
 PROCEDURE:
 1. Prepare the production database to be the primary database
 2. Ensure that the sql*net connectivity is working fine.
 3. Create the standby database
 4. Start managed recovery
 5. Open standby database in Read Only (active dataguard)
References


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