Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE
- Posted by Gavin Soorma
- On March 17, 2010
- 2 Comments
Purpose
This note explains the procedure of creating a Physical Standby database using 11g RMAN DUPLICATE FROM ACTIVE DATABASE feature which is now available in 11g Release 1 onwards. This enables us to create a physical standby database without having to take a backup of the primary database as a prerequisite step.
Environment
Primary Database DB_UNIQUE_NAME: genoa1_js
Standby Database DB_UNIQUE_NAME: genoa1_fc
ORACLE_SID: genoa1
Primary hostname: oatu037
Standby hostname: drou037
Oracle software version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit
Enable Force Logging on the Primary database
SQL> alter database force logging;
Database altered.
2 Comments