Pulling transactions from logical logs
Randy Kennedy, on IDS 11.10.FC3 with ontape, asked how to recover deleted records from logical logs. Art Kagel said archecker could retrieve them if they were in the previous level 0 archive, otherwise infotrace could parse the logical logs; Alexandre Marini also suggested infotrace. Madison Pruet said CDC could dump the deleted rows if the logs were still online. No outcome reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.