Chinaunix

标题: NBU7.1.0.2的备份sql 2005报2号错！ [打印本页]
作者: rand1985    时间: 2012-12-17 14:59
标题: NBU7.1.0.2的备份sql 2005报2号错！
sql 备份报2号错。

master server：windows 2003 server ；
client   （cluster）： windows 2008 R2 ；
SQL server : sql server 2005
备份脚本放在共享磁盘上。
    master server与client之间有防火墙，  在防火墙上打开13724（vnetd /双向打开）,13720(bprd /单向,client -->master server)     

1、在master server上使用 install_path\netbackup\bin\admincmd\bptestbpcd -M master_server -client  sql虚拟节点名 -connet_options 0 0 2  
     有如下提示信息：bptestbpcd main ： Function connect To BPCD <sql虚拟节点名> failed: 25   cannot  connect to on socket。
更换client 为 活动节点的主机名   也同样报25号错。



****************************************

2012-12-12 12:44:22 - Info nbjm(pid=10092) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=377940, request id:{3FB6359B-8221-4468-8508-E91FEAD92D3B})  
2012-12-12 12:44:22 - requesting resource sccfile02103-hcart2-robot-tld-1
2012-12-12 12:44:22 - requesting resource sccfile02103.NBU_CLIENT.MAXJOBS.plutoqzsqlclu
2012-12-12 12:44:22 - requesting resource sccfile02103.NBU_POLICY.MAXJOBS.db_pluqz_full
2012-12-12 12:44:22 - granted resource sccfile02103.NBU_CLIENT.MAXJOBS.plutoqzsqlclu
2012-12-12 12:44:22 - granted resource sccfile02103.NBU_POLICY.MAXJOBS.db_pluqz_full
2012-12-12 12:44:22 - granted resource sccfile02103-hcart2-robot-tld-1
2012-12-12 12:44:22 - estimated 0 Kbytes needed
2012-12-12 12:44:22 - Info nbjm(pid=10092) started backup job for client plutoqzsqlclu, policy db_pluqz_full, schedule db_pluqz_fullbackup_at_2 on storage unit sccfile02103-hcart2-robot-tld-1
2012-12-12 12:44:23 - started process bpbrm (7312)
2012-12-12 12:44:46 - Info bpbrm(pid=7312) plutoqzsqlclu is the host to backup data from     
2012-12-12 12:44:46 - Info bpbrm(pid=7312) reading file list from client        
2012-12-12 12:44:46 - connecting
2012-12-12 12:45:32 - Info bpbrm(pid=7312) starting bphdb on client         
2012-12-12 12:45:32 - connected; connect time: 00:00:46
2012-12-12 12:45:33 - Info bphdb(pid=8844) Backup started           
2012-12-12 12:56:57 - Error bpbrm(pid=7312) from client plutoqzsqlclu: ERR - command failed: none of the requested files were backed up (2)
2012-12-12 13:08:19 - Error bpbrm(pid=7312) from client plutoqzsqlclu: ERR - command failed: none of the requested files were backed up (2)
2012-12-12 13:08:19 - Error bpbrm(pid=7312) from client plutoqzsqlclu: ERR - bphdb exit status = 2: none of the requested files were backed up
2012-12-12 13:08:44 - end writing
none of the requested files were backed up(2)

***************************************************

作者: rand1985    时间: 2012-12-17 15:06
本帖最后由 rand1985 于 2012-12-17 15:09 编辑

此作业从发起到报错结束，持续时间在25min左右。

附上client端的一部分 vnetd日志：

12:29:45.006 [9188.9860] <2> vnet_cached_getaddrinfo_and_update: ../../libvlibs/vnet_addrinfo.c.1371: 0: found in cache service: bprd
12:29:45.006 [9188.9860] <2> vnet_sortaddrs: ../../libvlibs/vnet_addrinfo.c.4037: 0: sorted addrs:: 1 0x00000001
12:29:45.006 [9188.9860] <2> vnet_cached_getaddrinfo_and_update: ../../libvlibs/vnet_addrinfo.c.1370: 0: found in cache name: master_IP
12:29:45.006 [9188.9860] <2> vnet_cached_getaddrinfo_and_update: ../../libvlibs/vnet_addrinfo.c.1371: 0: found in cache service: NULL
12:29:45.006 [9188.9860] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.4893: 0: using interface : ANY
12:29:45.006 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:29:55.021 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:30:05.036 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:30:15.051 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:16.050 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:26.065 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:30:36.080 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:30:46.095 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:47.109 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:57.109 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:57.109 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:31:07.124 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:31:17.139 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:31:27.155 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:31:29.167 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:31:38.168 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:31:38.168 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:31:48.184 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:31:58.199 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:32:08.214 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:12.223 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:19.243 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:19.243 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:32:29.258 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:32:39.274 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:32:49.289 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:57.292 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:33:00.318 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:33:00.318 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:33:21.363 [9188.9860] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:33:21.363 [9188.9860] <2> connect_to_service: ../../libvlibs/vnet_connect.c.382: 0: vnet_async_connect() failed: 18 0x00000012
12:33:21.363 [9188.9860] <2> vnet_connect_to_service: ../../libvlibs/vnet_connect.c.174: 0: connect_to_service() failed: 18 0x00000012
12:33:21.363 [9188.9860] <2> bprd_connect: vnet_connect_to_service(master_server name) failed: 18
12:33:21.363 [9188.9860] <2> bprd_get_features: bprd_connect(master_server name) failed, cannot connect on socket (25)
12:33:21.363 [9188.9860] <16> bsa_checkFeatureId: unable to check if feature <33> is licensed
12:33:21.363 [9188.9860] <16> bsa_checkFeatureId: Server exit status = 25: cannot connect on socket
12:33:21.363 [9188.9860] <16> VxBSAInit: ERR - The license for the requested feature is not available.
作者: rand1985    时间: 2012-12-23 22:53
问题解决了：
      从client端回master server的静态路由掉了！重新加上静态路由就可以了！  

          troubleshooting 坑多啊！



欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2