Home » RDBMS Server » Backup & Recovery » datafile copy error.
datafile copy error. [message #295878] |
Wed, 23 January 2008 16:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pavan27
Messages: 50 Registered: December 2006 Location: bangalore
|
Member |
|
|
Hi,
i have to take datafile backups . i worte this script to take datafile copy. but i am getting error. i am not able to analyze problem. could you please send suggestion and modification too.
please find the script and errors.
RMAN> run {
allocate channel ch1 device type disk format '/d05/proddbfbkp/%U';
allocate channel ch2 device type disk format '/d05/proddbfbkp/%U';
backup (
datafile 1,4,5,6
filesperset 2)
datafilecopy '/d04/oradata/prod/system01.dbf','/d04/oradata/prod/users01.dbf','/d04/oradata/prod/users02.dbf','/d04/oradata/prod/system02.dbf'
}
when i ran this script i am getting following errors.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "}": expecting one of: "archivelog, backup, backupset, channel, comma, copy, controlfilecopy, current, database, datafile, datafilecopy, delete, diskratio, db_recovery_file_dest, filesperset, format, from, force, include, keep, (, maxsetsize, noexclude, nokeep, not, pool, plus, reuse, recovery, ;, skip, spfile, setsize, tablespace, tag"
RMAN-01007: at line 9 column 1 file: standard input
|
|
|
|
Re: datafile copy error. [message #295890 is a reply to message #295878] |
Wed, 23 January 2008 17:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pavan27
Messages: 50 Registered: December 2006 Location: bangalore
|
Member |
|
|
Thanks for your reply.
i put ; at the end of the line but this time i am getting different error. have a look at on this error.
allocated channel: ch1
channel ch1: sid=158 devtype=DISK
allocated channel: ch2
channel ch2: sid=161 devtype=DISK
Starting backup at 23-JAN-08
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/23/2008 14:33:27
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafilecopy name: /d04/oradata/prod/system01.dbf
|
|
|
|
Goto Forum:
Current Time: Wed Aug 21 18:01:27 CDT 2024
|