Restoring Data from trans logs only

Posted in 2014

Topics: Backup & Restore, Transactions, Locking & Isolation

PAUL MALABAD — Wed, 23 Jul 2014 16:38:54 — source: IIUG Forums & Mailing Lists

I perfect storm of hardware/personal failures has left me with a database with no Level 0 backup, transaction logs going back for multiple years, and a busted database table that I desperately need to get back. Is there any way to extract the data from the transaction logs using archecker, or any other tool, that would allow me to extract table data. without having the level 0 archive? The database table is flushed each year, so I would need to only get the table data from July 1 to June 30 ,for which I have the transaction logs. Thanks

↪ replying to PAUL MALABAD

PAUL MALABAD — Wed, 23 Jul 2014 16:48:48 — source: IIUG Forums & Mailing Lists

Forgot the pertinent stuff. I am running INFORMIX 11.10UC1 on a Redhat 4.8 Box

↪ replying to PAUL MALABAD

DOUG LAWRY — Thu, 24 Jul 2014 12:06:54 — source: IIUG Forums & Mailing Lists

Hi Paul. You need this tool, but it's not free: www.lintel.co.uk/infotrace Regards, Doug Lawry

↪ replying to DOUG LAWRY

DOUG LAWRY — Thu, 07 Aug 2014 10:04:31 — source: IIUG Forums & Mailing Lists

David Linthwaite (who is too modest to post this!) said: Thank you for your recent link to www.lintel.co.uk/infotrace in the newsgroup. We managed to get his data back and in his words "it worked like a charm"!