Posts

Showing posts from June 25, 2017

RMAN-06059: expected archived log not found

Issue: RMAN-03002: failure of backup command at 06/22/2017 20:01:47 RMAN-06059: expected archived log not found, loss of archived log compromises recoverability ORA-19625: error identifying file +SID_ARCH/sid/archivelog/2017_06_17/thread_2_seq_316.11811.946933225 ORA-17503: ksfdopn:2 Failed to open file +SID_ARCH/sid/archivelog/2017_06_17/thread_2_seq_316.11811.946933225 ORA-15012: ASM file '+SID_ARCH/sid/archivelog/2017_06_17/thread_2_seq_316.11811.946933225' does not exist Cause: Here d uring backup of archive logs via RMAN, RMAN try to backup the archive log with sequence 316 thread 2, but actually RMAN can not backup it as this log file does not exist physically there. So whenever RMAN tries to back it up, it fails hence backup of archive log via RMAN stucks. Solution: Go to RMAN: rman target / crosscheck archivelog all; This will mark physically not present file as expired in control file . Now try to backup the archive log, it wil