RMAN-06061 WARNING skipping archivelog compromises

Last Update:2015-05-09 Source: Internet

Author: User

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

-- RMAN-06061 Processing
-- During routine database backup check, the backup status of a database is completed with errors.
-- So I went to the operating system to check and found the following alarms in the full backup log:
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 found that this error is generally caused by the failure to find the corresponding archive file during the backup because the archive is manually deleted,
-- The error occurred during the backup on Monday because the archive directory is full. Some archive files may have been deleted.
-- Use rman for 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_0000703_673050541.arc recid = 402622 stamp = 878555473
Validation failed for archived log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000704_673050541.arc recid = 402623 stamp = 878555879
Validation failed for archived log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000705_673050541.arc recid = 402624 stamp = 878556416
Validation failed for archived log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000706_673050541.arc recid = 402625 stamp = 878556623
Validation failed for archived log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_rj707_673050541.arc recid = 402626 stamp = 878556637
Validation failed for archived log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_1_708_673050541.arc recid = 402627 stamp = 878556651
Validation failed for archived log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000709_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

-- List all invalid Archives
RMAN> list expired archivelog all;

List of Archived Log Copies
Key Thrd Seq S Low Time Name
--------------------------------
402622 2 127703X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_0000703_673050541.arc
402623 2 127704X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_1_704_673050541.arc
402624 2 127705X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_0000705_673050541.arc
402625 2 127706X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_0000706_673050541.arc
402626 2 127707X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_2017707_673050541.arc
402627 2 127708X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_1_708_673050541.arc
402628 2 127709X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_0000709_673050541.arc
402629 2 127710X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc
402630 2 127711X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc
402631 2 127712X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc
402632 2 127713X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc
402633 2 127714X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc
402634 2 127715X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc
402635 2 127716X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc
402636 2 127717X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc
402637 2 127718X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc
402638 2 127719X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc
402639 2 127720X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc
402640 2 127721X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc
402641 2 127722X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc
402642 2 127723X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc
402643 2 127724X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc
402644 2 127725X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc
402645 2 127726X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc
402646 2 127727X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc
402647 2 127728X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc
402648 2 127729X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc
402649 2 127730X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc
402650 2 127731X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc
402651 2 127732X01-MAY-15/opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc

-- Delete the corresponding archive file (instead of deleting the archive, because the archive is no longer there, but the corresponding record is deleted from the control file)
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_0000703_673050541.arc recid = 402622 stamp = 878555473
Deleted archive log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000704_673050541.arc recid = 402623 stamp = 878555879
Deleted archive log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000705_673050541.arc recid = 402624 stamp = 878556416
Deleted archive log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000706_673050541.arc recid = 402625 stamp = 878556623
Deleted archive log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_rj707_673050541.arc recid = 402626 stamp = 878556637
Deleted archive log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_1_708_673050541.arc recid = 402627 stamp = 878556651
Deleted archive log
Archive log filename =/opt/oracle/cisdb/archdb1/bak/cisdb2_0000709_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.
$

-- Check the latest archive backup. The status is completed. The corresponding problem should have been solved.

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

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

RMAN-06061 WARNING skipping archivelog compromises

Contact Us

What's Trending

Top 10 Tags

Top 10 Keywords

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support

RMAN-06061 WARNING skipping archivelog compromises

Contact Us

What's Trending

Top 10 Tags

Top 10 Keywords

Trending Topic

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support