My Oracle Support Banner

Oracle "Capture" and the RMAN-08137 WARNING (Doc ID 1581365.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 to 11.2.1.0.10 [Release 11.1.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.2.0.1 [Release 11.1 to 12.2]
Information in this document applies to any platform.

Purpose

To explain why RMAN reports the warning:

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

or

RMAN-08137: WARNING: archived log not deleted as it is still needed archived log file

when Oracle "Capture" technology is being used.

Oracle "Capture" technology encompasses the following Oracle products;

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Who does what?
 STANDBY or no STANDBY?
 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
 Database is in MOUNT stage
 Database is OPEN
 Updates to V$DATABASE.MIN_REQUIRED_CAPTURE_CHANGE#
 Diagnostic Queries when the log is needed for an upstream capture process
 Solutions
 RMAN-08137: WARNING: archived log not deleted as it is still needed archived log file
 Diagnostic Queries when the archived log is still needed
 Solutions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.