One of my production databases was scripted to write backups to /backup01. For reasons not germane to this post, this mount point became full and I had to move the backups to /backup02. I copied the old backups and modified the script to write to /backup02 starting with the next run. However, the next execution gave me the below error.
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: Backup Piece /backup01/GPn4sbh1bm_1_1.bus
This was a direct result of my moving the backups from one location to another external to RMAN. To resolve this error, I issued a cross check
RMAN> crosscheck backuppiece '/backup01/GPn4sbh1bm_1_1.bus'; using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1011 instance=instance name device type=DISK crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/backup01/GPn4sbh1bm_1_1.bus RECID=125099 STAMP=951616886 Crosschecked 1 objects
followed by a delete obsolete
RMAN> delete 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 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 125099 10-AUG-17 Backup Piece 125099 10-AUG-17 /backup01/GPn4sbh1bm_1_1.bus Do you really want to delete the above objects (enter YES or NO)? y deleted backup piece backup piece handle=/backup01/GPn4sbh1bm_1_1.bus RECID=125099 STAMP=951616886 Deleted 1 objects
This resolved the issue.
