今天，同事的數據庫備份出現問題，幫忙查看，錯誤信息如下：
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
