RMAN-06207 & RMAN-06208 問題處理

ningzi82發表於2011-10-21

RMAN-06207: WARNING: 11 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 /u01/backup/ORCL_20110907_data_D-ORCL_I-1288914708_TS-SYSAUX_FNO-3_0dmlv7ia.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110907_data_D-ORCL_I-1288914708_TS-SYSTEM_FNO-1_0emlv7ip.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110907_data_D-ORCL_I-1288914708_TS-UNDOTBS1_FNO-2_0fmlv7j0.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110907_data_D-ORCL_I-1288914708_TS-UNDOTBS2_FNO-4_0gmlv7j7.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110907_data_D-ORCL_I-1288914708_TS-USERS_FNO-5_0hmlv7ja.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110908_data_D-ORCL_I-1288914708_TS-SYSAUX_FNO-3_0jmm1c89.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110908_data_D-ORCL_I-1288914708_TS-SYSTEM_FNO-1_0kmm1c8g.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110908_data_D-ORCL_I-1288914708_TS-UNDOTBS1_FNO-2_0lmm1c8v.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110908_data_D-ORCL_I-1288914708_TS-USERS_FNO-5_0mmm1c96.bak
RMAN-06214: Datafile Copy /u01/backup/ORCL_20110908_data_D-ORCL_I-1288914708_TS-UNDOTBS2_FNO-4_0nmm1c99.bak
RMAN-06214: Datafile Copy /u01/backup/control01.ctl


RMAN>
RMAN>

[@more@]

SOLUTION:
--------------------------------------------------------------------
RMAN> crosscheck datafilecopy '/u01/backup/ORCL_20110908_data_D-ORCL_I-1288914708_TS-SYSTEM_FNO-1_0kmm1c8g.bak';

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1018 instance=orcl2 devtype=DISK
validation failed for datafile copy
datafile copy filename=/u01/backup/ORCL_20110908_data_D-ORCL_I-1288914708_TS-SYSTEM_FNO-1_0kmm1c8g.bak recid=8 stamp=761311512
Crosschecked 1 objects


RMAN> crosscheck controlfilecopy '/u01/backup/control01.ctl';

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1018 instance=orcl2 devtype=DISK
validation failed for control file copy
control file copy filename=/u01/backup/control01.ctl recid=12 stamp=761311669
Crosschecked 1 objects


RMAN> delete obsolete;


OR
------------------------
crosscheck backuppiece ' ';
crosscheck backupset ' ';
delete obsolete; or delete backupset ;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/789833/viewspace-1055839/,如需轉載,請註明出處,否則將追究法律責任。

相關文章