当前位置:  数据库>oracle

RMAN-06061 WARNING skipping archivelog compromises

    来源: 互联网  发布时间:2017-06-16

    本文导语: --RMAN-06061处理--例行进行数据库备份检查的时候发现一个库的备份状态是completed with errors--所以进到操作系统进行查看,发现全备日志中出现了如下的告警archived log /opt/Oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc not found or out of sync wi...

--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了,对应的问题应该已经解决


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • rman备份脚本和rman增量备份脚本分享
  • Oracle数据库备份和恢复工具 RMan
  • catalog方式的rman备份与恢复示例
  • rman配置及rman常用命令操作
  • win平台oracle rman备份和删除dg备库归档日志脚本
  • linux自动运行rman增量备份脚本
  • 9i下RMAN的备份及恢复步骤
  • Oracle相关:Rman Crosscheck删除失效归档
  • ORACLE 数据库RMAN备份恢复
  • rman恢复方案和oracle异机恢复
  • Oracle RMAN快速入门指南


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3