免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12下一页
最近访问板块 发新帖
查看: 4829 | 回复: 15

NBU备份ORACLE出错 [复制链接]

论坛徽章:
0
发表于 2009-05-13 16:17 |显示全部楼层
三台AIX+ORACLE,正常备份二年多,最近一周,一台备份出错,都不成功.其设置无变化\r\n错误信息如下:\r\nScript /usr/openv/rman/hot.sh\r\n==== started on Sun May 10 18:16:58 BEIST 2009 ====\r\n\r\n\r\nRMAN: /oracle/app/oracle/db10g/bin/rman\r\nORACLE_SID: p5dbc2\r\nORACLE_USER: oracle\r\nORACLE_HOME: /oracle/app/oracle/db10g\r\n\r\nNB_ORA_FULL: 1\r\nNB_ORA_INCR: 0\r\nNB_ORA_CINC: 0\r\nNB_ORA_SERV: gznbumaster\r\nNB_ORA_POLICY: 172.26.0.16_oracle\r\n\r\nFull backup requested\r\n\r\nRecovery Manager: Release 10.2.0.2.0 - Production on Sun May 10 18:16:58 2009\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nconnected to target database: P5DBC (DBID=3554354975)\r\nconnected to recovery catalog database\r\n\r\nRMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> \r\nallocated channel: ch00\r\nchannel ch00: sid=2175 instance=p5dbc2 devtype=SBT_TAPE\r\nchannel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)\r\n\r\nallocated channel: ch01\r\nchannel ch01: sid=2155 instance=p5dbc2 devtype=SBT_TAPE\r\nchannel ch01: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)\r\n\r\nStarting backup at 10-MAY-09\r\nchannel ch00: starting incremental level 0 datafile backupset\r\nchannel ch00: specifying datafile(s) in backupset\r\ninput datafile fno=00002 name=/dev/rlv_undotbs1\r\ninput datafile fno=00084 name=/dev/rlv_wdev_dat02\r\ninput datafile fno=00091 name=/dev/rlv_ind_dat01\r\nchannel ch00: starting piece 1 at 10-MAY-09\r\nchannel ch01: starting incremental level 0 datafile backupset\r\nchannel ch01: specifying datafile(s) in backupset\r\ninput datafile fno=00004 name=/dev/rlv_undotbs2\r\ninput datafile fno=00088 name=/dev/rlv_mdata_dat02\r\ninput datafile fno=00098 name=/dev/rlv_fiim_dat01\r\nchannel ch01: starting piece 1 at 10-MAY-09\r\nRMAN-03009: failure of backup command on ch00 channel at 05/10/2009 18:17:50\r\nORA-19506: failed to create sequential file, name=\"bk_14188_1_686513844\", parms=\"\"\r\nORA-27028: skgfqcre: sbtbackup returned error\r\nORA-19511: Error received from media manager layer, error text:\r\n   VxBSAValidateFeatureId: Failed with error:\r\n   Server Status:  unexpected message received\r\nchannel ch00 disabled, job failed on it will be run on another channel\r\nreleased channel: ch00\r\nreleased channel: ch01\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03009: failure of backup command on ch01 channel at 05/10/2009 18:17:50\r\nORA-19506: failed to create sequential file, name=\"bk_14189_1_686513845\", parms=\"\"\r\nORA-27028: skgfqcre: sbtbackup returned error\r\nORA-19511: Error received from media manager layer, error text:\r\n   VxBSAValidateFeatureId: Failed with error:\r\n   Server Status:  unexpected message received\r\n\r\nRMAN> RMAN> \r\n\r\nRecovery Manager complete.\r\n\r\nScript /usr/openv/rman/hot.sh\r\n==== ended in error on Sun May 10 18:17:50 BEIST 2009 ====\r\n\r\n分析可能是什么问题,

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
发表于 2009-05-13 16:56 |显示全部楼层
普通文件的备份能成功吗?

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
发表于 2009-05-13 17:06 |显示全部楼层
这个错一般出在hostname的解析上,你用bpclntcmd 在master server检查一下。\r\n顺便把client和server的bp.conf贴上来看看

论坛徽章:
0
发表于 2009-05-13 17:08 |显示全部楼层
MMSERVER\r\n\r\n[p590c3b:root:/usr/openv/volmgr] more vm.conf\r\nMM_SERVER_NAME = p590c3b\r\nREQUIRED_INTERFACE =p590c3b\r\nDEVICE_HOST =p590c3b\r\n\r\n\r\nMASTER\r\n\r\n  /usr/openv/netbackup/bp.conf里已经有本条信息\r\n \r\nSERVER = gznbumaster\r\nSERVER =p590c3b \r\nCLIENT_NAME = p590c3b\r\nEMMSERVER = gznbumaster\r\nREQUIRED_INTERFACE = p590c3b\r\nMEDIA_SERVER=p590c3b

论坛徽章:
0
发表于 2009-05-13 17:10 |显示全部楼层
以上信息都是MMSERVER的

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
发表于 2009-05-13 18:38 |显示全部楼层
你最好在oracle机器上将NBU的bphdb,bpcd的日志激活,看一下具体的信息,你提供的信息太少了,没有办法差。\r\n这个主机名称看着有点眼熟牙,呵呵。

论坛徽章:
0
发表于 2009-05-13 19:51 |显示全部楼层
无牙维护过?还是在等待解决的方法论

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
发表于 2009-05-13 22:42 |显示全部楼层
呵呵,像是一个老用户的环境。\r\n如果是突然实现大面积Oracle备份有问题,问题会出在server上,不会是client上。弄不好就是解析的问题。

论坛徽章:
0
发表于 2009-05-13 22:49 |显示全部楼层
nbu的报错代码是多少?看着rman的报错信息很熟悉,是不是83或者84之类的错误?

论坛徽章:
0
发表于 2009-05-14 09:17 |显示全部楼层
肯定不是,NBU的作业错误应该是6了,对了,如果你去RMAN那边直接调用,做个通道的分配看看,不要去做别的什么备份的操作,看看可以不,还有就是最近有没有做过什么其他的操作,没道理放在那里什么都没动,就不能备份了吧
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP