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 JANUARY 12, 2023

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Oracle Net Services - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.


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.

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


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
 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)

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