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 SEPTEMBER 25, 2014

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.

Symptoms

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 /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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms