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 -clientsql虚拟节点名 -connet_options 0 0 2
有如下提示信息：bptestbpcd main ： Function connect To BPCD <sql虚拟节点名> failed: 25 cannotconnect 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:09 编辑
此作业从发起到报错结束，持续时间在25min左右。
附上client端的一部分 vnetd日志：
12:29:45.006 <2> vnet_cached_getaddrinfo_and_update: ../../libvlibs/vnet_addrinfo.c.1371: 0: found in cache service: bprd
12:29:45.006 <2> vnet_sortaddrs: ../../libvlibs/vnet_addrinfo.c.4037: 0: sorted addrs:: 1 0x00000001
12:29:45.006 <2> vnet_cached_getaddrinfo_and_update: ../../libvlibs/vnet_addrinfo.c.1370: 0: found in cache name: master_IP
12:29:45.006 <2> vnet_cached_getaddrinfo_and_update: ../../libvlibs/vnet_addrinfo.c.1371: 0: found in cache service: NULL
12:29:45.006 <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.4893: 0: using interface : ANY
12:29:45.006 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:29:55.021 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:30:05.036 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:30:15.051 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:16.050 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:26.065 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:30:36.080 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:30:46.095 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:47.109 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:57.109 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:30:57.109 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:31:07.124 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:31:17.139 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:31:27.155 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:31:29.167 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:31:38.168 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:31:38.168 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:31:48.184 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:31:58.199 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:32:08.214 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:12.223 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:19.243 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:19.243 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:32:29.258 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 2 0x00000002
12:32:39.274 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 3 0x00000003
12:32:49.289 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:32:57.292 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:33:00.318 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:33:00.318 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
12:33:21.363 <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1376: 0: getsockopt SO_ERROR returned: 10060 0x0000274c
12:33:21.363 <2> connect_to_service: ../../libvlibs/vnet_connect.c.382: 0: vnet_async_connect() failed: 18 0x00000012
12:33:21.363 <2> vnet_connect_to_service: ../../libvlibs/vnet_connect.c.174: 0: connect_to_service() failed: 18 0x00000012
12:33:21.363 <2> bprd_connect: vnet_connect_to_service(master_server name) failed: 18
12:33:21.363 <2> bprd_get_features: bprd_connect(master_server name) failed, cannot connect on socket (25)
12:33:21.363 <16> bsa_checkFeatureId: unable to check if feature <33> is licensed
12:33:21.363 <16> bsa_checkFeatureId: Server exit status = 25: cannot connect on socket
12:33:21.363 <16> VxBSAInit: ERR - The license for the requested feature is not available. 问题解决了：
从client端回master server的静态路由掉了！重新加上静态路由就可以了！
troubleshooting 坑多啊！:-L
页:
[1]