今天,同事的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