RMAN-06207和RMAN-06208的處理
最近新上一套磁帶機,重新規劃了備份,執行一段時間後,最近兩天檢視RMAN備份,發現在維護備份集時有如下錯誤:
[@more@]Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 507 2011-03-29 17:16:12
Backup Piece 35 2011-03-29 17:16:12 ham8euqg_1_1
Backup Set 511 2011-03-29 17:19:05
Backup Piece 39 2011-03-29 17:19:05 hem8ev1t_1_1
Backup Set 513 2011-03-29 17:21:14
Backup Piece 41 2011-03-29 17:21:14 him8ev5v_1_1
Backup Set 519 2011-03-29 17:24:55
Backup Piece 47 2011-03-29 17:24:55 hmm8ev63_1_1
Backup Set 522 2011-03-29 17:35:41
Backup Piece 50 2011-03-29 17:35:41 hrm8evv5_1_1
Backup Set 525 2011-03-29 19:04:16
Backup Piece 53 2011-03-29 19:04:16 hum8f45m_1_1
......
RMAN-06207: WARNING: 54 objects could not be deleted for SBT_TAPE 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 ham8euqg_1_1
......
看了一下日期,這些備份都是測試的時候產生的,後來已經用NBU直接清理掉了,但是看來RMAN沒有crosscheck這些備份片,沒有認出來這些備份片已經失效了。
解決方案是手工對這些備份片做一次crosscheck。
RMAN> allocate channel for maintenance device type sbt;
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=1426 instance=dwrac1 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
--原狀態
RMAN> list backuppiece 'ham8euqg_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
102 574 1 1 AVAILABLE SBT_TAPE ham8euqg_1_1
RMAN> crosscheck backuppiece 'ham8euqg_1_1';
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=ham8euqg_1_1 recid=102 stamp=747165779
Crosschecked 1 objects
--crosscheck後狀態改變
RMAN> list backuppiece 'ham8euqg_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
102 574 1 1 EXPIRED SBT_TAPE ham8euqg_1_1
--刪除備份片
RMAN> delete expired backup;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
102 574 1 1 EXPIRED SBT_TAPE ham8euqg_1_1
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=ham8euqg_1_1 recid=102 stamp=747165779
Deleted 1 EXPIRED objects
[@more@]Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 507 2011-03-29 17:16:12
Backup Piece 35 2011-03-29 17:16:12 ham8euqg_1_1
Backup Set 511 2011-03-29 17:19:05
Backup Piece 39 2011-03-29 17:19:05 hem8ev1t_1_1
Backup Set 513 2011-03-29 17:21:14
Backup Piece 41 2011-03-29 17:21:14 him8ev5v_1_1
Backup Set 519 2011-03-29 17:24:55
Backup Piece 47 2011-03-29 17:24:55 hmm8ev63_1_1
Backup Set 522 2011-03-29 17:35:41
Backup Piece 50 2011-03-29 17:35:41 hrm8evv5_1_1
Backup Set 525 2011-03-29 19:04:16
Backup Piece 53 2011-03-29 19:04:16 hum8f45m_1_1
......
RMAN-06207: WARNING: 54 objects could not be deleted for SBT_TAPE 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 ham8euqg_1_1
......
看了一下日期,這些備份都是測試的時候產生的,後來已經用NBU直接清理掉了,但是看來RMAN沒有crosscheck這些備份片,沒有認出來這些備份片已經失效了。
解決方案是手工對這些備份片做一次crosscheck。
RMAN> allocate channel for maintenance device type sbt;
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=1426 instance=dwrac1 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
--原狀態
RMAN> list backuppiece 'ham8euqg_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
102 574 1 1 AVAILABLE SBT_TAPE ham8euqg_1_1
RMAN> crosscheck backuppiece 'ham8euqg_1_1';
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=ham8euqg_1_1 recid=102 stamp=747165779
Crosschecked 1 objects
--crosscheck後狀態改變
RMAN> list backuppiece 'ham8euqg_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
102 574 1 1 EXPIRED SBT_TAPE ham8euqg_1_1
--刪除備份片
RMAN> delete expired backup;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
102 574 1 1 EXPIRED SBT_TAPE ham8euqg_1_1
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=ham8euqg_1_1 recid=102 stamp=747165779
Deleted 1 EXPIRED objects
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/231499/viewspace-1048811/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN-06207 & RMAN-06208 問題處理
- 關於RMAN-06207和RMAN-06208錯誤的分析以及解決辦法
- 多對一處理 和一對多處理的處理
- Apache Beam,批處理和流式處理的融合!Apache
- RMAN 解決(RMAN-06208,RMAN-06207,ORA-19606)刪除過期檔案問題
- PHP錯誤處理和異常處理PHP
- CPU(中央處理器)和GPU(影像處理器)的區別GPU
- SFP和SDP處理
- 字串和日期時間的處理字串
- Nginx和Tomcat的session處理NginxTomcatSession
- Python錯誤處理和異常處理(二)Python
- CSS > 關於雪碧圖預處理和後處理方案的討論CSS
- 事件分發和處理事件
- CSAPP =2= 資訊的表示和處理APP
- ppt中插入和處理影片的方法
- Shell 引數的讀取和處理
- 【問題處理】使用trim和 replace處理字串中的換行符號字串符號
- Go語言的 序列處理 和 並行處理 有什麼區別 ?Go並行
- java中大數處理和高精度小數處理(so easy)Java
- Pandas中時間和日期處理
- 約束和異常處理
- 程式環境和預處理
- MPP架構和批處理架構
- 處理器架構和配置架構
- 迭代器和異常處理
- Oracle提交和回滾處理Oracle
- 使用JAXB處理JAVA和XMLJavaXML
- 06.字元和字串處理字元字串
- 處理VM的一種特殊方法和思路
- 第二章:資訊的表示和處理
- JavaScript和JQuery的滑鼠mouse事件冒泡處理JavaScriptjQuery事件
- 科學和工程中的訊號處理
- 四類ADSL故障的剖析和處理
- 日期和時間的儲存與處理
- Word處理文件和網頁的快捷鍵網頁
- 對於CSV檔案中{,}和{"}的處理
- Windows批處理中的變數和值Windows變數
- 處理百萬級以上的資料處理