on 06-27-2015 4:18 PM
Hi,
We are performing a system refresh from production to Test system and when we try to load the database using Data protector , we are getting an error and we are not sure where does the problem is.
1> load database T15 from "ob2syb::2015/06/27-242::P15::P15"
2> go
Backup Server session id is: 8. 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: 'ob2syb::2015/06/27-242::P15::P15::000'
Backup Server: 4.141.2.24: [109] The 'api_read' call failed for database/archive device while working on stripe device 'ob2syb::2015/06/27-242::P15::P15::000' with error number 0 (Success). Refer to your operating system documentation for further details.
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: 4.125.1.1: Archive API information for device='ob2syb::2015/06/27-242::P15::P15::000': Vendor application name=Data Protector A.08.10, Library version=221, Message=[Critical] From: OB2BAR@<hostname> "T15" Time: 06/27/2015 01:41:58 PM ABORT_ON_CLOSE received. Aborting .
Backup Server: 6.32.2.3: ob2syb::2015/06/27-242::P15::P15::000: volume not valid or not requested (server: , session id: 8.)
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 'T15', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
Following are the pre-steps I have done before loading the database.
I have attached the ddlgen statements from the source system and the steps that are done in the target database. I'm not sure where is the problem.
Can you please help me there?
I'm able to load the database with the backup taken in the target database without issues. I feel it could be something related to change in the SID's.
Thanks and Regards,
Vimal
Hi
The issue is fixed by adding a parameter OB2HOSTNAME =< servername from where the backup is taken>
Thanks and Regards,
Vimal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vimal,
This was already document and SAP Note is written and released by me in May 2016
2283190 - Unrecoverable I/O or volume error While loading backup from HP DataProtector - SAP ASE
Do let me know based on your observation something needed to be added, so that i can inculcate the changes and republish again.
Regards
Kiran K Adharapuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi guys,
we are facing the same problem.
Have already added the parameter but still the device isn't found.
Any ideas?
Kind regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We had the same problem with an automated dump and load script that worked flawless for years. The dump is written to two dumpfiles in the filesystem. The only way to get this working again was to stripe to four dumpfiles, but we don't know why this happend. Dumpfiles had a size of 23gb each in the two-file configuration, so I doubt this has been an issue with the filesize.
Error message:
Backup Server: 4.188.1.1: Database db1: 124868642 kilobytes (48%) LOADED.
Backup Server: 4.141.2.22: [109] The 'api_read' call failed for database/archive device while working on stripe device
'compress::1::/path/db1.1607300155.fdmp.1::000' with error number 0 (Success). Refer to your operating system documentation for further details.
Backup Server: 6.32.2.3: compress::1::/path/db1.1607300155.fdmp.2::001: volume not valid or not requested (server: , session id: 143.)
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 'sybfcs4prod', Line 1: Error encountered by Backup Server. Please refer to Backup Server messages for details.
*** RESTORE FAILED ***
Msg 930, Level 14, State 1:
Server 'sybfcs4prod', Line 1:
Database 'db1' cannot be opened because either an earlier system termination
left LOAD DATABASE incomplete or the database is created with 'for load' option.
Load the database or contact a user with System Administrator (SA) role.
Version:
Adaptive Server Enterprise/15.7/EBF 22779 SMP SP122 /P/x86_64/Enterprise Linux/ase157sp12x/3662/64-bit/FBO/Sat Apr 19 05:48:19 2014
Any ideas on this?!
Regards,
Magnus
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.