Skip to Content
0
Former Member
Jul 01, 2007 at 01:11 PM

SAPDB 7.3 - restart after the restore failed

14 Views

Hi,

After restoring I can't get over the restart phase. I get error -8.

I've updated sapdb 7.3 top the latest patch 56.

dbm.prt:

======

2007-07-01 09:05:38 0x00000414 0 DBM command util_execute INIT CONFIG

2007-07-01 09:05:39 0x00000414 0 DBM command backup_restore "BCK" DATA

2007-07-01 09:05:40 0x000006f0 0 DBM command backup_restore_state

2007-07-01 09:05:40 0x000006f0 ERR -24988 DBM ERR_SQL: sql error

0x000006f0 ERR -24988 DBM -8000,Message not available

2007-07-01 09:05:44 0x00000414 0 DBM command db_warm -f

2007-07-01 09:05:44 0x00000414 ERR -24988 DBM ERR_SQL: sql error

0x00000414 ERR -24988 DBM -8,Message not available

2007-07-01 09:05:58 0x00001344 0 DBM command param_startsession

2007-07-01 09:05:58 0x00001344 0 DBM command param_abortsession

knldiag:

======

2007-07-01 09:05:40 0x1770 52012 RESTORE ready

2007-07-01 09:05:40 0x153C 19633 CONNECT Connect req. (T70, Node:'', PID:1776)

2007-07-01 09:05:40 0x153C 19651 CONNECT Connection released, T70

2007-07-01 09:05:40 0x1770 19651 CONNECT Connection released, T5

2007-07-01 09:05:40 0x1770 19633 CONNECT Connect req. (T5, Node:'', PID:1044)

2007-07-01 09:05:40 0x1770 19615 DEVIO Attaching devspace 'SYS_001'

2007-07-01 09:05:40 0x114C 19613 DBSTATE I/O thread for 'SYS_001' started

2007-07-01 09:05:40 0x1770 19617 DEVIO Single I/O attach, 'SYS_001', UKT:3

2007-07-01 09:05:40 0x1770 19616 DEVIO Detaching devspace 'SYS_001'

2007-07-01 09:05:40 0x114C 19614 DBSTATE I/O thread for 'SYS_001' stopped

2007-07-01 09:05:40 0x100C 19618 DEVIO Single I/O detach, 'SYS_001', UKT:3

2007-07-01 09:05:40 0x1770 19615 DEVIO Attaching devspace 'C:\sapdb\data\PDM4\log\DISKL001'

2007-07-01 09:05:40 0x15E8 19613 DBSTATE I/O thread for 'C:\sapdb\data\PDM4\log\DISKL001' started

2007-07-01 09:05:40 0x1770 19617 DEVIO Single I/O attach, 'C:\sapdb\data\PDM4\log\DISKL001', UKT:3

2007-07-01 09:05:40 0x1770 19616 DEVIO Detaching devspace 'C:\sapdb\data\PDM4\log\DISKL001'

2007-07-01 09:05:40 0x15E8 19614 DBSTATE I/O thread for 'C:\sapdb\data\PDM4\log\DISKL001' stopped

2007-07-01 09:05:40 0x100C 19618 DEVIO Single I/O detach, 'C:\sapdb\data\PDM4\log\DISKL001', UKT:3

2007-07-01 09:05:40 0x1770 19651 CONNECT Connection released, T5

2007-07-01 09:05:44 0x1770 19633 CONNECT Connect req. (T5, Node:'', PID:1044)

2007-07-01 09:05:44 0x1770 19615 DEVIO Attaching devspace 'SYS_001'

2007-07-01 09:05:44 0x1380 19613 DBSTATE I/O thread for 'SYS_001' started

2007-07-01 09:05:44 0x1770 19617 DEVIO Single I/O attach, 'SYS_001', UKT:3

2007-07-01 09:05:44 0x1770 19615 DEVIO Attaching devspace 'C:\sapdb\data\PDM4\data\DISKD0001'

2007-07-01 09:05:44 0x1458 19613 DBSTATE I/O thread for 'C:\sapdb\data\PDM4\data\DISKD0001' started

2007-07-01 09:05:44 0x1770 19615 DEVIO Attaching devspace 'C:\sapdb\data\PDM4\log\DISKL001'

2007-07-01 09:05:44 0x171C 19613 DBSTATE I/O thread for 'C:\sapdb\data\PDM4\log\DISKL001' started

2007-07-01 09:05:44 0x1770 19617 DEVIO Single I/O attach, 'C:\sapdb\data\PDM4\data\DISKD0001', UKT:3

2007-07-01 09:05:44 0x1770 19617 DEVIO Single I/O attach, 'C:\sapdb\data\PDM4\log\DISKL001', UKT:3

2007-07-01 09:05:44 0x1544 19617 DEVIO Single I/O attach, 'C:\sapdb\data\PDM4\log\DISKL001', UKT:2

2007-07-01 09:05:44 0x1770 19616 DEVIO Detaching devspace 'SYS_001'

2007-07-01 09:05:44 0x1380 19614 DBSTATE I/O thread for 'SYS_001' stopped

2007-07-01 09:05:44 0x100C 19618 DEVIO Single I/O detach, 'SYS_001', UKT:3

2007-07-01 09:05:44 0x1770 19616 DEVIO Detaching devspace 'C:\sapdb\data\PDM4\data\DISKD0001'

2007-07-01 09:05:44 0x1458 19614 DBSTATE I/O thread for 'C:\sapdb\data\PDM4\data\DISKD0001' stopped

2007-07-01 09:05:44 0x100C 19618 DEVIO Single I/O detach, 'C:\sapdb\data\PDM4\data\DISKD0001', UKT:3

2007-07-01 09:05:44 0x1770 19616 DEVIO Detaching devspace 'C:\sapdb\data\PDM4\log\DISKL001'

2007-07-01 09:05:44 0x171C 19614 DBSTATE I/O thread for 'C:\sapdb\data\PDM4\log\DISKL001' stopped

2007-07-01 09:05:44 0x100C 19618 DEVIO Single I/O detach, 'C:\sapdb\data\PDM4\log\DISKL001', UKT:2

2007-07-01 09:05:44 0x100C 19618 DEVIO Single I/O detach, 'C:\sapdb\data\PDM4\log\DISKL001', UKT:3

2007-07-01 09:05:44 0x1770 19651 CONNECT Connection released, T5

-


current write position -


dbm.utl:

======

2007-07-01 09:05:39 46875243000E 0000 RDB RESTORE DATA QUICK FROM 'z:\sapdb_backup\DAT2' FILE BLOCKSIZE 8 MEDIANAME 'BCK'

2007-07-01 09:05:40 46875243000E 0001 RET RETURNCODE 0

2007-07-01 09:05:40 46875243000E 0002 TAP DATE.............. 2007-07-01

2007-07-01 09:05:40 46875243000E 0003 TAP TIME.............. 09:05:39

2007-07-01 09:05:40 46875243000E 0004 TAP SERVERDB.......... PDM

2007-07-01 09:05:40 46875243000E 0005 TAP SERVERNODE........ oss.mamhi

2007-07-01 09:05:40 46875243000E 0006 TAP KERNEL VERSION.... Kernel 7.3.0 Build 040-000-091-773

2007-07-01 09:05:40 46875243000E 0007 TAP PAGES TRANSFERRED. 1072

2007-07-01 09:05:40 46875243000E 0008 TAP PAGES LEFT........ 0

2007-07-01 09:05:40 46875243000E 0009 TAP NO OF VOLUMES..... 1

2007-07-01 09:05:40 46875243000E 000A TAP MEDIA NAME........ BCK

2007-07-01 09:05:40 46875243000E 000B TAP TAPE NAME......... z:\sapdb_backup\DAT2

2007-07-01 09:05:40 46875243000E 000C TAP TAPE ERRORTEXT.... UNDEF

2007-07-01 09:05:40 46875243000E 000D TAP TAPE LABEL........ DAT_00003

2007-07-01 09:05:40 46875243000E 000E TAP IS CONSISTENT..... TRUE

2007-07-01 09:05:40 46875243000E 000F TAP FIRST LPNO........ 1992

2007-07-01 09:05:40 46875243000E 0010 TAP LAST LPNO......... UNDEF

2007-07-01 09:05:40 46875243000E 0011 TAP DBSTAMP1 DATE..... 2007-06-25

2007-07-01 09:05:40 46875243000E 0012 TAP DBSTAMP1 TIME..... 16:05:40

2007-07-01 09:05:40 46875243000E 0013 TAP DBSTAMP2 DATE..... UNDEF

2007-07-01 09:05:40 46875243000E 0014 TAP DBSTAMP2 TIME..... UNDEF

2007-07-01 09:05:40 46875243000E 0015 TAP BD PAGE COUNT..... 1053

2007-07-01 09:05:40 46875243000E 0016 TAP TAPEDEVICES USED.. 1

2007-07-01 09:05:40 46875243000E 0017 TAP DB_IDENT.......... oss:PDM_20060216_151500

2007-07-01 09:05:40 46875243000E 0018 TAP MAX USED DATA PNO. 1072

2007-07-01 09:05:44 46875248000F 0000 RST RESTART

2007-07-01 09:05:44 46875248000F 0001 RET RETURNCODE -8

-


current write position -


Please advice,

Dimitry Haritonov

Message was edited by:

Dimitry Haritonov