Oracle相关：Rman Crosscheck删除失效归档

3.简要介绍一下report obsolete命令使用report obsolete命令报告过期备份

当手工删除了归档日志以后，Rman备份会检测到日志缺失，从而无法进一步继续执行。

所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常。

1.Crosscheck日志

$ rman target /
Recovery Manager: Release 9.2.0.4.0 – 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: AVATAR2 (DBID=2480694409)

RMAN> crosscheck archivelog all;

using target database controlfile instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=25 devtype=DISK

validation failed for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2714.dbf recid=2702 stamp=545107659

validation failed for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2715.dbf recid=2703 stamp=545108268

………..

validation failed for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2985.dbf recid=2973 stamp=545399327

validation succeeded for archi

本文来源gaodai.ma#com搞##代!^码@网3

ved log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2986.dbf recid=2974 stamp=545400820

validation succeeded for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2987.dbf recid=2975 stamp=545401757

validation succeeded for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2988.dbf recid=2976 stamp=545402716

validation succeeded for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2989.dbf recid=2977 stamp=545403661

validation succeeded for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2990.dbf recid=2978 stamp=545404946

validation succeeded for archived log

archive log filename=/opt/oracle/oradata/avatar2/archive/1_2991.dbf recid=2979 stamp=545406220

Crosschecked 278 objects

RMAN>

2.使用delete expired archivelog all 命令删除所有过期归档日志：

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=12 devtype=DISK

List of Archived Log Copies

Key Thrd Seq S Low Time Name

——- —- ——- – ——— —-

376 1 2714 X 23-NOV-04 =/opt/oracle/oradata/avatar2/archive/1_2714.dbf

…..

，

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：Oracle相关：Rman Crosscheck删除失效归档

Hi，您需要填写昵称和邮箱！