cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in Restore

abhay_kumar_tha
Level 2
Hi ,

Any assistance will be appreciated, we are using Veritas Netbackup 5.1

We had a SQL server which was recently formated , where we lost the data.

It was being backed up by "C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\SQL_ALL_DBs.bch"----- one of the script to initiate backup from server to media., In the Netbackup restore console we are able see the datas in media which we need to restore , but we are not able to do so... error(25)

6/25/2009 11:41:56 PM - started process bptm (4524)
6/25/2009 11:41:56 PM - mounting DVJ647
6/25/2009 11:42:35 PM - mounted; mount time: 00:00:39
6/25/2009 11:42:35 PM - positioning DVJ647 to file 139
6/25/2009 11:42:55 PM - Error bpbrm(pid=2608) listen for client timeout during accept from data listen socket after 60 seconds
6/25/2009 11:43:44 PM - positioned DVJ647; position time: 00:01:09
6/25/2009 11:43:44 PM - begin reading
6/25/2009 11:47:55 PM - end Restore; elapsed time: 00:06:35
cannot connect on socket(25)

------

23:41:20 6/25/2009: Restore Started

23:41:21 (373665.xxx) Restore job id 373665 will require 4 images.
23:41:21 (373665.xxx) Media id DVJ647 is needed for the restore.
23:41:21 (373665.xxx) Media id DVP799 is needed for the restore.
23:41:21 (373665.xxx) Media id DVP748 is needed for the restore.

23:41:55 (373665.001) Restoring from image created 6/21/2009 6:08:29 PM
23:41:55 (373665.001) INF - Data socket = server name.na.emersonprocess.com.3156
23:41:55 (373665.001) INF - Name socket = server name.na.emersonprocess.com.3572
23:41:55 (373665.001) INF - Job id = 373665
23:41:55 (373665.001) INF - Backup id = SERVER NAME_1245625709
23:41:55 (373665.001) INF - Backup time = 1245625709
23:41:55 (373665.001) INF - Policy name = P_Z_SQL_WK13
23:41:55 (373665.001) INF - Snapshot = 0
23:41:55 (373665.001) INF - Frozen image = 0
23:41:55 (373665.001) INF - Backup copy = 0
23:41:55 (373665.001) INF - Master server = MASTER SERVER
23:41:55 (373665.001) INF - Media server = SERVER NAME
23:41:55 (373665.001) INF - New data socket = MASTER SERVER.na.emersonprocess.com.0
23:41:55 (373665.001) INF - Use shared memory = 1
23:41:55 (373665.001) INF - Restore id = 373665.001
23:41:55 (373665.001) INF - Encrypt = 0
23:41:55 (373665.001) INF - Client read timeout = 300
23:41:55 (373665.001) INF - Media mount timeout = 0
23:41:55 (373665.001) INF - client = SERVER NAME
23:41:55 (373665.001) INF - requesting_client = MASTER SERVER
23:41:55 (373665.001) INF - browse_client = SERVER NAME
23:41:56 (373665.001) INF - Waiting for mount of media id DVJ647 on server SERVER NAME for reading.
23:42:35 (373665.001) INF - Waiting for positioning of media id DVJ647 on server SERVER NAME for reading.
23:43:44 (373665.001) INF - Beginning restore from server SERVER NAME to client SERVER NAME.
23:47:55 INF - Server status = 25
23:47:55 (373665.004) Status of restore from image created 6/23/2009 7:23:19 PM = cannot connect on socket

23:47:55 (373665.004) The following files/folders were not restored:
23:47:55 (373665.004) UTF - /SERVER NAME.MSSQL7.SERVER NAME.db.QuoteTool.~.7.001of001.20090623192244..C

23:47:55 (373665.003) Status of restore from image created 6/23/2009 7:09:12 PM = cannot connect on socket

23:47:55 (373665.003) The following files/folders were not restored:
23:47:55 (373665.003) UTF - /SERVER NAME.MSSQL7.SERVER NAME.db.FR_CompanyDB.~.7.001of001.20090623190839..C

23:47:55 (373665.002) Status of restore from image created 6/21/2009 6:20:45 PM = cannot connect on socket

23:47:55 (373665.002) The following files/folders were not restored:
23:47:55 (373665.002) UTF - /SERVER NAME.MSSQL7.SERVER NAME.db.QuoteTool.~.7.001of001.20090621182042..C

23:47:55 (373665.001) Status of restore from image created 6/21/2009 6:08:29 PM = cannot connect on socket

23:47:55 (373665.001) The following files/folders were not restored:
23:47:55 (373665.001) UTF - /SERVER NAME.MSSQL7.SERVER NAME.db.FR_CompanyDB.~.7.001of001.20090621180819..C

23:47:55 (373665.xxx) INF - Status = cannot connect on socket.

Please assist!!!

Regards,
Abhay
3 REPLIES 3

Deepak_W
Level 6
Partner Accredited
Status code 25 caused by no open sockets on the Master/Media Server

A socket in a TIME_WAIT state may be made available sooner by reducing the tcp_time_wait_interval parameter. The default for this parameter on Solaris is 240000 milliseconds or 4 minutes. The default for Hewlett-Packard (HP) is a value of 60000 milliseconds or 1 minute. The default on AIX is set in increments of 15 seconds. The default value is 1 or 15 seconds. On AIX, this is the lowest it may be set to. VERITAS has found that the tcp_time_wait_interval can often be set to 1 second with no adverse effects. However, customers should adjust the TCP_TIME_WAIT_INTERVAL in increments; lowering the value until backups no longer fail with the status 25.

check the below mentioned link for this issue...

http://seer.entsupport.symantec.com/docs/264886.htm

Nicolai
Moderator
Moderator
Partner    VIP   


You need to check  :
  • In bprd that  host names are configured/detected correctly (I have found some very funny typos there)
  • That REQUIRE_INTERFACE is set on the client if it has multiple NIC's
  • Forward/reverse DNS lookup matches
  • If Windows software firewall prevent access to the client.
If do not believe you are out of free sockets. Check if plain file restore works fist. Then proceed to SQL restore.

Francis_Doran
Level 4
Is the following tech note relevant to you?

http://seer.entsupport.symantec.com/docs/233576.htm

Is your patch level the same for you Master Server and Client?