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