Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE
(Doc ID 1075908.1)
Last updated on JUNE 18, 2024
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Net Services - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
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.
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 |