I would say no. The journal file stores pages referenced by page no
and when replayed will write those pages back to the main DB at the
appropriate physical offset. Although the content of your DB's at a
logical level may be the same, it is unlikely that they will be exact
copies at a binary level so replaying a journal to the wrong DB would
almost certaibnly cause corruption.
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence


On 12 February 2015 at 21:09, Mayank Kumar (mayankum)
<mayan...@cisco.com> wrote:
> Hi All
>
> We have two systems which are running in active/standby configuration. The 
> active machine, is actively writing sqlite transactions to a file abcd.db. 
> The standby is syncing the abcd.db  file from the active  machine on a 
> communication channel and writing the delta records to the  abcd.db on the 
> standby machine.
>
> Now my question is , lets say the active machine crashes in the middle of the 
> transaction and we have a hot journal created on the active machine.   Does 
> it make sense to copy the hot journal to the standby machine, so that the 
> sqlite application on the standby will notice this hot journal and use it to 
> recover any lost transactions  or the hot journal can only be used on the 
> same db on which it was created.
>
> Remember , both the db on active and standby are same(maintained in sync and 
> have same names), so can a hot journal from one db on active machine be used 
> on standby machine to recover lost transactions.
>
> We are assuming that somehow the sqlite application on active is not able to 
> use the journal file to recover from it, so as a fallback would copying it to 
> standby make sense at all so that it can be used by the backup db ?
>
> Hope by question doesn't sound too absurd:)
> -Mayank
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to