linux日志中显示skipping,RMAN-06061 WARNING skipping archivelog compromises

--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;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=6542 instance=cisdb2 devtype=DISK

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc recid=402622 stamp=878555473

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc recid=402623 stamp=878555879

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc recid=402624 stamp=878556416

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc recid=402625 stamp=878556623

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc recid=402626 stamp=878556637

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc recid=402627 stamp=878556651

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc recid=402628 stamp=878556662

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc recid=402629 stamp=878556674

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc recid=402630 stamp=878556686

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc recid=402631 stamp=878556693

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc recid=402632 stamp=878556701

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc recid=402633 stamp=878556934

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc recid=402634 stamp=878558519

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc recid=402635 stamp=878560954

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc recid=402636 stamp=878562006

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc recid=402637 stamp=878562008

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc recid=402638 stamp=878562838

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc recid=402639 stamp=878563486

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc recid=402640 stamp=878563786

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc recid=402641 stamp=878563801

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc recid=402642 stamp=878563814

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc recid=402643 stamp=878563818

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc recid=402644 stamp=878563827

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc recid=402645 stamp=878563844

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc recid=402646 stamp=878563861

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc recid=402647 stamp=878563901

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc recid=402648 stamp=878563949

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc recid=402649 stamp=878563992

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc recid=402650 stamp=878564546

validation failed for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc recid=402651 stamp=878565920

validation succeeded for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_128071_673050541.arc recid=402990 stamp=879066010

validation succeeded for archived log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_128072_673050541.arc recid=402991 stamp=879066011

Crosschecked 32 objects

--列出所有失效的归档

RMAN> list expired archivelog all;

List of Archived Log Copies

Key    Thrd Seq    S Low Time  Name

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

402622  2    127703  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc

402623  2    127704  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc

402624  2    127705  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc

402625  2    127706  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc

402626  2    127707  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc

402627  2    127708  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc

402628  2    127709  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc

402629  2    127710  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc

402630  2    127711  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc

402631  2    127712  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc

402632  2    127713  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc

402633  2    127714  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc

402634  2    127715  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc

402635  2    127716  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc

402636  2    127717  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc

402637  2    127718  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc

402638  2    127719  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc

402639  2    127720  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc

402640  2    127721  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc

402641  2    127722  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc

402642  2    127723  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc

402643  2    127724  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc

402644  2    127725  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc

402645  2    127726  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc

402646  2    127727  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc

402647  2    127728  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc

402648  2    127729  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc

402649  2    127730  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc

402650  2    127731  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc

402651  2    127732  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc

--删除对应的归档文件(不是真正删除归档,因为归档本来就不在了,只是从控制文件中删除对应的记录)

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=6542 instance=cisdb2 devtype=DISK

List of Archived Log Copies

Key    Thrd Seq    S Low Time  Name

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

402622  2    127703  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc

402623  2    127704  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc

402624  2    127705  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc

402625  2    127706  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc

402626  2    127707  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc

402627  2    127708  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc

402628  2    127709  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc

402629  2    127710  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc

402630  2    127711  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc

402631  2    127712  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc

402632  2    127713  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc

402633  2    127714  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc

402634  2    127715  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc

402635  2    127716  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc

402636  2    127717  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc

402637  2    127718  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc

402638  2    127719  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc

402639  2    127720  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc

402640  2    127721  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc

402641  2    127722  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc

402642  2    127723  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc

402643  2    127724  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc

402644  2    127725  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc

402645  2    127726  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc

402646  2    127727  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc

402647  2    127728  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc

402648  2    127729  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc

402649  2    127730  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc

402650  2    127731  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc

402651  2    127732  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc

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

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc recid=402622 stamp=878555473

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc recid=402623 stamp=878555879

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc recid=402624 stamp=878556416

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc recid=402625 stamp=878556623

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc recid=402626 stamp=878556637

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc recid=402627 stamp=878556651

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc recid=402628 stamp=878556662

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc recid=402629 stamp=878556674

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc recid=402630 stamp=878556686

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc recid=402631 stamp=878556693

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc recid=402632 stamp=878556701

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc recid=402633 stamp=878556934

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc recid=402634 stamp=878558519

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc recid=402635 stamp=878560954

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc recid=402636 stamp=878562006

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc recid=402637 stamp=878562008

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc recid=402638 stamp=878562838

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc recid=402639 stamp=878563486

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc recid=402640 stamp=878563786

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc recid=402641 stamp=878563801

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc recid=402642 stamp=878563814

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc recid=402643 stamp=878563818

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc recid=402644 stamp=878563827

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc recid=402645 stamp=878563844

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc recid=402646 stamp=878563861

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc recid=402647 stamp=878563901

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc recid=402648 stamp=878563949

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc recid=402649 stamp=878563992

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc recid=402650 stamp=878564546

deleted archive log

archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc recid=402651 stamp=878565920

Deleted 30 EXPIRED objects

RMAN> exit

Recovery Manager complete.

$

--做完之后看了一下最新的归档备份,状态是completed了,对应的问题应该已经解决

0b1331709591d260c1c78e86d0c51c18.png

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值