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 220.127.116.11 and later
Oracle Net Services - Version 18.104.22.168 to 22.214.171.124 [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
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
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)|