RMAN Consider snapcf_SID.f as obsolete

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy   /u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f


Cause:
The snapshot controlfile is cataloged as a controlfile coy and is now obsolete. RMAN cannot delete this file as it is used by rman.

RMAN> show all;
RMAN configuration parameters for database with db_unique_name TRCPRD are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backups/db/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO /u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f; # default


Solution:
•    Set new name (or location) for RMAN to use for snapshot controlfile:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/snapcf_ORACLE11G.f';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/snapcf_ORACLE11G.f';
new RMAN configuration parameters are successfully stored

•    Crosscheck and delete the file from RMAN:
RMAN> crosscheck controlfilecopy "/u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f";

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1353 device type=DISK
validation failed for control file copy
control file copy file name=/u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f RECID=1 STAMP=828773553
Crosschecked 1 objects

RMAN> delete expired "controlfilecopy /u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f"

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1353 device type=DISK
List of Control File Copies
===========================

Key     S Completion Time Ckp SCN    Ckp Time
------- - --------------- ---------- ---------------
1       X 14-OCT-13       32121181196 14-OCT-13
        Name: /u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f
        Tag: TAG20131014T065231


Do you really want to delete the above objects (enter YES or NO)? YES
deleted control file copy
control file copy file name=/u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f

RECID=1 STAMP=828773553
Deleted 1 EXPIRED objects

•    Now try deleting the obsolete backups

RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found

•    Set the snapshot controlfile name (or location) to original:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO "/u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f";

old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/snapcf_ORACLE11G.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/apps/oracle/product/11.2.0/db_1/dbs/snapcf_ORACLE11G.f';