Site icon An Oracle Spin by Alex Lima

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.

Exit mobile version