RMAN备份时出现ORA-27038: created file already exists

       今天在测试备份SYSTEM表空间和其他表空间的时候是否包含当前控制文件时，随意写了个备份语句，竟然报错，有换了几个目录，确定没有这个文件，通过list backup查询也没有同门备份集，

 

RMAN> backup datafile 1 format '/oracle/backup/system.bk';Starting backup at 30-JUL-2013 11:25:29using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/oracle/app/oracle/oradata/orcl/system01.dbfchannel ORA_DISK_1: starting piece 1 at 30-JUL-2013 11:25:29channel ORA_DISK_1: finished piece 1 at 30-JUL-2013 11:25:54piece handle=/oracle/backup/system.bk tag=TAG20130730T112529 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 30-JUL-2013 11:25:55RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/30/2013 11:25:55ORA-19504: failed to create file "/oracle/backup/system.bk"ORA-27038: created file already existsAdditional information: 1

尝试下面的备份方式，却可以。原来我的格式写得不对，太粗心了。

RMAN> backup datafile 1;Starting backup at 30-JUL-2013 11:20:12using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/oracle/app/oracle/oradata/orcl/system01.dbfchannel ORA_DISK_1: starting piece 1 at 30-JUL-2013 11:20:12channel ORA_DISK_1: finished piece 1 at 30-JUL-2013 11:20:37piece handle=/oracle/app/oracle/flash_recovery_area/ORCL/backupset/2013_07_30/o1_mf_nnndf_TAG20130730T112012_8zgd7dl5_.bkp tag=TAG20130730T112012 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 30-JUL-2013 11:20:38channel ORA_DISK_1: finished piece 1 at 30-JUL-2013 11:20:39piece handle=/oracle/app/oracle/flash_recovery_area/ORCL/backupset/2013_07_30/o1_mf_ncsnf_TAG20130730T112012_8zgd86xh_.bkp tag=TAG20130730T112012 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02Finished backup at 30-JUL-2013 11:20:39

正确做法：

RMAN> backup datafile 1 format '/oracle/backup/system_%U';Starting backup at 30-JUL-2013 11:26:26using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/oracle/app/oracle/oradata/orcl/system01.dbfchannel ORA_DISK_1: starting piece 1 at 30-JUL-2013 11:26:26channel ORA_DISK_1: finished piece 1 at 30-JUL-2013 11:26:41piece handle=/oracle/backup/system_65og1kb2_1_1 tag=TAG20130730T112626 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 30-JUL-2013 11:26:43channel ORA_DISK_1: finished piece 1 at 30-JUL-2013 11:26:44piece handle=/oracle/backup/system_66og1kbh_1_1 tag=TAG20130730T112626 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03Finished backup at 30-JUL-2013 11:26:44