使用Netback備份Oracle報ora-27206錯誤處理

標籤：oracle   netbackup   rman   ora-27206   

今天，同事的Database Backup出現問題，幫忙查看，錯誤資訊如下：

channel ch01: starting piece 1 at 2015-01-12:22:06:56RMAN-03009: failure of backup command on ch01 channel at 01/12/2015 22:11:51ORA-19513: failed to identify sequential fileORA-27206: requested file not found in media management catalogcontinuing other job steps, job failed will not be re-runchannel ch01: starting incremental level 0 datafile backup setchannel ch01: specifying datafile(s) in backup setincluding current control file in backup setchannel ch01: starting piece 1 at 2015-01-12:22:11:52RMAN-03009: failure of backup command on ch01 channel at 01/12/2015 22:12:27ORA-19513: failed to identify sequential fileORA-27206: requested file not found in media management catalogcontinuing other job steps, job failed will not be re-runchannel ch01: starting incremental level 0 datafile backup setchannel ch01: specifying datafile(s) in backup setincluding current SPFILE in backup setchannel ch01: starting piece 1 at 2015-01-12:22:12:27RMAN-03009: failure of backup command on ch01 channel at 01/12/2015 22:12:52ORA-19513: failed to identify sequential fileORA-27206: requested file not found in media management catalogcontinuing other job steps, job failed will not be re-runreleased channel: ch00released channel: ch01RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on ch00 channel at 01/12/2015 23:23:57ORA-19513: failed to identify sequential fileORA-27206: requested file not found in media management catalog

網上查詢資料如下：

查看mos發現[ID 558993.1]提供了錯誤原因和解決方案
錯誤原因：RMAN backup to tape using veritas netbackup，The MML parameters like NB_ORA_CLIENT and NB_ORA_SERV were not given in proper case while configuring channel in RMAN backup.
解決方案：The NB_ORA_CLIENT and NB_ORA_SERV MML parameters are case sensitive. So make sure to give these parameters in same case while allocating or configuring RMAN channel as it is configure in Veritas server.

查看伺服器配置，果然主機名稱配置不正確，一是將大小寫沒匹配好，二是將主機名稱裡的數字0寫成了字母o。改之，觀察備份結果，一切正常

使用目標資料庫控制檔案替代恢複目錄分配的通道: c1通道 c1: SID=601 裝置類型=SBT_TAPE通道c1: Veritas NetBackup for Oracle - Release 7.1 (20110203)啟動 backup 於 13-1月 -15通道 c1: 正在啟動全部資料檔案備份組通道 c1: 正在指定備份組內的資料檔案備份組內包括當前控制檔案通道 c1: 正在啟動段 1 於 13-1月 -15通道 c1: 已完成段 1 於 13-1月 -15段控制代碼=1hpskim5_1_1 標記=TAG20150113T155029 注釋=API Version 2.0,MMS Version 5.0.0.0通道 c1: 備份組已完成, 經過時間:00:00:26完成 backup 於 13-1月 -15釋放的通道: c1

使用Netback備份Oracle報ora-27206錯誤處理