DB could not start

[Former Member]

MaxDB version 7.6.00.18

Platform: Redhat

Trying to get the DB online would give me this error:

dbmcli on MRD>db_online

ERR

-24988,ERR_SQL: Sql error

-902,I/O error

3,Database state: OFFLINE

6,Internal errorcode, Errorcode 9050 "disk_not_accessible"

20014,RestartFilesystem failed with 'I/O error'

Found in knldiag.err upon restart:

2011-07-07 11:24:30 54 ERR 11000 page0io_ Illegal file format

2011-07-07 11:24:30 54 ERR 11000 page0io_ blocksize wanted: 8192, blocksize found: 0

2011-07-07 11:24:30 24 ERR 11000 vattach dev0_vattach returned FALSE

2011-07-07 11:24:30 24 ERR 20031 IOMan IOMan_Volume.cpp:976

2011-07-07 11:24:30 24 ERR 20031 IOMan 2011-07-07 11:24:30 IOMan Error 20031

2011-07-07 11:24:30 24 ERR 20031 IOMan Attach error on Data volume 15: Could not open volume

2011-07-07 11:24:30 24 ERR 3 Admin Kernel_Administration.cpp:606

2011-07-07 11:24:30 24 ERR 3 Admin 2011-07-07 11:24:30 Admin Error 3

2011-07-07 11:24:30 24 ERR 3 Admin Database state: OFFLINE

2011-07-07 11:24:30 24 ERR 3 Admin + Kernel_Trace.cpp:223

2011-07-07 11:24:30 24 ERR 3 Admin + 2011-07-07 11:24:30 KernelCommon Info 6

2011-07-07 11:24:30 24 ERR 3 Admin - Internal errorcode, Errorcode 9050 "disk_not_accessible"

2011-07-07 11:24:30 24 ERR 3 Admin + Kernel_Administration.cpp:365

2011-07-07 11:24:30 24 ERR 3 Admin + 2011-07-07 11:24:30 Admin Error 20014

2011-07-07 11:24:30 24 ERR 3 Admin - RestartFilesystem failed with 'I/O error'

What steps do I have to take? Would recovery/restore from the last full backup solve my problem?

Thanks.

Edited by: Rhyz on Jul 8, 2011 5:40 PM

Edited by: Rhyz on Jul 8, 2011 5:47 PM

[Former Member]

Filesystem check: clean

Restore latest complete data backup and the DB is up..

[markus_doehr2]

> MaxDB version 7.6.00.18

...and you should consider upgrading your database version. The version you use is very old

Markus

[Former Member]

>>ERR 20031 IOMan Attach error on Data volume 15: Could not open volume

See above error, looks like data volume 15 not available, make sure all the disks / filesystems are accessable from OS level. The disk where data volume 15 is stored is missing.