SQL error - Corrupted datapage

[Former Member]

Hello all!

I have a problem with a MaxDB 7.6.00.35 database running on 32bit Windows Server 2003 SP2.

The datebase can't go "online", but can only go to the "admin" state. Is there anything I can do to fix the corrupted datapages so that I don't need to restore my backup (it's old..)

This is the error messages I get:

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

ERR

-24988,ERR_SQL: SQL error

-9022,System error: BD Corrupted datapage

3,Database state: OFFLINE

6,Internal errorcode, Errorcode 9163 "corrupted_datapage"

20026,PAM::GetPage: Data page is not assigned.

6,bd13GetNode, Errorcode 9163 "corrupted_datapage"

20066,HistDir: registered files 50, max used are 50

2009-01-28 12:41:10 --- Starting GMT 2009-01-28 11:41:10 7.6.00 Build 035-123-139-084

2009-01-28 12:41:48 0x1C8 ERR 20032 IOMan Wrong data page on data volume 9 blockno 15339

2009-01-28 12:41:48 0x1C8 ERR 20033 IOMan + Wrong data page - Requested pageno 74441 (perm) read pageno 7778263

2009-01-28 12:41:50 0x1C8 ERR 20032 IOMan Wrong data page on data volume 9 blockno 15339

2009-01-28 12:41:50 0x1C8 ERR 20033 IOMan + Wrong data page - Requested pageno 74441 (perm) read pageno 7778263

2009-01-28 12:41:52 0x1C8 ERR 20032 IOMan Wrong data page on data volume 9 blockno 15339

2009-01-28 12:41:52 0x1C8 ERR 20033 IOMan + Wrong data page - Requested pageno 74441 (perm) read pageno 7778263

2009-01-28 12:41:54 0x1C8 ERR 20010 Data Corrupted data page 74441 belongs to root 74441 which is of filetype 'History'

2009-01-28 12:41:54 0x1C8 ERR 51080 SYSERROR -9022 BD Corrupted datapage

2009-01-28 12:41:54 0x1C8 ERR 3 Admin Database state: OFFLINE

2009-01-28 12:41:54 0x1C8 ERR 6 KernelCo + Internal errorcode, Errorcode 9163 "corrupted_datapage"

2009-01-28 12:41:54 0x1C8 ERR 20026 Data + PAM::GetPage: Data page is not assigned.

2009-01-28 12:41:54 0x1C8 ERR 6 KernelCo + bd13GetNode, Errorcode 9163 "corrupted_datapage"

2009-01-28 12:41:54 0x1C8 ERR 20066 Log + HistDir: registered files 50, max used are 50

2009-01-28 12:41:54 0x1C8 ERR 20017 Admin + RestartFilesystem failed with 'System error: BD Corrupted datapage'

2009-01-28 12:41:54 0xB0 ERR 7 Messages Begin of dump of registered messages

2009-01-28 12:41:54 0xB0 ERR 10 Messages abort dump of registered messages

2009-01-28 12:41:54 0xB0 ERR 8 Messages End of the message list registry dump

2009-01-28 12:41:58 ___ Stopping GMT 2009-01-28 11:41:58 7.6.00 Build 035-123-139-084

--

Best regards,

Peter Bak

[markus_doehr2 · Accepted solution]

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

Your database has corrupt pages --> destroyed! I hope you have a backup.

What happened prior to that problem?

Markus

[Former Member · Accepted solution]

Hello!

Well, I restored my old backup, but the system haven't been used for a long time, so there was only a few things missing in the backup.

I belive that the error occured after the SAN where the database is located shut down due to a power failuere, and didn't mange to write it's cache to the disks.

Thanks for the answer