Home » RDBMS Server » Backup & Recovery » RMAN and Dataguard (Oracle 11.2.0.3.0, RHEL 5.8)
RMAN and Dataguard [message #670664] Wed, 18 July 2018 01:43 Go to next message
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 #670666 is a reply to message #670664] Wed, 18 July 2018 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"spfile" keyword is missing before "set".

Re: RMAN and Dataguard [message #670667 is a reply to message #670666] Wed, 18 July 2018 02:26 Go to previous messageGo to next message
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**
Re: RMAN and Dataguard [message #670668 is a reply to message #670667] Wed, 18 July 2018 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You removed a line that didn't exist?
How did you do that?

Re: RMAN and Dataguard [message #670685 is a reply to message #670667] Thu, 19 July 2018 11:48 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You must have changed more than that. Did you connect only to the auxiliary, not to the target?
Previous Topic: How to duplicate oracle database in multiple channels?
Next Topic: Missed Proc and Package from Oracle 11G r2 to Oracle 12C r2
Goto Forum:
  


Current Time: Thu Mar 28 05:25:35 CDT 2024