sybase ase restore with isql

Question

Hi all, I try to restore a SAP System with SAP Sybase ASE 15.7 SP100 with Networker v8.1.1.6 and isql commands. The installed client version is: lgtonmda-1.6.0.2-1 Can anyone give support to the commands to restore several log backups after the full restore is done? I do not want to do a point-in-time restore directly. The restore of the full backup is working: 1> load database SID from 'nsrsyb::.SID.SID' 2> go Networker automatically restores the last full backup. Information of the SID_BS.log: Jun 30 16:56:55 2014: Backup Server: 6.28.1.1: Dumpfile name 'SID141810EE4A ' section number 1 mounted on byte stream 'nsrsyb::.SID.SID..4./nsr/apps/tmp/sybtmp_17393.txt::000' Try to restore a single log with the timestamp out of the backup log: 1> load transaction SID from 'nsrsyb::.SID.SID..20140630165655' 2> go Backup Server session id is: 19. 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: 'nsrsyb::.SID.SID..20140630165655::000' Backup Server: 4.124.2.1: Archive API error for device='nsrsyb::.SID.SID..20140630165655::000': Vendor application name=EMC, Library version=200, API routine=syb_read(), Message=XBSA-1.0.1 8.1.1.2.Build.280 15017 Thu Jul  3 16:11:09 2014         _nwbsa_open_restore_session: System detected error due to: Failed to establish restore session. Exiting. Operation aborted Backup Server: 6.31.2.4: Volume rejected. Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit. Backup Server: 6.32.2.3: nsrsyb::.SID.SID..20140630165655::000: volume not valid or not requested (server: , session id: 19.) Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit. Msg 8009, Level 16, State 1: Server 'SID', Line 1: Error encountered by Backup Server.  Please refer to Backup Server messages for details. 1> What is the procedure/isql command to restore multiple log backups in sequence??? In the ASE backup file there is a dumpfile name for each backup. Is it possible to give the name to networker that this log backup should be recovered? Jun 30 16:56:55 2014: Backup Server: 6.28.1.1: Dumpfile name 'SID143820EE2A' section number 1 mounted on byte stream 'nsrsyb::.SID.SID..4./nsr/apps/tmp/sybtmp_17393.txt::000' Thanks for your help Arne

ble1 · Answer

What does daemon.raw says for that period on backup server?

NetWorker

Was this post helpful?