9022,System error: BD Corrupted datapage

[Former Member]

Hi all

I have a problem with a SAP system running MaxDB. The database will only go into "admin" mode, but not online. When I try to switch the database to "online" I get the following error-message:

-24988 SQL error [db_online -f] -9022,System error: BD Corrupted datapage

In the knldiag.err file it says the following:

--- Starting GMT 2010-03-01 09:49:50 7.6.00 Build 035-123-139-084

0xEA8 ERR 20032 IOMan Wrong data page on data volume 8 blockno 186182

0xEA8 ERR 20033 IOMan + Wrong data page - Requested pageno 223321 (perm) read pageno 8574665

0xEA8 ERR 20032 IOMan Wrong data page on data volume 8 blockno 186182

0xEA8 ERR 20033 IOMan + Wrong data page - Requested pageno 223321 (perm) read pageno 8574665

0xEA8 ERR 20032 IOMan Wrong data page on data volume 8 blockno 186182

0xEA8 ERR 20033 IOMan + Wrong data page - Requested pageno 223321 (perm) read pageno 8574665

0xEA8 ERR 20010 Data Corrupted data page 223321 belongs to root 223321 which is of filetype 'History'

0xEA8 ERR 51080 SYSERROR -9022 BD Corrupted datapage

0xEA8 ERR 3 Admin Database state: OFFLINE

0xEA8 ERR 6 KernelCo + Internal errorcode, Errorcode 9163 "corrupted_datapage"

0xEA8 ERR 20026 Data + PAM::GetPage: Data page is not assigned.

0xEA8 ERR 6 KernelCo + bd13GetNode, Errorcode 9163 "corrupted_datapage"

0xEA8 ERR 20066 Log + HistDir: registered files 50, max used are 50

0xEA8 ERR 20017 Admin + RestartFilesystem failed with 'System error: BD Corrupted datapage'

0xE24 ERR 7 Messages Begin of dump of registered messages

0xE24 ERR 10 Messages abort dump of registered messages

0xE24 ERR 8 Messages End of the message list registry dump

___ Stopping GMT 2010-03-01 09:51:17 7.6.00 Build 035-123-139-084

How can i fix this corrupted datapage (or delete if it isn't anything important?) so that I can restart the database and get the SAP system up and running again..?

Any help or ideas are greatly appreciated

Edited by: Peter Bak Petersen on Mar 1, 2010 11:48 AM

[lbreddemann]

> I have a problem with a SAP system running MaxDB. The database will only go into "admin" mode, but not online. When I try to switch the database to "online" I get the following error-message:

> -24988 SQL error [db_online -f] -9022,System error: BD Corrupted datapage

As you are a SAP customer you can and should open a support message for such cases!

>

> In the knldiag.err file it says the following:

>

> --- Starting GMT 2010-03-01 09:49:50 7.6.00 Build 035-123-139-084

> 0xEA8 ERR 20032 IOMan Wrong data page on data volume 8 blockno 186182

> 0xEA8 ERR 20033 IOMan + Wrong data page - Requested pageno 223321 (perm) read pageno 8574665

> 0xEA8 ERR 20032 IOMan Wrong data page on data volume 8 blockno 186182

> How can i fix this corrupted datapage (or delete if it isn't anything important?) so that I can restart the database and get the SAP system up and running again..?

>

There is no such thing as "repair a corrupt page".

No database software can do that.

The correct answer to this situation is to restore and recover the most recent backup.

You may nevertheless check before, what database object is affected (table or index).

Depending on what kind of object is affected, you may rebuild the index.

> Any help or ideas are greatly appreciated

regards,

Lars