My Oracle Support Banner

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 Workaround:
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.