Hi Florian It looks like you have to Reinstall your instance and recover your system from Data and log backups. That�s what I have done in the past.
Is this a SAP R/3 system ? Good luck Pierre -----Urspr�ngliche Nachricht----- Von: Florian Schmitz [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juni 2004 13:34 An: [EMAIL PROTECTED] Betreff: *****SPAM***** Database crash with 8524 ERR 55011 FBM invalid marker combination for block Wichtigkeit: Hoch Hi Folks, our 7.3 SAPDB-Instance crashed today with the Error 2004-06-23 11:26:20 8524 ERR 55011 FBM invalid marker combination for block (1/50519) 2004-06-23 11:26:20 8524 ERR 55011 FBM act marker is 2, new marker is 0 . . Trace . 2004-06-23 11:26:21 8524 ERR 11196 DBCRASH vabort:Emergency Shutdown, Task: 7 Beeing in a meeting i just restarted the instance. After a while, it crashed again and became real bumby with thousands of errors like : 2004-06-23 11:29:59 11064 ERR 11875 DIAGHIST eo86_MakeCrashHist 'RTEDiag_CreateDirectory' OS error: [/usr/sapdb/indep_data/wrk/DBA1/DIAGHISTORY, [2] ] 2004-06-23 11:30:10 11079 ERR 54001 I/O page FD3A0900010D0201...FD3A0900010D0201 2004-06-23 11:30:10 11079 ERR 54001 I/O BAD DATA PAGE 214062 2004-06-23 11:30:10 11079 ERR 54001 I/O on DEVNO 5 DEV_OFFSET 45110 2004-06-23 11:30:10 11079 ERR 53016 I/O DAT_0005 2004-06-23 11:30:12 11079 ERR 54001 I/O page FD3A0900010D0201...FD3A0900010D0201 2004-06-23 11:30:12 11079 ERR 54001 I/O BAD DATA PAGE 214062 and 2004-06-23 11:33:50 11081 ERR 53250 B*TREE BAD INDEX 174877 (ROOT) and most obviously ('cause the Applications showed this one) 2004-06-23 11:34:02 11081 ERR 51080 SYSERROR -9012 BD Inv not found or 2004-06-23 12:15:39 11079 ERR 53333 B*TREE VERIFY Invalid structure: 25410 2004-06-23 12:15:39 11079 ERR 53000 B*TREE 0A0D00000000000002D8000000000000 2004-06-23 12:15:39 11079 ERR 53000 B*TREE ROOT 25410 and then another shutdown 2004-06-23 12:30:30 11081 ERR 51080 SYSERROR -9028 BD Bad file 2004-06-23 12:30:30 11081 ERR 52000 LOG Pos: Log: 1380241.3645 2004-06-23 12:30:30 11081 ERR 52000 LOG BasisError: 320 2004-06-23 12:30:30 11081 ERR 52000 LOG LogType=35,0 2004-06-23 12:30:30 11081 ERR 52050 SHUTDOWN partial_rollback/bad_file 2004-06-23 12:30:31 11081 ERR 52050 SHUTDOWN *** EMERGENCY ***: 320 and so on. The instance is in admin-mode now and has a DBMGui-Verify running on it. I wonder what this all means and what lead to it? Nothing unusual was done to the DB, except a optimizier statistics with 10% samplerate. but this was done many times before ... ? What to do know? I'm almost sure that data was lost, so i gotta restore yesternights backup. I just wonder : Why? And What? The heck... Can anyone give me a clue? Thank you. :-) Flo -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
