RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

Starting backup at 04-JUN-12
current log archived
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/04/2012 10:36:16
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oradata/airman/archive/1_8592_628791162.arc
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Cause: This can happen for a variety of reasons; the file has been manually moved or deleted,
the archive log destination has recently been changed,
the file has been compressed, etc

Soluution:

Your options are either to restore the missing file(s), or to perform a crosscheck.
To perform a crosscheck, run the following command from within RMAN:

change archivelog all crosscheck;

Perform a full backup of the database

Note:
When an archive log crosscheck is performed, RMAN checks each archive log in turn to make sure
that it exists on disk (or tape). Those that are missing are marked as unavailable.
If you have got missing logs, this won’t bring them back. It will allow you to get past this error
and back-up the database though.

Advertisements

About shanojkumar

• Oracle Certified Professional with over 15 years of IT experience in database administration and support. • Certifications: OCP (12c, 11g & 10g), Oracle Database 11g Performance Tuning Certified Expert (OCE), ITIL V3 Certified and LPIC-1(Linux). • Oracle Certified Expert in oracle database performance tuning has solved over 100 database performance problems. • Quality oriented IT professional with notable success in Banking, Airlines, Retails, FMGC, Telecommunication and Media projects. • Maintaining an online technical blog - contributed more than 54+ articles based on ‘Database Administration’ real life scenarios on: https://shanojkumar.wordpress.com/ – 258,429 visitors all over the world. • Instructor of one of the most appreciated courses (Oracle Dataguard 12c) on Udemy with an average rating of 5 star. • Supervised a team of database administrators and technical infrastructure team members. Created documentation on best practices for database performance tuning and Oracle application installation practices.
This entry was posted in Oracle and tagged . Bookmark the permalink.

One Response to RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

  1. Saqib Ahmed says:

    my problem resolved thank you…….

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s