oracle rman删除备份报错

RMAN-06207: WARNING: 9 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    /oradata/bak/forstandby_rl26c7ob
RMAN-06214: Backup Piece    /oradata/bak/forstandby_rm26c7oc
RMAN-06214: Backup Piece    /oradata/bak/forstandby_rn26c7od
RMAN-06214: Backup Piece    /oradata/bak/forstandby_ro26c7of
RMAN-06214: Backup Piece    /oradata/bak/forstandby_rp26c9mk
RMAN-06214: Backup Piece    /oradata/bak/incremental_forstandby_ORACLE_t526jiqn_1_1.bkp
RMAN-06214: Backup Piece    /oradata/bak/incremental_forstandby_ORACLE_t626jiqo_1_1.bkp
RMAN-06214: Backup Piece    /oradata/bak/incremental_forstandby_ORACLE_t826jiqp_1_1.bkp.2
RMAN-06214: Backup Piece    /oradata/bak/incremental_forstandby_ORACLE_t926jq77_1_1.bkp.2

原因是因为原来的文件已经被删除了，需要手动crosscheck在rman中执行crosscheck backuppiece

crosscheck backuppiece '/oradata/bak/forstandby_rm26c7oc';
crosscheck backuppiece '/oradata/bak/forstandby_rn26c7od';
crosscheck backuppiece '/oradata/bak/forstandby_ro26c7of';
crosscheck backuppiece '/oradata/bak/forstandby_rp26c9mk';
crosscheck backuppiece '/oradata/bak/incremental_forstandby_ORACLE_t526jiqn_1_1.bkp';
crosscheck backuppiece '/oradata/bak/incremental_forstandby_ORACLE_t626jiqo_1_1.bkp';
crosscheck backuppiece '/oradata/bak/incremental_forstandby_ORACLE_t826jiqp_1_1.bkp.2';
crosscheck backuppiece '/oradata/bak/incremental_forstandby_ORACLE_t926jq77_1_1.bkp.2';

然后再删除失效的备份即可

delete expired backup;