oracle 11g删除归档日志,Oracle 11g的RMAN-06207: WARNING:不能删除归档日志

在Oracle11g的rman中，如：

RMAN> delete archivelog all;

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due

RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status

RMAN-06210: List of Mismatched objects

RMAN-06211: ==========================

RMAN-06212:   Object Type   Filename/Handle

RMAN-06213: --------------- ---------------------------------------------------

RMAN-06214: Archivelog      +ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=588 instance=cboms1 device type=DISK

validation succeeded for archived log

archived log file name=+ARCHDG/cboms/archivelog/2010_12_20/thread_1_seq_161.321.738252445 RECID=390 STAMP=738252447

validation failed for archived log

archived log file name=+ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115.276.737837641 RECID=325 STAMP=737837643

validation succeeded for archived log

archived log file name=+ARCHDG/cboms/archivelog/2010_12_20/thread_2_seq_156.323.738252443 RECID=389 STAMP=738252446

Crosschecked 3 objects

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=588 instance=cboms1 device type=DISK

List of Archived Log Copies for database with db_unique_name CBOMS

=====================================================================

Key     Thrd Seq     S Low Time

------- ---- ------- - ---------

325     2    115     X 15-DEC-10

Name: +ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115.276.737837641

Do you really want to delete the above objects (enter YES or NO)? YES

deleted archived log

archived log file name=+ARCHDG/cboms/archivelog/2010_12_15/thread_2_seq_115.276.737837641 RECID=325 STAMP=737837643

Deleted 1 EXPIRED objects