TSM + Oracle備份出現問題
備份錯誤如下
Starting backup at 26-JUL-08
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2129 recid=2119 stamp=661009059
input archive log thread=1 sequence=2130 recid=2120 stamp=661083896
input archive log thread=1 sequence=2131 recid=2121 stamp=661089734
input archive log thread=1 sequence=2132 recid=2122 stamp=661089734
channel t1: starting piece 1 at 26-JUL-08
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 07/26/2008
12:03:31
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12) Server media mount not possible
Recovery Manager complete.
channel t2: starting piece 1 at 27-JUL-08
RMAN-03009: failure of backup command on t1 channel at 07/27/2008
02:07:39
ORA-19502: write error on file "incr_20080727_2815_1", blockno 486913
(blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12) Server media mount not possible
channel t1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on t2 channel at 07/27/2008
02:11:27
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file "incr_20080727_2816_1", blockno 49665
(blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12) Server media mount not possible
channel t2 disabled, job failed on it will be run on another channel
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t2 channel at 07/27/2008
02:11:27
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file "incr_20080727_2816_1", blockno 49665
(blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12) Server media mount not possible
RMAN-03009: failure of backup command on t1 channel at 07/27/2008
02:07:39
ORA-19502: write error on file "incr_20080727_2815_1", blockno 486913
(blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12) Server media mount not possible
Recovery Manager complete.
原因主要有如下:
第一:磁帶的空間不夠
第二:TSM備份軟體出現問題
第三:DRIVER 壞了或者不夠用的
這裡檢查Tivoli Storage Manager(簡稱TSM)伺服器日誌後,發現是TSM伺服器連線
磁帶不正常,重啟TSM伺服器後,則可以正常備份了。
(具體什麼原因導致TSM不能正常工作,可能是因為機房停電後,TSM伺服器則不能正常工作)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31344955/viewspace-2102955/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE tsm 備份錯誤Oracle
- TSM ORACLE 備份排程Oracle
- sap brtools發起oracle備份失敗,tsm備份軟體備份報錯Oracle
- TSM for Oracle備份指令碼及策略說明Oracle指令碼
- TSM備份時提示認證失敗(Authentication failure)問題的解決AI
- 沒有備份undo segment出現問題的處理
- ORACLE 備份故障,原因是tsm密碼過期Oracle密碼
- 資料庫重啟,TSM不能備份,需要在TSM的客戶端(ORACLE)啟動TSM監控程式資料庫客戶端Oracle
- 基於tsm的oracle資料庫備份及恢復Oracle資料庫
- 因AIX系統目錄許可權問題導致TSM備份失敗AI
- TSM無法備份故障解決(續)
- TSM備份軟體實施步驟
- Oracle RMAN 備份控制檔案報錯問題Oracle
- Oracle備份和恢復常見問題解答Oracle
- oracle備份出了問題,請教大俠看看!!!Oracle
- TSM配置不好導致備份不正常,從而導致資料庫效能問題資料庫
- 操作oracle出現的問題Oracle
- TSM+RMAN 自動備份指令碼 on aix指令碼AI
- Oracle EXPDP自動備份緩慢問題解決Oracle
- Oracle資料庫備份、災備的23個常見問題Oracle資料庫
- oracle安裝出現的問題Oracle
- IBM TSM備份軟體的安裝方法IBM
- 手動刪除了歸檔日誌後,rman備份出現問題解決
- OCR自動備份目錄cdata下出現大量的OCR備份檔案問題
- TSM備份時因歸檔日誌丟失而導致備份失敗
- TSM中備份(Backup)和歸檔(Archive)的區別Hive
- oracle備份--離線備份Oracle
- Oracle 自動備份觸發ORA-01513問題Oracle
- 用java做oracle資料庫備份有問題!急急急!!!JavaOracle資料庫
- oracle 10204 64 bit on aix 5.3 nbu 備份問題OracleAI
- TSM故障問題解決一則
- oracle 備份Oracle
- oracle備份Oracle
- TSM單個資料庫無法備份故障一則資料庫
- TSM備份ANS0326E錯誤及解決
- 轉:IBM儲存備份管理軟體TSM介紹IBM
- mysql主備切換canal出現的問題解析MySql
- MySQL Backup--Xtrabackup備份限速問題MySql