Loading....

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 ….

Please follow and like us:

Last Update: May 30, 2020  

March 17, 2010 218 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, , ,

2 thoughts on “Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE

  1. varundbest

    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.

  2. Gavin Soorma

    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 a Comment

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

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?