Friday, July 22, 2016

RMAN-06214: When trying to delete Datafile Copy or Control File Copy

Sometimes even though your rman backups are running in a good state you happen to find the below errors in backup log file.


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   /backup/<dbname>/<piece_name>


RMAN-06207: WARNING: 22 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 /backup/<dbname>/<control_file_name>


Solution:

RMAN> crosscheck copy;
RMAN> delete expired copy;