ITPub博客

首页 > 数据库 > Oracle > 删除过期备份报错RMAN-06207(转)

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

原创 Oracle 作者:peggypoon 时间:2009-10-22 18:15:10 0 删除 编辑

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 ND9m V0RMAN-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.y Ka0X0RMAN-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博客 ” ,链接:https://blog.itpub.net/21988588/viewspace-1028057/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论