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;
Bir Cevap Yazın