RMAN-06207: WARNING: 16 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> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/backupII/ORCL/e2otuvjc_1_1 RECID=1644 STAMP=836730494
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/backupII/ORCL/e2otuvjc_2_1 RECID=1645 STAMP=836732841
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/backupII/ORCL/e2otuvjc_3_1 RECID=1646 STAMP=836735666
Běžný delete obsolete nefunguje.
RMAN> delete obsolete ;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 14 days
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
——————– —— —————— ——————–
Datafile Copy 1 19-AUG-13 /backup/ORCL/20130819-data-level1-ORCL-19298-823870475
Datafile Copy 2 19-AUG-13 /backup/ORCL/20130819-data-level1-ORCL-19299-823870827
Datafile Copy 3 19-AUG-13 /backup/ORCL/20130819-data-level1-ORCL-19300-823871032
Datafile Copy 4 19-AUG-13 /backup/ORCL/20130819-data-level1-ORCL-19301-823871247
Do you really want to delete the above objects (enter YES or NO)? YES
RMAN-06207: WARNING: 16 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/ORCL/20130819-data-level1-ORCL-19298-823870475
RMAN-06214: Datafile Copy /backup/ORCL/20130819-data-level1-ORCL-19299-823870827
RMAN-06214: Datafile Copy /backup/ORCL/20130819-data-level1-ORCL-19300-823871032
RMAN-06214: Datafile Copy /backup/ORCL/20130819-data-level1-ORCL-19301-823871247
Řešení
Musí se použít crosscheck copy
RMAN> crosscheck copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1007 device type=DISK
specification does not match any control file copy in the repository
validation failed for datafile copy
datafile copy file name=/backup/ORCL/20130821-data-level1-ORCL-19313-824068004 RECID=13 STAMP=824068017
validation failed for datafile copy
datafile copy file name=/backup/ORCL/20130821-data-level1-ORCL-19314-824068019 RECID=14 STAMP=824068027
validation failed for datafile copy
RMAN> delete expired copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1007 device type=DISK
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
——- —- – ————— ———- —————
13 1 X 21-AUG-13 728158880 21-AUG-13
Name: /backup/ORCL/20130821-data-level1-ORCL-19313-824068004
Tag: INCR_BACKUP
14 2 X 21-AUG-13 728158901 21-AUG-13
Name: /backup/ORCL/20130821-data-level1-ORCL-19314-824068019
Tag: INCR_BACKUP
1 3 X 19-AUG-13 725676320 19-AUG-13
Name: /backup/ORCL/20130819-data-level1-ORCL-19298-823870475
Tag: INCR_BACKUP
9 4 X 21-AUG-13 728158521 21-AUG-13
Name: /backup/ORCL/20130821-data-level1-ORCL-19309-824067803
Tag: INCR_BACKUP
datafile copy file name=/backup/ORCL/20130819-data-level1-ORCL-19303-823871657 RECID=6 STAMP=823871822
deleted datafile copy
datafile copy file name=/backup/ORCL/20130821-data-level1-ORCL-19315-824068034 RECID=15 STAMP=824068035
deleted datafile copy
datafile copy file name=/backupII/ORCL/data_D-ORCL_I-2416634607_TS-STATSPACK_FNO-16_agor36f6 RECID=16 STAMP=833722871
Deleted 16 EXPIRED objects