RMAN-06059: expected archived log not found, lost of archived log compromis
Hi All,
Below is the error which I am getting in my RMAN log files however when I restored the files from the RMAN for sequence number 2011, it got restored successfully and then even the full backup went through. The problem what I am unable to understand is why am I getting this error when RMAN has this file. Archive log and full backup has been configured through CRONTAB and configuration of the crontab is also mentioned below for your information:
Error in the log
********************************************************************************************
RMAN-03002: failure of backup command at 06/12/2009 22:40:04
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u02/oracle/oradata/DEVOLTP/arch1_2011.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
********************************************************************************************
CRONTAB listing
****************************************************
40 22 * * 2,5 /mnt/backup/log/backupFull.sh
40 22 * * 0,1,3,4,6 /mnt/backup/log/backupArchiveLogs.sh
40 23 * * 0 /mnt/backup/log/deleteObsolete.sh
****************************************************
As you can seen Fullbackup has been configured twice in a week and archivelog backup has been configured for everyday except two days of the week. The backup script contains "BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;" which means take the backup and then delete the inputs but I am getting above error in the log file.
Any thoughts?
Thanks,
Onkar