Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE
(Doc ID 1075908.1)
Last updated on FEBRUARY 01, 2022
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 18.104.22.168 and later
Oracle Net Services - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
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
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)|