RMAN-06061 WARNING skipping archivelog compromises

最後更新：2015-05-09 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

--RMAN-06061處理
--例行進行Database Backup檢查的時候發現一個庫的備份狀態是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

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

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了，對應的問題應該已經解決

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More