Oracle11g的RMAN-06207: WARNING:不能删除归档日志-优快云博客

本文介绍了在Oracle 11g环境下使用RMAN进行归档日志管理的操作过程，包括删除、验证及清理过期归档日志的具体步骤。通过实际案例展示了如何解决归档日志状态不匹配的问题，并提供了正确的命令执行流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在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

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

转载于:http://blog.itpub.net/12778571/viewspace-682178/