删除备份的时候无法删除

在进行备份之后，先删除了备份文件，然后在进行删除备份记录，无法删除，显示如下：

RMAN> delete copy;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=145 devtype=DISKspecification does not match any archive log in the recovery catalogList of Datafile CopiesKey     File S Completion Time Ckp SCN    Ckp Time        Name------- ---- - --------------- ---------- --------------- ----17      1    A 13-JUN-14       634156     13-JUN-14       +KEL/ipap/datafile/system.257.85009143119      2    A 13-JUN-14       634203     13-JUN-14       +KEL/ipap/datafile/undotbs1.258.85009154318      3    A 13-JUN-14       634187     13-JUN-14       +KEL/ipap/datafile/sysaux.256.85009150720      4    A 13-JUN-14       634205     13-JUN-14       +KEL/ipap/datafile/users.259.850091545Do you really want to delete the above objects (enter YES or NO)? yRMAN-06207: WARNING: 4 objects could not be deleted for DISK channel(s) dueRMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix statusRMAN-06210: List of Mismatched objectsRMAN-06211: ==========================RMAN-06212:   Object Type   Filename/HandleRMAN-06213: --------------- ---------------------------------------------------RMAN-06214: Datafile Copy   +KEL/ipap/datafile/system.257.850091431RMAN-06214: Datafile Copy   +KEL/ipap/datafile/undotbs1.258.850091543RMAN-06214: Datafile Copy   +KEL/ipap/datafile/sysaux.256.850091507RMAN-06214: Datafile Copy   +KEL/ipap/datafile/users.259.850091545

进行检查，检查过期的文件，然后再次进行删除即可：

RMAN> crosscheck copy;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=145 devtype=DISKspecification does not match any archive log in the recovery catalogvalidation failed for datafile copydatafile copy filename=+KEL/ipap/datafile/system.257.850091431 recid=17 stamp=850091498validation failed for datafile copydatafile copy filename=+KEL/ipap/datafile/undotbs1.258.850091543 recid=19 stamp=850091544validation failed for datafile copydatafile copy filename=+KEL/ipap/datafile/sysaux.256.850091507 recid=18 stamp=850091538validation failed for datafile copydatafile copy filename=+KEL/ipap/datafile/users.259.850091545 recid=20 stamp=850091545Crosschecked 4 objects

RMAN> delete copy;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=145 devtype=DISKspecification does not match any archive log in the recovery catalogList of Datafile CopiesKey     File S Completion Time Ckp SCN    Ckp Time        Name------- ---- - --------------- ---------- --------------- ----17      1    X 13-JUN-14       634156     13-JUN-14       +KEL/ipap/datafile/system.257.85009143119      2    X 13-JUN-14       634203     13-JUN-14       +KEL/ipap/datafile/undotbs1.258.85009154318      3    X 13-JUN-14       634187     13-JUN-14       +KEL/ipap/datafile/sysaux.256.85009150720      4    X 13-JUN-14       634205     13-JUN-14       +KEL/ipap/datafile/users.259.850091545Do you really want to delete the above objects (enter YES or NO)? ydeleted datafile copydatafile copy filename=+KEL/ipap/datafile/system.257.850091431 recid=17 stamp=850091498deleted datafile copydatafile copy filename=+KEL/ipap/datafile/undotbs1.258.850091543 recid=19 stamp=850091544deleted datafile copydatafile copy filename=+KEL/ipap/datafile/sysaux.256.850091507 recid=18 stamp=850091538deleted datafile copydatafile copy filename=+KEL/ipap/datafile/users.259.850091545 recid=20 stamp=850091545Deleted 4 objects

在备份的时候，一种是物理备份，一种是逻辑备份

查看备份集的时候使用：

RMAN> list backup;List of Backup Sets===================BS Key  Type LV Size       Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------3       Full    6.80M      DISK        00:00:01     13-JUN-14              BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20140613T003226        Piece Name: /home/oracle/flash_recovery_area/IPAP/autobackup/2014_06_13/o1_mf_s_850091546_9sob8ck2_.bkp  Control File Included: Ckp SCN: 634210       Ckp time: 13-JUN-14  SPFILE Included: Modification time: 13-JUN-14

查看镜像备份的时候使用：

RMAN> list copy;specification does not match any archive log in the recovery catalogList of Datafile CopiesKey     File S Completion Time Ckp SCN    Ckp Time        Name------- ---- - --------------- ---------- --------------- ----21      1    A 13-JUN-14       634486     13-JUN-14       +KEL/orcl

删除过期的备份时候使用：

RMAN> delete expired copy;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=145 devtype=DISKspecification does not match any archive log in the recovery catalogList of Datafile CopiesKey     File S Completion Time Ckp SCN    Ckp Time        Name------- ---- - --------------- ---------- --------------- ----21      1    X 13-JUN-14       634486     13-JUN-14       +KEL/orclDo you really want to delete the above objects (enter YES or NO)? ydeleted datafile copydatafile copy filename=+KEL/orcl recid=21 stamp=850092105Deleted 1 EXPIRED objectsRMAN> delete expired backupset;using channel ORA_DISK_1RMAN> delete expired backup;using channel ORA_DISK_1