News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE

  • Posted by Gavin Soorma
  • On March 17, 2010
  • 2 Comments
  • active database, duplicate, rman, standby database creation

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.

Download the note ….

 

2 Comments

varundbest
  • Mar 30 2010
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.
Gavin Soorma
  • Jul 11 2010
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

Leave Reply

Your email address will not be published. Required fields are marked *