删除过期备份报错RMAN-06207

　　发现备份空间马上就要满了，而备份正在进行之中，于是手工删除了几个RMAN的备份文件。
　　随后删除过期对象的时候出现了RMAN06207和RMAN06208错误：
　　RMAN> delete obsolete;
　　RMAN retention policy will be applied to the command
　　RMAN retention policy is set to recovery window of 14 days
　　Deleting the following obsolete backups and copies:
　　Type Key Completion Time Filename/Handle
　　Backup Set 1611 14AUG08
　　Backup Piece 1611 14AUG08 /data1/backup/jiangsu/20080814_iljnvkad_1_1
　　Backup Set 1612 14AUG08
　　Backup Piece 1612 14AUG08 /data1/backup/jiangsu/20080814_imjnvkad_1_1
　　RMAN06207: WARNING: 2 objects could not be deleted for DISK channel(s) due
　　RMAN06208: to mismatched status. Use CROSSCHECK command to fix status
　　RMAN06210: List of Mismatched objects
　　RMAN06211:
　　RMAN06212: Object Type Filename/Handle
　　RMAN06213:
　　RMAN06214: Backup Piece /data1/backup/jiangsu/20080814_iljnvkad_1_1
　　RMAN06214: Backup Piece /data1/backup/jiangsu/20080814_imjnvkad_1_1
　　如果只是产生这个错误并不奇怪，奇怪的是进行CROSSCHECK检查的时候，根本就不检查这个备份：
　　RMAN> crosscheck backup;
　　using channel ORA_DISK_1
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080901_m3jpgk19_1_1 recid1700 stamp664293417
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080901_m2jpgk18_1_1 recid1701 stamp664293417
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080901_c4994786422008090100 recid1702 stamp664294238
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080902_m5jphne8_1_1 recid1703 stamp664329673
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080902_m6jphnei_1_1 recid1704 stamp664329683
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080902_m7jphnei_1_1 recid1705 stamp664329683
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080902_m8jphocp_1_1 recid1706 stamp664330649
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080902_m9jphou5_1_1 recid1707 stamp664331206
　　crosschecked backup piece: found to be ’AVAILABLE’
　　backup piece handle/data1/backup/jiangsu/20080902_c4994786422008090200 recid1708 stamp664331208
　　Crosschecked 9 objects
　　这种情况可以通过CROSSCHECK BACKUPPIECE的方式对问题备份进行单独的检查：
　　RMAN> crosscheck backuppiece ’/data1/backup/jiangsu/20080814_iljnvkad_1_1’;
　　using channel ORA_DISK_1
　　crosschecked backup piece: found to be ’EXPIRED’
　　backup piece handle/data1/backup/jiangsu/20080814_iljnvkad_1_1 recid1611 stamp662688077
　　Crosschecked 1 objects
　　RMAN> delete obsolete;
　　RMAN retention policy will be applied to the command
　　RMAN retention policy is set to recovery window of 14 days
　　using channel ORA_DISK_1
　　Deleting the following obsolete backups and copies:
　　Type Key Completion Time Filename/Handle
　　Backup Set 1611 14AUG08
　　Backup Piece 1611 14AUG08 /data1/backup/jiangsu/20080814_iljnvkad_1_1
　　Backup Set 1612 14AUG08
　　Backup Piece 1612 14AUG08 /data1/backup/jiangsu/20080814_imjnvkad_1_1
　　Do you really want to delete the above objects (enter YES or NO)? yes
　　deleted backup piece
　　backup piece handle/data1/backup/jiangsu/20080814_iljnvkad_1_1 recid1611 stamp662688077
　　Deleted 1 objects
　　RMAN06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
　　RMAN06208: to mismatched status. Use CROSSCHECK command to fix status
　　RMAN06210: List of Mismatched objects
　　RMAN06211:
　　RMAN06212: Object Type Filename/Handle
　　RMAN06213:
　　RMAN06214: Backup Piece /data1/backup/jiangsu/20080814_imjnvkad_1_1
　　进行检查之后的备份就可以顺利的删除了。
　　RMAN> crosscheck backupset 1612;
　　using channel ORA_DISK_1
　　crosschecked backup piece: found to be ’EXPIRED’
　　backup piece handle/data1/backup/jiangsu/20080814_imjnvkad_1_1 recid1612 stamp662688078
　　Crosschecked 1 objects
　　RMAN> delete backupset 1612;
　　using channel ORA_DISK_1
　　List of Backup Pieces
　　BP Key BS Key Pc# Cp# Status Device Type Piece Name
　　1612 1612 1 1 EXPIRED DISK /data1/backup/jiangsu/20080814_imjnvkad_1_1
　　Do you really want to delete the above objects (enter YES or NO)? yes
　　deleted backup piece
　　backup piece handle/data1/backup/jiangsu/20080814_imjnvkad_1_1 recid1612 stamp662688078
　　Deleted 1 objects
　　使用CROSSCHECK BACKUPSET的方式也可以，但是比较单独指定被删除的备份，而通过CROSSCHECK BACKUP是无法找到的。其他手工删除的备份，则没有这个问题。