Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN-06059: expected archived log not found, lost of archived log compromis

onkar.nathJun 15 2009 — edited Jun 15 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2009
Added on Jun 15 2009
1 comment
838 views