Home » RDBMS Server » Backup & Recovery » Running Script for duplicate Sending Error
Running Script for duplicate Sending Error [message #604712] Fri, 03 January 2014 05:08 Go to next message
zulfiqaralimemon
Messages: 10
Registered: April 2010
Location: Pakistan
Junior Member
my initdb3.ora
===============
audit_file_dest='D:\db3\adump'
background_dump_dest='D:\db3\bdump'
compatible='10.2.0.1.0'
control_files='D:\db3\control01.ctl','D:\db3\control02.ctl','D:\db3\control03.ctl'
core_dump_dest='D:\db3\cdump'
cursor_sharing='SIMILAR'
db_block_size=8192
db_create_file_dest='D:\db3\'
db_create_online_log_dest_1='D:\db3\redolog\'
db_domain=''
db_file_multiblock_read_count=16
db_file_name_convert='C:\oracle\product\10.2.0\oradata\orcl\','D:\db3\','C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\','D:\db3\','C:\ORACLE \PRODUCT\10.2.0\ORADATA\ORCL\ORCL\DATAFILE\','D:\db3\'
log_file_name_convert='C:\oracle\product\10.2.0\oradata\orcl\','D:\db3\REDOLOG01.LOG','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\','D:\db 3\REDOLOG02.LOG','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\','D:\db3\REDOLOG03.LOG'
db_name='db3'
db_recovery_file_dest='D:\db3\flash_recovery_area\'
db_recovery_file_dest_size=6442450944
dg_broker_start=TRUE
dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
global_names=TRUE
job_queue_processes=10
log_archive_dest_1='location=D:\db3\archive valid_for=(all_logfiles,all_roles)'

nls_date_format='YYYY/MM/DD HH24:MI:SS'
nls_time_format='YYYY/MM/DD HH24:MI:SS'
open_cursors=300
optimizer_mode='all_rows'
pga_aggregate_target=96468992
processes=150
query_rewrite_integrity='TRUSTED'
remote_login_passwordfile='EXCLUSIVE'
sga_target=290455552
sql_trace=TRUE
standby_file_management='AUTO'
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
user_dump_dest='D:\db3\udump'



I am new to oracle duplicating orcl to db3
my db3 instance is in nomount stage. Running this script


c:\windows\system32>rman target sys/oracle@orcl auxiliary sys/abc@db3

RMAN> RUN
2> {
3> SET NEWNAME FOR DATAFILE 1 TO "D:\DB3\SYSTEM01.DBF";
4> SET NEWNAME FOR DATAFILE 2 TO "D:\DB3\UNDOTBS01.DBF";
5> SET NEWNAME FOR DATAFILE 3 TO "D:\DB3\SYSAUX01.DBF";
6> SET NEWNAME FOR DATAFILE 4 TO "D:\DB3\USERS01.DBF";
7> SET NEWNAME FOR DATAFILE 1 TO "D:\DB3\MSTBS01.DBF";
8>
9> DUPLICATE TARGET DATABASE TO db3
10> PFILE= C:\oracle\product\10.2.0\db_1\database\initdb3.ora
11> NOFILENAMECHECK
12> LOGFILE GROUP 1 ("D:\DB3\REDOLOG01.LOG") SIZE 50M;
13> LOGFILE GROUP 2 ("D:\DB3\REDOLOG02.LOG") SIZE 50M;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "logfile": expecting one of: "allocate, alter
ackup, beginline, blockrecover, catalog, change, copy, convert, crosscheck, c
igure, duplicate, debug, delete, execute, endinline, flashback, host, mount,
n, plsql, recover, release, replicate, report, restore, resync, }, set, setli
, sql, switch, startup, shutdown, send, show, transport, validate"
RMAN-01007: at line 13 column 1 file: standard input

RMAN> LOGFILE GROUP 3 ("D:\DB3\REDOLOG03.LOG") SIZE 50M;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "logfile": expecting one of: "allocate, alter
ackup, beginline, blockrecover, catalog, change, connect, copy, convert, crea
crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flas
ck, host, {, library, list, mount, open, print, quit, recover, register, rele
, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, s
setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport
pgrade, unregister, validate"
RMAN-01007: at line 1 column 1 file: standard input

RMAN> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, back
beginline, blockrecover, catalog, change, connect, copy, convert, create, cr
check, configure, duplicate, debug, delete, drop, exit, endinline, flashback,
st, {, library, list, mount, open, print, quit, recover, register, release, r
ace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, se
mit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgr
, unregister, validate"
RMAN-01007: at line 1 column 1 file: standard input

what to do next

Zulfiqar
Re: Running Script for duplicate Sending Error [message #604736 is a reply to message #604712] Fri, 03 January 2014 10:22 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The duplicate command ends at the first ';'.
Do you see the error now?
Hint: look at the end of "LOGFILE GROUP 1"

Previous Topic: backup current controlfile vs backup controlfile copy
Next Topic: Incremental backup type
Goto Forum:
  


Current Time: Fri Mar 29 02:15:08 CDT 2024