Forum Discussion

abhay_kumar_tha's avatar
16 years ago

Problem in Restore

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
  • 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


  • 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.