转：使用Netback备份Oracle报ORA-27206错误处理

末蓝、 2024-04-18 20:53 40阅读 0赞

## 使用Netback备份Oracle报ORA-27206错误处理 ##

<table> 
 <tbody> 
  <tr> 
   <td>[日期：2015-01-13]</td> 
   <td>来源：Linux社区&nbsp; 作者：yidian815</td> 
   <td>[字体：大&nbsp;中&nbsp;小]</td> 
  </tr> 
 </tbody> 
</table>

今天，同事的[Oracle][]数据库备份出现问题，帮忙查看，错误信息如下：

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

更多Oracle相关信息见[Oracle][Oracle 1] 专题页面 [http://www.linuxidc.com/topicnews.aspx?tid=12][Oracle 1]

**本文永久更新链接地址**：[http://www.linuxidc.com/Linux/2015-01/111737.htm][http_www.linuxidc.com_Linux_2015-01_111737.htm]

[Oracle]: http://www.linuxidc.com/topicnews.aspx?tid=12
[Oracle 1]: https://www.linuxidc.com/topicnews.aspx?tid=12
[http_www.linuxidc.com_Linux_2015-01_111737.htm]: https://www.linuxidc.com/Linux/2015-01/111737.htm