:

RMAN-06059: expected archived log not found

The Problem

One of our regularly scheduled jobs on PROD which backs up the archivelogs each day failed with the error message below:

RMAN-03002: failure of backup command
RMAN-06059: expected archived log not found, loss of  archived log compromises recoverability
ORA-19625: error identifying file  M:\ORACLE\LOGS\LOG_246800_1.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file

The Cause

This happened because I had previously restored these two archivelogs to disk on PROD from a backup, because we needed to use them for our Data Guard environment; the files had not yet been applied to Data Guard because there was a delay and they had been deleted.

The Solution

First of all, physically delete any files that you no longer require. Then, from RMAN on your production server, log in and issue the following:

RMAN> CROSSCHECK ARCHIVELOG ALL;

This will ensure that RMAN has marked the logs which are not physically there as EXPIRED in the control file or recovery catalog, depending on which one you are using, so that they can easily be deleted from the catalog and/or control file of the database. The command below will prompt you before it removes the files, and will show you which files it will attempt to delete.

RMAN> DELETE EXPIRED ARCHIVELOG ALL;

Next, all you have to do is re-run the backup command and it should work, hopefully…

Just quick before you go…

Must Read Oracle DBA BooksHopefully that helped you out and resolved your Oracle error. While you’re here, what steps are you taking to improve your Oracle knowledge?

Check out my latest post about which Oracle books are a must read for any serious Oracle DBA. Learn from the best…

Like it, share it...

Category: RMAN


Related Posts

Comments (2)

Trackback URL | Comments RSS Feed

  1. inayath khan says:

    Its worked…

    Thank you…

Leave a Reply

Your email address will not be published. Required fields are marked *