cancel
Showing results for 
Search instead for 
Did you mean: 

Error while loading database

Former Member
0 Kudos

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.

  1. 1.Generated the ddl statements in the source system.
  2. 2.dropped the target database
  3. 3.dropped the devices in the target database
  4. 4.stopped the backup server and database in target
  5. 5.Deleted the data and log files
  6. Started back the database and Backup server
  7. 6.intialized the disk files in the target database
  8. created the database.
  9. Trying to load  the data

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

The issue is fixed by adding a parameter OB2HOSTNAME =< servername from where the backup is taken>

Thanks and Regards,

Vimal

Former Member
0 Kudos

sorry. I didn't mention the location

it should be under /var/opt/Omni/tmp/Sybase_SID.cfg file

Answers (2)

Answers (2)

former_member187136
Contributor
0 Kudos

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

Private_Member_19084
Active Contributor
0 Kudos

Hi guys,

we are facing the same problem.

Have already added the parameter but still the device isn't found.

Any ideas?

Kind regards

0 Kudos

Hi Christian,

I am also facing same issue.

Have u found the solution related to above error.

Regards,

Mahendr Singh

Johan_sapbasis
Active Contributor
0 Kudos

Open a new thread, add log and activity details and peers can assist

Private_Member_19084
Active Contributor
0 Kudos

We could solve the problem.

However, we didn't exactly figure out what was the issue.

We think that more problems did occur together.

So I am sorry, I can't tell you the real solution for the problem.

Kind regards

Former Member
0 Kudos

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