1. Home
  2. Knowledge Base
  3. High Availability
  4. Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE
  1. Home
  2. Knowledge Base
  3. Oracle 11g
  4. Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE

Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE

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

The following two tabs change content below.

Gavin Soorma

Latest posts by Gavin Soorma (see all)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Comments

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

Reply to Gavin Soorma Cancel