Pulling transactions from logical logs

IDS: 11.10.FC3 OS: RHEL 5.7 Don't know if this is possible, but deleted some records prior to the level 0 backup and was hoping I could retrieve the insert statements from the logical logs. We use ontape and have ontape -c running whenever the level 0 backup isn't being done. It is a single work day I am looking for. TIA, Randy

If the records were in the previous level 0 archive you can use archecker to retrieve that version of the records. If not, take a look at infotrace (see www.lintel.co.uk/infotrace) which can parse the logical logs and show you the exact transactions. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Sep 14, 2011 at 11:54 AM, Kennedy, Randy <RKennedy@scottsdaleaz.gov>wrote: > IDS: 11.10.FC3 > OS: RHEL 5.7 > > Don't know if this is possible, but deleted some records prior to the level > 0 > backup and was hoping I could retrieve the insert statements from the > logical > logs. We use ontape and have ontape -c running whenever the level 0 backup > isn't being done. It is a single work day I am looking for. > > TIA, > Randy > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e9006abbf9404ace9294e

As soon as you´re in 11.10, you can´t have point in time restore. (11.50 upgrade should be your best choice!) But I think Infotrace (see www.lintel.co.uk/infotrace) should do what you need, check it out.... Regards. Em 14/09/2011 11:54, Kennedy, Randy escreveu: > IDS: 11.10.FC3 > OS: RHEL 5.7 > > Don't know if this is possible, but deleted some records prior to the level 0 > backup and was hoping I could retrieve the insert statements from the logical > logs. We use ontape and have ontape -c running whenever the level 0 backup > isn't being done. It is a single work day I am looking for. > > TIA, > Randy > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

If you still have the log files involved online, then it shouldn't be too hard to use CDC to dump the deleted rows in a column delimited format. From: "Kennedy, Randy" <RKennedy@scottsdaleaz.gov> To: ids@iiug.org Date: 09/14/2011 10:58 AM Subject: Pulling transactions from logical logs [24913] Sent by: ids-bounces@iiug.org IDS: 11.10.FC3 OS: RHEL 5.7 Don't know if this is possible, but deleted some records prior to the level 0 backup and was hoping I could retrieve the insert statements from the logical logs. We use ontape and have ontape -c running whenever the level 0 backup isn't being done. It is a single work day I am looking for. TIA, Randy ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.