RMAN BACKUP on Standby intermittently fails with RMAN-06059, ORA-19625, ORA-27037 for the archived log already backed up and deleted
Last updated on JANUARY 02, 2018
Applies to: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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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 /fra/PROD/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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms