SAP SQL Anywhere

Question

How to extract data from a log file.

It is to do this ?! My database showed error Assertion Failed.

Accepted Answer

1

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).

permanent link

answered 12 Aug '15, 15:50

Volker Barth
39.9k●360●547●816
accept rate: 34%

edited 12 Aug '15, 15:59

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

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C: \ Users \ walmir> dblog -tc: \ db \ sis.log c: \ db \ sis.db

SQL Anywhere Transaction Log Utility Version 12.0.1.3152
"c: \ db \ sis.db" was using log file "sis.log"
"c: \ db \ sis.db" is using the mirror log file
"c: \ db \ sis.db" is now using log file "c: \ db \ sis.log"
Transaction log starting offset is 0945518960
Transaction log current relative offset is 0000286142

C: \ Users \ walmir>

not in error,

but when I

displays error Assertion Failed

alt text

(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

flat view

SAP SQL Anywhere

Log File - Assertion Failed

Follow this question

Related questions