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.
The following two tabs change content below.
Gavin Soorma
Superb! Generally I never read whole articles but the way you wrote this information is simply amazing and this kept my interest in reading and I enjoyed it. You have got good writing skills.
Hi Nadeem – suppose you have a two node RAC with two instances – RAC1 and RAC2 … so in your spfile you would have say …
RAC1.db_cache_size=500M
RAC2.db_cache_size=500M
On your standby side you have only one instance say RAC1
so your spfile would be like this ….
RAC1.db_cache_size=500M
Basically all the parameter should be like it is a single instance database – so there should be NO RAC SPECIFIC parameters like say instance_number or instance_name …. take care