creating physical standby using duplicate database
edited Dec 30, 2010 9:38PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 11 commentsAnswered
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'
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'
0