RMAN-06207 & RMAN-06208 問題處理
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>
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN-06207和RMAN-06208的處理
- RMAN 解決(RMAN-06208,RMAN-06207,ORA-19606)刪除過期檔案問題
- 處理問題的方法
- perl中文處理問題
- 漢字處理問題?
- xml處理的問題XML
- 貨品問題處理
- [git] git問題處理Git
- golang json處理問題GolangJSON
- 併發問題處理方式
- ASMCMD處理問題一則ASM
- mysql的處理能力問題MySql
- RMAN處理split block問題BloC
- mysql問題處理兩則MySql
- Oracle啟動問題處理Oracle
- mysql 問題處理二則MySql
- Oracle壞塊問題處理Oracle
- 資料處理--pandas問題
- 如何處理 No DMARC Record Found 問題
- PHP 開發版本問題處理PHP
- MySQL:亂碼問題處理流程MySql
- JVM問題分析處理手冊JVM
- Linux 問題處理集錦Linux
- 處理SQLServer errorlog滿問題SQLServerError
- 如何處理HTTP 503故障問題?HTTP
- gc buffer busy acquire問題處理GCUI
- 記憶體分配問題處理記憶體
- RDSforMySQLMysqldump常見問題和處理ORMMySql
- ORA-00942問題處理
- crontab 問題檢查與處理
- ORA-38760 問題處理方法
- 一個NBU問題的處理
- Lotus notes問題與處理
- HTML + CSS處理常見問題HTMLCSS
- Java 大資料量處理問題Java大資料
- mysql的處理能力問題(2)MySql
- crontab對oracle操作問題處理Oracle
- 【問題處理】“NOT IN”與“NULL”的邂逅Null