Hi, I am Creating a Physical Standby using RMAN duplicate.
Primary is on 2Node RAC ASM and Standby is a single Node ASM.
run {
allocate channel pri1 type disk;
allocate channel pri2 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database
for standby
from active database
dorecover
set db_unique_name='stnewcf1'
set control_files='+DATA1/newcf/control01.ctl','+DATA1/newcf/control02.ctl'
set fal_client='newcf1'
set fal_server='stnewcf1'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(newcf1,stnewcf1)'
set log_archive_dest_1='LOCATION=+DATA1/NEWCF/ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stnewcf1'
set log_archive_dest_2='service=newcf1 ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=newcf'
nofilenamecheck;
}
rman target sys/******@newcf1 auxiliary sys/******@stnewcf1
RMAN> @dup.cmd
RMAN> run {
2> allocate channel pri1 type disk;
3> allocate channel pri2 type disk;
4> allocate channel prmy4 type disk;
5> allocate auxiliary channel stby type disk;
6> duplicate target database
7> for standby
8> from active database
9> dorecover
10> set db_unique_name=
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "set": expecting one of: "backup, db_file_name_convert, device, dorecover, force, from, high, logfile, nocheck, nofilenamecheck, noopen, noredo, noresume, open, password, pfile, pluggable, section, skip readonly, skip, spfile, tablespace, to restore point, undo, until restore point, until, using, ;"
RMAN-01007: at line 10 column 1 file: dup.cmd