Home » RDBMS Server » Backup & Recovery » datafile copy error.
datafile copy error. [message #295878] Wed, 23 January 2008 16:09 Go to next message
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 #295882 is a reply to message #295878] Wed, 23 January 2008 16:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Put a semicolon after your last run command, ie:

datafilecopy '/d04/oradata/prod/system01.dbf','/d04/oradata/prod/users01.dbf',
'/d04/oradata/prod/users02.dbf','/d04/oradata/prod/system02.dbf';

[Updated on: Wed, 23 January 2008 16:50]

Report message to a moderator

Re: datafile copy error. [message #295890 is a reply to message #295878] Wed, 23 January 2008 17:15 Go to previous messageGo to next message
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


Re: datafile copy error. [message #295892 is a reply to message #295890] Wed, 23 January 2008 17:22 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In that case, it appears you are trying to create image copies. You should check Backing Up Tablespaces and Datafiles to Disk as Image Copies: Example.
Previous Topic: How to Set the Location for Disk Backups
Next Topic: Incremental level 1 merge backup
Goto Forum:
  


Current Time: Tue Nov 26 01:30:05 CST 2024