Problem with delete obsolete controlfile copy
677029Jun 22 2012 — edited Jun 25 2012Hello Gurus,
Please help me with this issue.
RMAN backup failure on one database running 11.2.0.3 on win 2008R2 x64.
H:\>rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 22 12:11:17 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ECDB (DBID=3504538967)
RMAN> report obsolete;
using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 74 11-APR-12 E:\ECDB\BACKUPSET\SNCDECDB.ORA
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=385 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 74 11-APR-12 E:\ECDB\BACKUPSET\SNCDECDB.ORA
deleted control file copy
control file copy file name=E:\ECDB\BACKUPSET\SNCDECDB.ORA RECID=74 STAMP=780321276
Deleted 1 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 74 11-APR-12 E:\ECDB\BACKUPSET\SNCDECDB.ORA
RMAN> DELETE FORCE CONTROLFILECOPY 'E:\ECDB\BACKUPSET\SNCDECDB.ORA';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=385 device type=DISK
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
74 X 11-APR-12 61418837 11-APR-12
Name: E:\ECDB\BACKUPSET\SNCDECDB.ORA
Tag: TAG20120411T115434
Do you really want to delete the above objects (enter YES or NO)? YES
deleted control file copy
control file copy file name=E:\ECDB\BACKUPSET\SNCDECDB.ORA RECID=74 STAMP=780321276
Deleted 1 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 74 11-APR-12 E:\ECDB\BACKUPSET\SNCDECDB.ORA
RMAN>
My question is why is the obsolete file not getting deleted with completion time 11-apr-12.