删除过期备份报错RMAN-06207(转）

http://space.itpub.net/4227/viewspace-441088

由于备份文件被手工删除，导致了这个小bug的产生。

昨天发现备份空间马上就要满了，而备份正在进行之中，于是手工删除了几个RMAN的备份文件。

随后删除过期对象的时候出现了RMAN-06207和RMAN-06208错误：

RMAN> delete obsolete;

RMAN retention policy will be applied to the commandITPUB个人空间(w"V$S-V}{:cXd
RMAN retention policy is set to recovery window of 14 days
7]W]Or ? u Gg8s0Deleting the following obsolete backups and copies:
(T/F K f0B0Type Key Completion Time Filename/HandleITPUB个人空间jh^Kj8h5G0`4^Gl
-------------------- ------ ------------------ --------------------
3Tg%I~,P7s1?)Y$` E0Backup Set 1611 14-AUG-08 ITPUB个人空间*C8k6@cp
Backup Piece 1611 14-AUG-08 /data1/backup/jiangsu/20080814_iljnvkad_1_1
s&^2qg0Backup Set 1612 14-AUG-08
WQn%EN0 Backup Piece 1612 14-AUG-08 /data1/backup/jiangsu/20080814_imjnvkad_1_1

RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due
q+w%z ND9mV0RMAN-06208: to mismatched status. Use CROSSCHECK command to fix statusITPUB个人空间a5r*^ E8t^t
RMAN-06210: List of Mismatched objectsITPUB个人空间*U7pL?E"?4y6D;Pkp&nQ
RMAN-06211: ==========================ITPUB个人空间)qx~K/SR8d
RMAN-06212: Object Type Filename/HandleITPUB个人空间?-ch+m"Rcp
RMAN-06213: --------------- ---------------------------------------------------
Kjk;?.r.yKa0X0RMAN-06214: Backup Piece /data1/backup/jiangsu/20080814_iljnvkad_1_1ITPUB个人空间8Q*LS$XM
RMAN-06214: Backup Piece /data1/backup/jiangsu/20080814_imjnvkad_1_1

如果只是产生这个错误并不奇怪，奇怪的是进行CROSSCHECK检查的时候，根本就不检查这个备份：

RMAN> crosscheck backup;

using channel ORA_DISK_1ITPUB个人空间2f8ZR"EDg8q
crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间yS5h }-^F'g1U7B)X
backup piece handle=/data1/backup/jiangsu/20080901_m3jpgk19_1_1 recid=1700 stamp=664293417
2B H/f*[M]N0crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间+HM CS,rR2Y
backup piece handle=/data1/backup/jiangsu/20080901_m2jpgk18_1_1 recid=1701 stamp=664293417ITPUB个人空间$`x QP#lxM
crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间cS9D_Vt
backup piece handle=/data1/backup/jiangsu/20080901_c-499478642-20080901-00 recid=1702 stamp=664294238ITPUB个人空间5P%_"T#w#u

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

转载于:http://blog.itpub.net/21988588/viewspace-1028057/