How to extract data from a log file.
It is to do this ?! My database showed error Assertion Failed.
asked 12 Aug '15, 15:02
You can use the builtin DBTRAN utility to translate the log (possibly using -j to start at a particular checkpoint) into a script with the according SQL statements.
I'd like to add that you should check whether your database file has become corrupt - not every assertion means a corrupt database. And if it seems corrupt, you usually should be able to apply the current log to your last backup... - that would prevent the need to "manually" re-apply operations... (or only those that had not been committed but were rollbacked when the assertion happened by making use of DBTRAN -a).