Skip to Content
avatar image
Former Member

Replay logfiles on corrupt database

I've got a machine here that has not been maintained very well. Someone with little knowledge of MaxDB has only kept Windows backups and no database backups. Also, there has been no LOG backups, everytime the log was full, someone just added another one :). Now one of the DATAvolumes is corrupt (it shows 0 kb) and the database won't come up. Everyone here is convinced that it won't come up ever again. Also, on top of all, the Windows backups aren't available anymore either. People feel sorry for it and just move on 😊

So now I've got some spare time and I want to take a closer look at it. I've got a corrupt database, and I've got a lot of LOG volumes (not backups). I'm not a MaxDB guru either, so I've got the following questions:

Isn't it true that if you do not backup the database or the logfiles at all, all the database transactions committed after the installation still reside in the logfile(s)?

With this in mind, couldn't it be possible to install the system just as it was right after the installation, and after that replay the existing logfiles? I've created a copy of the system where I can fool around. I've found lots of ways to recover a database with logbackups, but not with the logfiles itself.

Isn't there anything I can do at all with the existing logfiles, with all the precious data in it? It has been a portal and there are (or were 😊 ) a lot of documents in it.

Who can help me out?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 26, 2008 at 03:40 PM

    Hi Martin,

    can you tell us:

    - which MaxDB version is being used?

    - if the data volume that has a size of 0 KB is a volume that was added lately? You might be lucky in that case, as we then might have a possibility to remove that data volume from the configuration files and retry to start the DB. Before you try that, we'd really need more information regarding which exact data volume is affected and how many data volumes there are.

    On a side note: you can't really solve a log full situation by adding a log volume, only by saving the log would you get out of it.

    I do hope that the responsible person learned from this and won't do it again!

    Regards,

    Roland

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Lars Breddemann

      Now that's basically the info I was looking for. I'll stop from here, I'm not a hardcore MaxDB developer :).

      Lars, thanks for the info, you're a big contribution to this forum. Your name shows up many times in a very positive way.

  • avatar image
    Former Member
    Nov 27, 2008 at 08:09 AM

    Problem is not solved, but it's proven it cannot be solved. You cannot build a new database and replay old logfiles.

    Add comment
    10|10000 characters needed characters exceeded