Restore Problem on Sapdb running on linux

[Former Member]

Hie Gurus

I have a problem when trying to restore/recover sapdb complete backup.Backing up there is no problem.when trying to recover i get the error:

when using dbm gui:-<b>903 Message not available,could not open volume</b>.

when i check the log files knl.diag iget this error:

<b>err 11000 read error (fd=39):Invalid argument

err 52012 restore basis_err 3700</b>

Its sapdb 7.5

SUSE 8

webas 6.20

Help greatly appreciated

[Former Member]

from dbm.prt:

2006-12-08 13:37:11 0x00000baf 0 DBM command db_admin

2006-12-08 13:37:31 0x00000baf 0 DBM command recover_start HP_ULTRIUM DATA

2006-12-08 13:37:31 0x00000baf ERR -24992 DBM ERR_NOUTILSESSION: no utility session available

2006-12-08 13:37:53 0x00000baf 0 DBM command recover_start HP_ULTRIUM DATA

2006-12-08 13:37:57 0x00000baf ERR -24988 DBM ERR_SQL: sql error

0x00000baf ERR -24988 DBM -903,Message not available,I/O error

From Knl.diag

2006-12-08 10:29:46 1446 ERR 11000 d0_aopen Cannot open device, Permission denied

2006-12-08 10:29:46 1446 ERR 11000 d0_aopen Device name '/dev/st0'

2006-12-08 10:29:46 1489 ERR 52012 RESTORE error occured, basis_err 3700

2006-12-08 11:42:57 1446 ERR 11000 devio read error (fd = 39): Invalid argument

2006-12-08 11:43:01 1489 ERR 52012 RESTORE error occured, basis_err 3700

2006-12-08 13:33:30 --- Starting GMT 2006-12-08 11:33:30 7.4.3 Build 030-121-057-298

2006-12-08 13:37:14 --- Starting GMT 2006-12-08 11:37:14 7.4.3 Build 030-121-057-298

2006-12-08 13:37:54 3031 ERR 11000 devio read error (fd = 39): Invalid argument

2006-12-08 13:37:57 3074 ERR 52012 RESTORE error occured, basis_err 3700

i used DBMCLI or the Database Manager GUI on separate occassions.

The permission problem i sorted it out.

[roland_mallmann]

Hi again,

if you still have them, please post the knldiag entries, not the knldiag.err.

(knldiag is written cyclically, so it might be the case that it's already overwritten.)

Regards,

Roland

[Former Member]

Hello,

are all paths and infos that are set during recovery fitting to the paths that are available from the backup?

I had problems some time ago with that - the paths of the db that was in the backup were not fitting to the paths in the new db (logs, data or sdb-programs).

kind regards,

Carl

[Former Member]

Thanks Carl

Which and where do i locate the paths so that i can check these files.

[Former Member]

Hi,

you have to check the paths of the SAP DB into that you want to restore the backup.

While doing the restore, the "installation" tool asks you whether you want to take over the parameters from the backup. And if these do not match to the current installation, you have to manually change them within the inst tool - or you'll get errors.

kind regards,

Carl

[Former Member]

Hie

I managed to fix the problem

[roland_mallmann]

Hi,

can you show me the entries from knldiag? I also need the surrounding output, i.e. 10 lines before and after the error.

Additionally, please tell me how you issued the recovery (from dbm.prt). Did you use DBMCLI or the Database Manager GUI or DB13?

Regards,

Roland