RMAN-06059: expected archived log not found

RMAN-06059: expected archived log not found

While running the backup through RMAN prompt it will generate the following error.

RMAN-06059: expected archive log not found.

Solution:
1. You need to check the location of archive log that archive is present or someone remove or move it to another location.

2. If someone move to other location then move it back to archive location and run the backup again.

3. If archive is not available, then to get ride of this error, you need to run Crosscheck your archive logs from RMAN prompt for mark them as expired in rman catalog.
RMAN> crosscheck archivelog all;
Crosscheck command marked archived log as expired which is not find in physical location.

4. For delete the expired archivelog run the following command:
RMAN> DELETE EXPIRED ARCHIVELOG ALL;

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 )

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.