SAPDB 7.3 - restart after the restore failed

[Former Member]

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

[Former Member]

Hi Dimitry,

the Windows errortext for errorcode 8 is 'Not enough storage is available to process this command.'

You should check whether sufficient place is available for the restore of the source instance. The target instance needs at least as many pages as the highest page number in the source system (LAST DATA PNO).

If you are an SAP customer, see note 129352, which says that for version 7.3,

"The minimum target system size is as large as the highest assigned page number in the source system (LAST DATA PNO). You can determine this value in the source system using the following call (Command Prompt or UNIX shell):

Version 7.2. or 7.3. (one line!):

dbmcli -d <database_name> -u <dbm_user>,<password> -n <database_server> -uSQL sapr3,sap sql_execute "select maxdatapageno from sysdba.serverdbstatistics"

Thanks,

Ashwath