Dear Buddies,
Seasonal Greetings.
I am using these commands to perform my backup.
backup database tag "everyday_full_bkup" format='D:\Oracle_Backup\Database_Name\%I_%T.bkp';
Can I use the .bkp?
This is the message I receive when I run the above given command.
Starting backup at 11-MAY-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=D:\ORACLE\DATA\MARSDB\UNDO_01.DBF
input datafile fno=00001 name=D:\ORACLE\DATA\MARSDB\SYSTEM_01.DBF
input datafile fno=00004 name=D:\ORACLE\DATA\MARSDB\DATA_01.ORA
input datafile fno=00005 name=D:\ORACLE\DATA\MARSDB\INDEXES_01.ORA
input datafile fno=00003 name=D:\ORACLE\DATA\MARSDB\SYSAUX_01.DBF
input datafile fno=00006 name=D:\ORACLE\DATA\MARSDB\XXSMALLTABS_01.ORA
channel ORA_DISK_1: starting piece 1 at 11-MAY-10
channel ORA_DISK_1: finished piece 1 at 11-MAY-10
piece handle=D:\ORACLE_BACKUP_DATA\MARSDB\1970380511_20100511 tag=EVERYDAY_FULL_BKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 11-MAY-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/11/2010 11:03:01
ORA-19504: failed to create file "D:\ORACLE_BACKUp\DatabaseName\1970380511_20100511"
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists
Seeing this error, I deleted the backup:
list backup;
delete backup piece n;
n is based on the number i see in the list backup.
Since, I thought configure channel might help, tried this but still getting the same error.
RMAN>
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'the path\%F.bkp';
BACKUP DATABASE tag "everyday_full_bkup";
Would like to clarify, if the configure channel is only to set the path where the backup should be done as well as the naming convention?
Just to ensure that everything is fine, I checked
crosscheck backup;
and everything is fine.
I even tried
rman> backup database;
and still getting the same error.
Please throw some light on this. Please guide me. I am desperate.
Thanking you in advance.
Cheers!
Nith
Edited by: user645399 on May 11, 2010 11:00 AM
Edited by: user645399 on May 11, 2010 11:36 AM
Edited by: user645399 on May 11, 2010 11:53 AM