--RMAN-06061处理--例行进行数据库备份检查的时候发现一个库的备份状态是completed with errors--所以进到操作系统进行查看，发现
--RMAN-06061处理
--例行进行数据库备份检查的时候发现一个库的备份状态是completed with errors
--所以进到操作系统进行查看，发现全备日志中出现了如下的告警
archived log /opt/Oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc not found or out of sync with catalog
skipping inaccessible file /opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc
RMAN-06061: WARNING: skipping archivelog compromises recoverability
--search了一下发现该错误一般是由于手动删除了归档导致备份时无法找到对应的归档文件导致的，
--正好想到这周一备份出错时正是由于归档目录满了所导致，可能相关人员删除了部分归档文件。
--使用rman进行crosscheck
$ rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Thu May 7 10:30:56 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: CISDB (DBID=3992919346)
RMAN> crosscheck archivelog all;
使用目标数据库控制文件而不是恢复目录
分配的通道：ORA_DISK_1
通道 ORA_DISK_1: sid=6542 instance=cisdb2 devtype=DISK
归档日志验证失败
归档日志文件名=/ opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc recid=402622 stamp=878555473
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc雷西德= 402623邮票= 878555879
>存档日志>存档日志文件名=/opt/opt/oracle/cisdb/actdb1/bak/cisdb2_127705_67705_673050541.arc recid recid = 402624邮票= 87855555555556416 归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/ cisdb2_127707_673050541.arc recid=402626 stamp=878556637
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc reci=402627 stamp=878 556651
验证失败归档日志
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc recid=402628 stamp=878556662
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb /archdb1/bak/cisdb2_127710_673050541.arc recid=402629 stamp=878556674
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc reci=4026 30邮票=878556686
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc recid=402631 stamp=878556693
归档日志验证失败
归档日志文件名=/ opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc recid=402632 stamp=878556701
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc雷西德= 402633邮票= 878556934
存档日志>档案日志文件名=/opt/opt/opt/oracle/cisdb/acrace/aCTDB1/bak/cisdb2_127715_67715_673050541.arc secid = 402634邮票= 87855555555555519 >归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc recid=402635 stamp=878560954
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/ cisdb2_127717_673050541.arc reci=402636 stamp=878562006
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc reci=402637 stamp=878 562008
验证失败归档日志
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc recid=402638 stamp=878562838
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb /archdb1/bak/cisdb2_127720_673050541.arc recid=402639 stamp=878563486
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc reci=4026 40邮票=878563786
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc recid=402641 stamp=878563801
归档日志验证失败
归档日志文件名=/ opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc recid=402642 stamp=878563814
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc雷西德= 402643邮票= 878563818
存档日志>档案日志文件名=/opt/opt/opt/oracle/cisdb/actdb1/bak/cisdb2_127725_67725_673050541.arc recid recid = 402644邮票= 87856382782727272727856382727>>归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc recid=402645 stamp=878563844
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/ cisdb2_127727_673050541.arc recid=402646 stamp=878563861
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc reci=402647 stamp=878 563901
验证失败归档日志
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc recid=402648 stamp=878563949
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb /archdb1/bak/cisdb2_127730_673050541.arc recid=402649 stamp=878563992
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc reci=4026 50邮票=878564546
归档日志验证失败
归档日志文件名=/opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc recid=402651 stamp=878565920
归档日志验证成功
归档日志文件名=/ opt/oracle/cisdb/archdb1/bak/cisdb2_128071_673050541.arc recid=402990 stamp=879066010
归档日志验证成功
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_128072_673050541.arc recid=402991 stamp=879066011
Crosschecked 32 objects
--列出所有失效的归档
RMAN> list expired archivelog all;
