Redirection de la Restauration SQL

Please post dbclient log.

Copy log file to dbclient.txt and upload as File attachment.

If dbclient log folder does not exist, please create folder on destination client, increase logging level to 3 and retry the restore. 

Before another restore attempt - change Client Read Timeout on media server to 7200.

If restore fails again, please upload dbclient log.

Hi

I changed read timeout client on the media server to 7200.
  dbclient the log folder or is, and how to increase the level of logging to 3 and run the restore.

To change logging level:

Master server: Host Properties -> Clients -> <Destination Client name> -> Logging
Or 
Open Backup, Archive, Restore GUI on destination client.
File -> NetBackup Client Properties -> Troubleshooting.
Change Verbose and Database levels to 3.

Create dbclient folder/directory under <install-path>\netbackup\logs.

Hi

 

I change the level of logging to 3

for the file already exists in dbclient master server and not in customer

We need dbclient log on the destination client. Create the folder if it does not exist.

 

Hi

I created the client file in the client
I restarted the restoration work

below the error message

///////////////////////////////////////////////////////////////////

4/22/2015 1:45:15 PM - Error bpbrm(pid=9948) socket read failed, An existing connection was forcibly closed by the remote host.  (10054)
4/22/2015 1:45:15 PM - Info bpbrm(pid=6764) child done, status 13         
4/22/2015 1:45:15 PM - Info bpbrm(pid=6764) sending message to media manager: STOP RESTORE dzorrpw24_1429329619     
4/22/2015 1:45:15 PM - end reading; read time: 0:00:05
4/22/2015 1:45:16 PM - Info bpbrm(pid=6764) media manager for backup id dzorrpw24_1429329619 exited with status 0: the requested operation was successfully completed
4/22/2015 1:45:16 PM - restored image dzorrpw24_1429329619 - (file read failed(13)); restore time 0:01:37
4/22/2015 1:45:22 PM - end Restore; elapsed time: 0:01:46
Restore error(2850)

///////////////////////////////////////////////////////////////

dbclient log  is required as per Marianne's recomendation, it is still missing.

Hope you have followed following technote for redirected restoration of SQL database.

https://support.symantec.com/en_US/article.TECH35995.html

Also check is restore from client is allowed from your destination client.

run following on your master server

install_path/bpclient -client client_name -L
Client Name: client_name
 Current Host:
        Hostname: client_name
 Dynamic Address:       no
 Free Browse:   Allow
 List Restore:  Allow Both
 

 

check for value of "List Restore" if it is not ALLOW both, then change it 
 

install_path/bpclient -client client_name -add -list_restore 1

or 

install_path/bpclient -client client_name -update -list_restore 1

We need client dbclient log.

Please copy the log to dbclient.txt and upload as File attachment.

If you have bpbrm log on the media server, please upload that as well. The errors above looks like there may be a timeout. 
dbclient and bpbrm logs will confirm.

Please also post all of the text in Job Details.

Hi

attached file dbclient
below the error message

4/22/2015 1:43:36 PM - begin Restore
4/22/2015 1:43:38 PM - 1 images required
4/22/2015 1:43:38 PM - media 0032L4 required
4/22/2015 1:43:39 PM - restoring image dzorrpw24_1429329619
4/22/2015 1:43:40 PM - Info bpbrm(pid=6764) dzorvpw71 is the host to restore to      
4/22/2015 1:43:40 PM - Info bpbrm(pid=6764) telling media manager to start restore on client     
4/22/2015 1:43:43 PM - Info bpbrm(pid=9948) dzorvpw71 is the host to restore to      
4/22/2015 1:43:43 PM - Info bpbrm(pid=9948) listening for client connection         
4/22/2015 1:43:45 PM - Info bptm(pid=9788) Waiting for mount of media id 0032L4 (copy 1) on server dzorrpw28.intranet.hyproc.
4/22/2015 1:43:45 PM - started process bptm (9788)
4/22/2015 1:43:45 PM - mounting 0032L4
4/22/2015 1:43:45 PM - requesting resource 0032L4
4/22/2015 1:43:45 PM - granted resource 0032L4
4/22/2015 1:43:45 PM - granted resource IBM.ULT3580-TD4.000
4/22/2015 1:43:47 PM - Info bptm(pid=9788) INF - Waiting for mount of media id 0032L4 on server dzorrpw28.intranet.hyproc for reading.
4/22/2015 1:43:50 PM - Info bpbrm(pid=9948) accepted connection from client         
4/22/2015 1:43:50 PM - Info tar32(pid=1620) Restore started.           
4/22/2015 1:43:50 PM - connected
4/22/2015 1:44:31 PM - mounted; mount time: 0:00:46
4/22/2015 1:44:31 PM - Info bptm(pid=9788) 0032L4            
4/22/2015 1:44:33 PM - Info bptm(pid=9788) INF - Waiting for positioning of media id 0032L4 on server dzorrpw28.intranet.hyproc for reading.
4/22/2015 1:44:33 PM - positioning 0032L4 to file 355
4/22/2015 1:45:10 PM - positioned 0032L4; position time: 0:00:37
4/22/2015 1:45:10 PM - begin reading
4/22/2015 1:45:15 PM - Error bpbrm(pid=9948) socket read failed, An existing connection was forcibly closed by the remote host.  (10054)
4/22/2015 1:45:15 PM - Info bpbrm(pid=6764) child done, status 13         
4/22/2015 1:45:15 PM - Info bpbrm(pid=6764) sending message to media manager: STOP RESTORE dzorrpw24_1429329619     
4/22/2015 1:45:15 PM - end reading; read time: 0:00:05
4/22/2015 1:45:16 PM - Info bpbrm(pid=6764) media manager for backup id dzorrpw24_1429329619 exited with status 0: the requested operation was successfully completed
4/22/2015 1:45:16 PM - restored image dzorrpw24_1429329619 - (file read failed(13)); restore time 0:01:37
4/22/2015 1:45:22 PM - end Restore; elapsed time: 0:01:46
Restore error(2850)