One of our Prod 11.2.0.4 database backup ended by  below errors:

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 +DATA/DB_NAME/DATAFILE/XXX_TS.319.962390011

The RMAN-06207 warning can be fixed by running crosscheck against the backup set.     The Delete obsolete command could not delete some files due to mismatched status.

So how We can solve this warning? Here are the steps:

Step 1: Start with getting details on obsolete backup sets using RMAN reporting commands:

rman> report obsolete

Step 2: Try crosscheck command such as

RMAN> crosscheck backup;

or

RMAN> crosscheck backuppiece '+DATA/DB_NAME/DATAFILE/XXX_TS.319.962390011';

Step 3: After crosscheck, run the delete obsolete again

rman> report obsolete;
rman > delete obsolete;

 

 

 

Advertisements