RMAN-06059: expected archived log not found

Posted: December 23, 2014 in Backup and Recovery, ORA Errors
Tags:

Good morning, Oracle users!

It’s always a good idea to look over your RMAN logs to make sure your daily backups are completing. Let me reiterate the fact that this is not the same thing as validating your backups. Picture your supervisor asking you the question, “Are your database backups valid in case we need to perform a restore?” Would he or she be satisfied with, “Probably”? Even if the answer is yes, know that the only way to truly validate a backup is to attempt to restore it. Okay, I will now exit my soap box and get to the point.


Here’s a simple RMAN backup script…

RMAN> backup database plus archivelog;

Starting backup at 23-DEC-14

current log archived

using channel ORA_DISK_1

RMAN-00571:=================================================================

RMAN-00569:=========ERROR MESSAGE STACK FOLLOWS=========================

RMAN-00571:=================================================================

RMAN-03002: failure of backup plus archivelog command at 02/07/2012 02:40:28

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

What would you do next?


Every once in a while, there will be an archive log out there that is expired but not deleted. If that is the case, there is an easy answer:


CROSSCHECK AND DELETE EXPIRED

RMAN> crosscheck archivelog all;

Then…

RMAN> delete expired archivelog all;

Run the backup again


Thanks for reading!

Jason

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s