My Oracle Support Banner

RMAN: DELETE OBSOLETE Fails With ORA-19607 %s is an active controlfile (Doc ID 444269.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

DELETE OBSOLETE fails with ORA-19607: C:\<path>\CONTROLFILE\CONTROL01.CTL is an active control file

RMAN> DELETE NOPROMPT OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 2 23-MAR-07 C:\<path>\CONTROLFILE\CONTROL01.CTL
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_DISK_1 channel at 07/16/2007
11:01:08
ORA-19607: C:\<path>\CONTROLFILE\CONTROL01.CTL is an active control file

RMAN>

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.