High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

creating physical standby using duplicate database

Hi All,
I am trying to create a physical standby db using rman duplicate database

Platform: win xp
DB: 11.2.0

Both Primary & Standby will reside in the same box. I am using the following command to duplicate the database.

RUN {
ALLOCATE CHANNEL d1 TYPE DISK;
ALLOCATE CHANNEL d2 TYPE DISK;
ALLOCATE AUXILIARY CHANNEL cnv1 TYPE DISK;
ALLOCATE AUXILIARY CHANNEL cnv2 TYPE DISK;
DUPLICATE TARGET DATABASE
    FOR STANDBY
    FROM ACTIVE DATABASE
    DORECOVER
    SPFILE
        SET db_unique_name='stdby'
        SET control_files='D:\oracle\oradata\stdby\control01.ctl'
        SET log_file_name_convert='D:\oracle\oradata\logmnr','D:\oracle\oradata\stdby'
        SET log_archive_dest_1='location=D:\oracle\oradata\stdby valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=stdby'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center