How to extract data from a log file. It is to do this ?! My database showed error Assertion Failed. |
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). Oops, why does my answer misses the "edit" button? Ah, navigating to another page and back brings back the "edit" button.
(12 Aug '15, 15:56)
Volker Barth
Replies hidden
The user started the last backup using the -f command line it can not apply log file. He started the last backup and made entries in the system. when I
not in error, but when I displays error Assertion Failed
(17 Aug '15, 15:53)
Walmir Taques
Hm, I'm not sure what you have tried to do - why do you change the location of the log file? In case a database has to be recovered without using a log file (i.e. dbeng9 -f), then it should shutdown afterwards and will create a new (empty) log file during the next normal start automatically...
(18 Aug '15, 01:59)
Volker Barth
|