rman-03002

今天我在自己的测试数据库上用RMAN作数据文件的备份，出现了rman-03002错误。如下:

RMAN> BACKUP FORMAT 'C:\BACKUP\RMAN2\TEST.BAK'
2> TABLESPACE USERS plus archivelog;

Starting backup at 03-7月 -08
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=11 stamp=658787803
input archive log thread=1 sequence=12 recid=13 stamp=659046512
input archive log thread=1 sequence=13 recid=15 stamp=659052082
input archive log thread=1 sequence=14 recid=17 stamp=659053712
input archive log thread=1 sequence=15 recid=19 stamp=659066437
input archive log thread=1 sequence=16 recid=21 stamp=659089902
input archive log thread=1 sequence=17 recid=23 stamp=659110213
input archive log thread=1 sequence=18 recid=25 stamp=659110399
input archive log thread=1 sequence=19 recid=27 stamp=659110545
input archive log thread=1 sequence=20 recid=29 stamp=659110665
channel ORA_DISK_1: starting piece 1 at 03-7月 -08
channel ORA_DISK_1: finished piece 1 at 03-7月 -08
piece handle=C:\BACKUP\RMAN2\TEST.BAK comment=NONE
channel ORA_DISK_1: starting piece 2 at 03-7月 -08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/03/2008 14:32:29
ORA-19504: failed to create file "C:\BACKUP\RMAN2\TEST.BAK"
ORA-27038: created file already exists
OSD-04010: option specified, file already exists

我想明明文件不存在呀,为什么说文件已经存在了呢？

上google查了一下RMAN-03003错误，大概知道有可能跟文件大小有关系，突然想到自己在前面已经设置了备份片的大小为15M(RMAN>configure channel device type disk

                     2 MAXPIECESIZE 15M);

于是我试着把前面的设置取消掉：rman>configure channel device type disk clear;

然后又备份刚才的数据文件与归档日志：

RMAN> BACKUP FORMAT 'C:\BACKUP\RMAN2\TEST.BAK'
2> TABLESPACE USERS plus archivelog;

哈哈，成功备份！

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

转载于:http://blog.itpub.net/13387766/viewspace-369036/