05-04-2015 01:37 AM
Good day
I successfully perform an SAP ASE database backup to Netbackup. when I execute the restore command:
load database SA2 from "sybackup::SYBASE.SA2.T.0.15948.30-04-2015.10:22:13 -SERV MASTER_SERVER"
I receive the following:
Backup Server session id is: 21. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'sybackup::SYBASE.SA2.T.0.15948.30-04-2015.10:22:13 -SERV MASTER_SERVER::000'
Backup Server: 4.124.2.1: Archive API error for
device='sybackup::SYBASE.SA2.T.0.15948.30-04-2015.10:22:13 -SERV
03RNB-PRD-BCK01::000': Vendor application name='Veritas NetBackup for SYBASE,
Library version=760000, API routine=syb_open(), Message= Restore failed -
syb_open: ERR - BSAQueryObject() failed with error - No object matched the
specified predicate.. Please refer to sybackup log for more info.
Msg 8009, Level 16, State 1:
Server 'SA2', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.
I have no idea what is causing this. Any help would be appreciated.
Thanks
Wilhelm
Solved! Go to Solution.
05-04-2015 03:11 AM
Me neither - so I will rely on my Netbackup knowledge
ERR - BSAQueryObject() failed with error - No object matched the specified predicate
I think this mean Netbackup can't find the backup to restore.
For enhanced debugging create directory sybackup in /usr/openv/netbackup/logs. Ensure the directory has 777 permissions. Re-run operation and attach output from the debugging to a post as a file - do not bulk post debug data as it will be marked as spam.
There is help to find in Netbackup Sybase admin guide chapter 5
http://www.symantec.com/docs/DOC6483
try a bplist run as root - you should see file being returned:
bplist -B -C host_name -t 7 -l -R -s 01/01/2015 /
Make sure the client name is correct according to Netbackup - e.g. srv1.acme.com and srv1 is two different server is in Netbackups mind.
05-04-2015 03:11 AM
Me neither - so I will rely on my Netbackup knowledge
ERR - BSAQueryObject() failed with error - No object matched the specified predicate
I think this mean Netbackup can't find the backup to restore.
For enhanced debugging create directory sybackup in /usr/openv/netbackup/logs. Ensure the directory has 777 permissions. Re-run operation and attach output from the debugging to a post as a file - do not bulk post debug data as it will be marked as spam.
There is help to find in Netbackup Sybase admin guide chapter 5
http://www.symantec.com/docs/DOC6483
try a bplist run as root - you should see file being returned:
bplist -B -C host_name -t 7 -l -R -s 01/01/2015 /
Make sure the client name is correct according to Netbackup - e.g. srv1.acme.com and srv1 is two different server is in Netbackups mind.
05-04-2015 09:27 AM
Also check to see if dbbackex.exe is crashing and confirm all capatilization matches in the batch file. I have seen a case where the NBIMAGE entry was incorrect and did not match.
Example:
NBIMAGE "PXXSQL4V6.MSSQL7.PXXSQL4V61\VENDER.db.Core_MSCM.~.7.001of001.20130216231..C"
to
NBIMAGE "PXXSQL4V6.MSSQL7.PXXSQL4V6\vender.db.Core_MSCM.~.7.001of001.20130216231..C"
To confrim:
bplist -C PXXSQL4V6 -t 15 -R /
05-04-2015 01:09 PM
-t 15 is for MS-SQL - This is Sybase