Restoring Data from trans logs only
Paul Malabad, on Informix 11.10UC1 with RedHat 4.8, had no level 0 backup but years of transaction logs and asked whether archecker or another tool could recover a table's data from the logs. Doug Lawry pointed to a non-free commercial tool, InfoTrace, and later relayed a user's report that it recovered his data 'like a charm'.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
Forgot the pertinent stuff. I am running INFORMIX 11.10UC1 on a Redhat 4.8 Box
Hi Paul. You need this tool, but it's not free: www.lintel.co.uk/infotrace Regards, Doug Lawry
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"!