My Oracle Support Banner

No capture processes, no standby database, RMAN failing to delete archives ,not updating MIN_REQUIRED_CAPTURE_CHANGE# (Doc ID 3072938.1)

Last updated on FEBRUARY 26, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 19.24.0.0.0 [Release 11.2 to 19]
Information in this document applies to any platform.

Symptoms

 
The MIN_REQUIRED_CAPTURE_CHANGE column is not being updated, resulting in RMAN failing to delete archives after a given change.
The following query returns the same value for MIN_REQUIRED_CAPTURE_CHANGE:

SELECT MIN_REQUIRED_CAPTURE_CHANGE#
FROM gV$DATABASE;

No capture processes are scheduled, as indicated by the count of zero in the dba_capture table:

SQL> select count(*) from dba_capture;
COUNT(*)
0

 

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


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