一次rman备份失败后的成功处理

使用rman命令全备份数据库:

[oracle@primary u01]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Nov 27 21:25:33 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: DBWDN (DBID=3486622777)

RMAN> backup incremental level = 0 database format '/u01/bak/full_0_bak.bak';

[@more@]

Starting backup at 27-NOV-2012 21:26:35
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00007 name=/u01/app/oracle/oradata/dbwdn/perfstat.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/dbwdn/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/dbwdn/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/dbwdn/undotbs01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/dbwdn/ggs01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/dbwdn/test01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/dbwdn/users01.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/dbwdn/shkz_data_01.dbf
channel ORA_DISK_1: starting piece 1 at 27-NOV-2012 21:26:36
channel ORA_DISK_1: finished piece 1 at 27-NOV-2012 21:27:31
piece handle=/u01/bak/full_0_bak.bak tag=TAG20121127T212636 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting incremental level 0 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 27-NOV-2012 21:27:32
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/27/2012 21:27:33
ORA-19504: failed to create file "/u01/bak/full_0_bak.bak"
ORA-27038: created file already exists
Additional information: 1

RMAN> exit

居然报错！

系统上并没有类似的备份文件full_0_bak.bak，查看MeTalink，Doc ID: 1082911.6解决了这个问题，在备份集上加上替换字符标示%U

[oracle@primary bak]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Nov 27 21:32:14 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: DBWDN (DBID=3486622777)

RMAN> backup incremental level = 0 database format '/u01/bak/%U.bak';

Starting backup at 27-NOV-2012 21:32:40
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00007 name=/u01/app/oracle/oradata/dbwdn/perfstat.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/dbwdn/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/dbwdn/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/dbwdn/undotbs01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/dbwdn/ggs01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/dbwdn/test01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/dbwdn/users01.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/dbwdn/shkz_data_01.dbf
channel ORA_DISK_1: starting piece 1 at 27-NOV-2012 21:32:41
channel ORA_DISK_1: finished piece 1 at 27-NOV-2012 21:33:26
piece handle=/u01/bak/03nrctnp_1_1.bak tag=TAG20121127T213241 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting incremental level 0 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 27-NOV-2012 21:33:27
channel ORA_DISK_1: finished piece 1 at 27-NOV-2012 21:33:28
piece handle=/u01/bak/04nrctp6_1_1.bak tag=TAG20121127T213241 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 27-NOV-2012 21:33:28

RMAN>

备份成功完成！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28227905/viewspace-1059830/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28227905/viewspace-1059830/