How to fix RMAN-06059/ORA-19625?

If archive logs are missing RMAN will fail with the following error also in cases when the archive logs are moved to another folder due to archive log filesystem getting full.
RMAN-03002: failure of backup plus archivelog command at 10/31/2010 04:36:37
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oradata/TEST/arch/1_1148_694732375.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

So running crosscheck on archivelog the missing files are marked as unavailable and one can run Oracle backup

RMAN> change archivelog all crosscheck;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=21 devtype=DISK
validation failed for archived log
archive log filename=/u01/oradata/TEST/arch/1_1148_694732375.dbf recid=359 stamp=716265182
validation failed for archived log
archive log filename=/u01/oradata/TEST/arch/1_1149_694732375.dbf recid=360 stamp=716265185
validation failed for archived log

In cases when the archive log filesystem is full and files are moved and you still them to be archived so they can be backed up in the new folder or can be moved back to the original archive log folder but one need to rerun the command “change archivelog all crosscheck;” to backup the archive logs.

3 comments

  1. Thanks Amin,

    This helped me. Actually I’d taken RMAN Backup from my production DB and had restored it on another host. I think I’d missed resetting the Arcivelogs – hence while taking the backup of the new DB after around a month or so I faced the problem ora-19625 ora-27037.

    The command “change archivelog all crosscheck;” helped me sort out the problem and I could successfully could take the backup of database with archvielogs.

    Thanks again.

    Best wishes

    Pankaj S Muley

  2. This has helped me, as I was facing archive dest full error and I changed the archive destination to another diskgroup. But when I was trying to backup all the archives with delete input it did not work untill I gave ” change archivelog all crosscheck”. Thanks a lot.

    • It was helpful, I was facing error “RMAN-06059: expected archived log not found, lost of archived log compromises recoverability” but when I performed ‘change archivelog all crosscheck’ it solved the issue right away, 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 )

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.