RMAN BACKUP on Standby intermittently fails with RMAN-06059, ORA-19625, ORA-27037 for the archived log already backed up and deleted
(Doc ID 1355079.1)
Last updated on MARCH 06, 2019
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2] Information in this document applies to any platform.
RMAN Backup of archived logs sometimes fail with below error for any archived log which is already backed up and deleted :
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 06/03/2011 16:32:53 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability ORA-19625: error identifying file /<path>/archivelog/2011_06_01/o1_mf_1_6_6tmewvh_.arc ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: A file or directory in the path name does not exist. Additional information: 3
It is found that extra duplicate entries exist for the failing archived log in V$ARCHIVED_LOG view.
MRP may report corrupted archived log on standby.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!