RMAN-08137 After Logs Created During Switchover and Deletion Policy is set to NONE (Doc ID 2084866.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Archive log deletion on primary site failing with the below error.

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

Primary database has two dataguard databases, a physical standby and a snapshot standby.  

The physical standby database is in sync and snapshot database is receiving the archive logs.

Patch for <<Bug:17156876>> was applied but did not resolved issue as this bug is for archivelog files generated when converting a snapshot standby.

Changes

Issue comes when standby 2 is converted to snapshot and Switchover is performed between primary and physical standby 1 database.

Issue is resolved once snapshot DB is converted to physical standby, archive starts getting deleted.

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