Skip to Content
0
Former Member
Jun 01, 2011 at 02:44 PM

MaxDB killed by Power Outage - PART II !

281 Views

Hi friends,

My server was halted as power to the server was cut (no UPS in place).

This has happened before ( MaxDB killed by Power Outage ! ), but this time we got a new error:

20028,Initialization of log for 'restart' failed with 'InconsistentLogInfoPage'

It clear that MaxDB dont like to get the legs swiped away, but then again ... who does 😊

I hope some of you have a good idea. A restore from backup is not a posibility. The latest backup is way to old

How do I tell MaxDB, to simply startup and ignore the inconsistent logfile ?

cheers

Jan

dbmcli -d MD1 -u superdba,xxyyzz show state

OK

SERVERDB: MD1

The SERVERDB state is STOPPED

  • Post Mortem Analysis for ServerDB MD1 using kernel ***

Console command finished (2011-06-01 18:21:48).

dbmcli -d MD1 -u superdba,xxyyzz db_stop

OK

dbmcli -d MD1 -u superdba,xxyyzz db_admin

OK

dbmcli -d MD1 -u superdba,xxyyzz db_online

ERR

-24988,ERR_SQL: SQL error

-9407,System error: unexpected error

3,Database state: OFFLINE

Internal errorcode, Error code 6433 "system_error"

40,The last known LogIOSequence 10346130 on partition 1, position 2154155 could not be found

33,The log-iosequencenumber 10346130 could not be found at the expected position 2154155 on partition 1

20028,Initialization of log for 'restart' failed with 'InconsistentLogInfoPage'

dbmcli -d MD1 -u superdba,xxyyzz db_enum

OK

MD1 /sapdb/MD1/db 7.7.06.07 fast offline

MD1 /sapdb/MD1/db 7.7.06.07 quick offline

MD1 /sapdb/MD1/db 7.7.06.07 slow offline

MD1 /sapdb/MD1/db 7.7.06.07 test offline

dbmcli -d MD1 -u superdba,xxyyzz inst_enum

OK

7.7.06.07 /sapdb/MD1/db

sdbregview -l

DB Analyzer /sapdb/programs 7.7.06.07 64 bit valid

Server Utilities /sapdb/programs 7.7.06.07 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.60 valid

PCR 7301 /sapdb/programs 7.3.01.22 valid

PCR 7500 /sapdb/programs 7.5.00.50 64 bit valid

SAP Utilities /sapdb/programs 7.7.06.07 64 bit valid

Base /sapdb/programs 7.7.06.07 64 bit valid

Redist Python /sapdb/programs 7.7.06.07 64 bit valid

JDBC /sapdb/programs 7.6.06.00 valid

Messages /sapdb/programs MSG 0.7732 valid

ODBC /sapdb/programs 7.7.06.07 64 bit valid

Database Kernel /sapdb/MD1/db 7.7.06.07 64 bit valid

SQLDBC 77 /sapdb/programs 7.7.06.07 64 bit valid

Loader /sapdb/programs 7.7.06.07 64 bit valid

SQLDBC /sapdb/programs 7.7.06.07 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.05.11 64 bit valid

Fastload API /sapdb/programs 7.7.06.07 64 bit valid

xinstinfo MD1

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/MD1/db

Kernelversion : KERNEL 7.7.06 BUILD 007-123-197-046

Rundirectory : /sapdb/data/wrk/MD1