RMAN and Dataguard [message #670664] |
Wed, 18 July 2018 01:43  |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
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
|
|
|
|
Re: RMAN and Dataguard [message #670667 is a reply to message #670666] |
Wed, 18 July 2018 02:26   |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
I removed the spfile line
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/18/2018 11:26:10
RMAN-05501: aborting duplication of target database
RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause
RMAN> **end-of-file**
|
|
|
|
|