I have a duplicate controlfile name and cannot delete it. Bringing me in a loop.
RMAN backup is failing with:
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 /u99/backup/rman/PROD/snapcf_PROD.f
I ran acrosscheck and trying to delete obsolete fails with:
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 15 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 3 17-SEP-18 /u99/backup/rman/PROD/snapcf_PROD.f
Returns original error after entering 'YES' to delete the Control File:
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 15 days
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 3 17-SEP-18 /u99/backup/rman/PROD/snapcf_PROD.f
Do you really want to delete the above objects (enter YES or NO)? YES
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: Control File Copy /u99/backup/rman/PROD/snapcf_PROD.f
However, the control file is being used. Seems to be a duplicate.
$ ls -l /u99/backup/rman/PROD/sn