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

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

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

channel ch01: starting piece 1 at 2015-01-12:22:06:56
RMAN-03009: failure of backup command on ch01 channel at 01/12/2015 22:11:51
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
continuing other job steps, job failed will not be re-run
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
including current control file in backup set
channel ch01: starting piece 1 at 2015-01-12:22:11:52
RMAN-03009: failure of backup command on ch01 channel at 01/12/2015 22:12:27
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
continuing other job steps, job failed will not be re-run
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch01: starting piece 1 at 2015-01-12:22:12:27
RMAN-03009: failure of backup command on ch01 channel at 01/12/2015 22:12:52
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
continuing other job steps, job failed will not be re-run
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 01/12/2015 23:23:57
ORA-19513: failed to identify sequential file
ORA-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