Restore SQL ERROR

[andrich]

Hello Everybody

My SQL DBA show me a error that occurs when he performs a Netbackup SQL restore.

BackupIoRequest::WaitForIoCompletion: read failure on backup device 'VNBU0-5420-2608-1384455034'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Anyone knows what this error means? Is this a Netbackup backups problem?

Thanks

[sri_vani]

Increasing virtual memory and/or physical memory may fix it

In some cases, rebooting the SQL server may solve this issue.

plz verify this link:http://www.symantec.com/business/support/index?page=content&id=TECH23413

[sri_vani]

It wld be good if you cld provide more details to narrow down possible errors

what kind of restore it is? alternate client, same client, with a different DB name,cluster restore...?

we need dbclient log also verify the Global Attributes are set to allow client browse and allow client restore @hostproperties-master server name

[andrich]

Sri, thanks for help

He has tried the two ways (same and another client destination). Its not a cluster restore.

This dbclient is found on the client or master server?

Attached I am sending the dbclient on client server.

[sri_vani]

will verify the logs and try help u here.

For redirected restore to a diff host

can u plz create a touch file on Master to create reqd permissions

install_path\NetBackup\db\altnames\No.Restrictions, to allow unrestricted redirected restore privileges

and try the restore

[andrich]

This file was already created in the past.

Log time ago this restore worked fine. 

Last week the DBA tried to do it and the error appears. I am thinking the problem is memory too.

Thanks for now.

[sri_vani]

yep plz verify it.

T0 chk mor details add TRACELEVEL MAX paramter on restore/move script and send the recent dbclient log (with verbose 5)frm client
http://www.symantec.com/business/support/index?page=content&id=TECH206956
to verify if any  bkwardincompatable issues(sql 2005 ri8?)
 

[Marianne]

Only 1.txt contains restore attempt - we don't know which date (we would have known if you kept the date-stamp that is the original file name).

Errors in this file:

08:55:39.671 [5436.236] <16> readFromServer: ERR - recv() returned 0 while reading 4194304 bytes on 112 socket
08:55:39.671 [5436.236] <16> dbc_get: ERR - failed reading data from server, bytes read = -1
08:55:39.781 [5436.236] <16> VxBSAGetData: ERR - Could not do a bsa_get().

We will need the corresponding media server logs to see why no data was sent to the client. These logs are bptm and bpbrm.

One possibility is a timeout.

SQL needs time to build the database before starting to write to it. If normal timeout settings are on the media server, it will timeout before the client can actually start receiving data.

We normally make Client Read Timeout on the media server at least 7200 (3 hours) for large SQL restores.

So - increase Client Read Timeout on the media server, ensure media server log folders exist (bptm and bpbrm) and retry the restore.

If restore fails again, we will need a full set of logs for that particular day that covers restore attempt:
dbclient on the client as well as SQL vdi and Error log
bptm and bpbrm on media server.

Copy log files to reflect the process name (e.g. bptm.txt) and post as File attachments.

[andrich]

Hello

My DBA SQL tried a restore again. The dbclient is attached.

When he starts the restore, there is no job running in Netbackup server.

Thanks for now

[Will_Restore]

Err - Error in VxBSAQueryObject: 17
Continuation: No object matched the specified predicate.

SOLUTION:
Correct the SQL restore batch script to lower case, same as the policy, then the backup image will be found and the restore will be successful.

Article URL http://www.symantec.com/docs/TECH63773

SVERP_DSVPST is not the same as  sverp_dsvpst

[sri_vani]

also plz verify below technote for error removing  odc data store

http://www.symantec.com/business/support/index?page=content&id=TECH185717

Error removing ODBC data source name DSN=NBMSSQL_temp_3784_408_1
14:28:07.923 [3784.408] <1> CGlobalInformation::DeleteDSN:     CONTINUATION: - Invalid DSN

[Marianne]

I see multiple attempts to connect to bprd on the master, followed by 'No match was found...'

14:27:25.001 [5660.5548] <2> logconnections: BPRD CONNECT FROM 192.168.2.148.2006 TO 192.168.4.26.13724
14:27:26.219 [5660.5548] <4> VxBSAQueryObject: INF - No match was found for query

Do you have bprd log enabled on the master server?.

If so, please post bprd that covers the same time as restore attempt.

[andrich]

Marianne

Follow atatched the file you ask for.

Thanks

[Marianne]

Please help us understand what exactly the dba is trying to do.

Redirected restore maybe?

I see reference to 2 different hostname in the same restore request:

14:29:03.966 [14198] <2> hosts_equal: host1 BANCOERP2 bancoerp2 addr 192.168.2.142 (0xc0a8028e)
14:29:03.966 [14198] <2> hosts_equal: host2 sverp_dsvpst sverp_dsvpst addr 192.168.2.148 (0xc0a80294)
14:29:03.966 [14198] <2> hosts_equal: hostnames DO NOT compare
14:29:03.966 [14198] <2> hosts_equal: name1=BANCOERP2  name2=sverp_dsvpst
14:29:03.966 [14198] <2> hosts_equal: hostbuf=bancoerp2  hostentry->h_name=sverp_dsvpst

If this is a redirected restore, have you authorised that by creating No.Restrictions touch file on the master? Or filenames in altnames folder to allow destination client to request images for source client?

Please ask for screenshots that will tell us step-by-step process followed by the dba.

[andrich]

Dear Marianne

That´s exactly what my DBA is trying: restoring the bancoerp2 image backup to a differrent destination called sverp_dsvpst.

My altnames in my Netbackup server is:

-bash-3.00# pwd

/usr/openv/netbackup/db/altnames

-bash-3.00# ls -la

total 17

drwxr-xr-x   2 root     root          13 Jun 30  2011 .

drwxr-xr-x  20 root     bin           22 Jun 12  2012 ..

-rwxr-xr-x   1 root     root           0 Mar 12  2010 No.Restrictions

-rw-r--r--   1 root     root           0 Mar 12  2010 bancoerp2

-rw-r--r--   1 root     root           0 Aug  9  2010 orapppeo

-rw-r--r--   1 root     root           0 Apr 19  2010 sverp_dsvpst

-rw-r--r--   1 root     root           0 Mar 12  2010 sverpbanco

-rw-r--r--   1 root     root           0 Jun 30  2011 svfatura

-rw-r--r--   1 root     root           0 Jun 30  2011 svfaturades

-rwxr-xr-x   1 root     root           0 Dec 17  2009 svmmprod-oracle

-rw-r--r--   1 root     root           0 Mar 17  2010 svmmprod1

-rwxr-xr-x   1 root     root           0 Dec 17  2009 svmmprod2

-rw-r--r--   1 root     root           0 Aug  9  2010 svpppoe2

Follow attached the bch script generated by my DBA. When he start it, there is no job running in my Activity Monitor.

Thanks for now.

Alexandre Andrich

[ontherocks]

Remove below lines from script :-

OPERATION RESTORE
OBJECTTYPE TRXLOG
# 
#  Replace the database name in the following line with the name of the database that you
#  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
# 
DATABASE "FT890SER"
#
#  Replace the file path <F:\PSDT\FT890SER\FT890SER_1.ldf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "FP800SER_Log".
#MOVE  "FP800SER_Log"
#TO  "F:\PSDT\FT890SER\FT890SER_1.ldf"
#
# The following image is type: transaction log
NBIMAGE "bancoerp2.MSSQL7.BANCOERP2.trx.FT890SER.~.7.001of001.20131127054918..C"
SQLHOST "sverp_dsvpst"
NBSERVER "svbackup"
BROWSECLIENT "bancoerp2"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
STOPAT 20131127/05:49:18
RECOVEREDSTATE NOTRECOVERED
NUMBUFS 2
ENDOPER TRUE

-----------------------------------------------------------------------------------

Change NUMBUFS from 2 to 1

----------------------------------------------------------------------------------

Initiate the script and confirm

[andrich · Accepted solution]

 Hello Everybody

Found the error:

The configuration of the F7 (SQL Server connection Properties) in Netbackup MS SQL Client was wrong.

I fill it with the SQL "sa" credentials and works fine.

This doc help me a lot.

http://www.symantec.com/business/support/index?page=content&id=TECH51062

Thanks everybody and excuse me for anything.