Skip to Content
author's profile photo Former Member
Former Member

BAD DATA PAGE in sapdb

Hi

We currently have a content server running. The details of the database

are as follows:

VERSION = 7.2.4

BUILD = DBMServer 7.2.4 Build 011-000-224-621

OS = WIN32

INSTROOT = C:\SAPDB\SDB\DB

LOGON = True

CODE = ASCII

SWAP = full

When we try to start the instance the instance refuses to go to

the ‘online’ state and remains in ‘Cold’ state. On analysis of the

kernel traces we found the following.

12-04 14:06:39 0x137 54003 dynpool TREE_LOCK region count : 2

12-04 14:06:39 0x137 54003 dynpool DYNP_B77_TREE_LOCK : 218440

12-04 14:06:39 0x137 ERR 54001 I/O page 5A4A0000010C0200...5A4A0000010C0200

12-04 14:06:39 0x137 ERR 54001 I/O BAD DATA PAGE 1

12-04 14:06:39 0x137 ERR 54001 I/O on DEVNO 5 DEV_OFFSET 500

12-04 14:06:39 0x137 ERR 53016 I/O E:\sapdb\SDB\sapdata\DISKD0005

12-04 14:06:41 0x137 ERR 54001 I/O page 5A4A0000010C0200...5A4A0000010C0200

12-04 14:06:41 0x137 ERR 54001 I/O BAD DATA PAGE 1

12-04 14:06:41 0x137 ERR 54001 I/O on DEVNO 5 DEV_OFFSET 500

12-04 14:06:41 0x137 ERR 53016 I/O E:\sapdb\SDB\sapdata\DISKD0005

12-04 14:06:43 0x137 ERR 54001 I/O page 5A4A0000010C0200...5A4A0000010C0200

12-04 14:06:43 0x137 ERR 54001 I/O BAD DATA PAGE 1

12-04 14:06:43 0x137 ERR 54001 I/O on DEVNO 5 DEV_OFFSET 500

12-04 14:06:43 0x137 ERR 53016 I/O E:\sapdb\SDB\sapdata\DISKD0005

12-04 14:06:43 0x137 19616 DEVIO Detaching devspace 'C:\sapdb\SDB\dbsys\SYS'

12-04 14:06:43 0x1FB 19614 DBSTATE I/O thread for 'C:\sapdb\SDB\dbsys\SYS' stopped

12-04 14:06:43 0x115 19618 DEVIO Single I/O detach, 'C:\sapdb\SDB\dbsys\SYS', UKT:3

12-04 14:06:44 0x137 19616 DEVIO Detaching devspace 'E:\sapdb\SDB\sapdata\DISKD0001'

12-04 14:06:44 0x21B 19614 DBSTATE I/O thread for 'E:\sapdb\SDB\sapdata\DISKD0001' stopped

12-04 14:06:44 0x137 19616 DEVIO Detaching devspace 'E:\sapdb\SDB\sapdata\DISKD0002'

12-04 14:06:44 0x21C 19614 DBSTATE I/O thread for 'E:\sapdb\SDB\sapdata\DISKD0002' stopped

12-04 14:06:44 0x137 19616 DEVIO Detaching devspace 'E:\sapdb\SDB\sapdata\DISKD0003'

12-04 14:06:44 0x21D 19614 DBSTATE I/O thread for 'E:\sapdb\SDB\sapdata\DISKD0003' stopped

12-04 14:06:44 0x137 19616 DEVIO Detaching devspace 'E:\sapdb\SDB\sapdata\DISKD0004'

12-04 14:06:44 0x213 19614 DBSTATE I/O thread for 'E:\sapdb\SDB\sapdata\DISKD0004' stopped

12-04 14:06:44 0x137 19616 DEVIO Detaching devspace 'E:\sapdb\SDB\sapdata\DISKD0005'

12-04 14:06:44 0x212 19614 DBSTATE I/O thread for 'E:\sapdb\SDB\sapdata\DISKD0005' stopped

12-04 14:06:44 0x115 19618 DEVIO Single I/O detach, 'E:\sapdb\SDB\sapdata\DISKD0005', UKT:3

12-04 14:06:44 0x137 19616 DEVIO Detaching devspace 'F:\sapdb\SDB\saplog\DISKL001'

12-04 14:06:44 0x214 19614 DBSTATE I/O thread for 'F:\sapdb\SDB\saplog\DISKL001' stopped

12-04 14:06:44 0x137 ERR 51080 SYSERROR -9026 Message not available

12-04 14:06:44 0x137 19651 CONNECT Connection released, T5

12-04 14:08:32 0x58 19633 CONNECT Connect req. (T16, Node:'', PID:323)

We also tried to do a Check on the database and got the following error.

ERR 51080 SYSERROR -9026 Message not available

Thanks.

Rohan D'Souza

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Dec 04, 2007 at 12:50 PM

    A "Bad page" is really bad - you will need to recover your database from a backup.

    Your database software is VERY VERY old and is no more supported. You should upgrade at least to a 7.3 version, if not 7.5.

    Bad pages are in 99,9 % caused by hardware failures.

    --

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.