IDS Forum

RE: looking for logical log data reconstructio....

Posted By: Jim Cramer
Date: Wednesday, 5 December 2007, at 1:35 p.m.

In Response To: RE: looking for logical log data reconstructio.... (John Miller iii)

Yes, it helps. Thanks John.

Regards,

Jim

> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> John Miller iii
> Sent: Wednesday, December 05, 2007 12:27 PM
> To: ids@iiug.org
> Subject: RE: looking for logical log data reconstructio.... [10612]
>
> Jim:
>
> In the fully supported and what is tested, yes support is correct. Tab=
> le
> Level Restore requires
> all logical logs from a level 0 archive until the desired point in
> time=
> ..
>
> Now when you get down to the low level workings of archecker. I just
> converts each logical
> log record to an SQL delete or insert (updates are done as both a
> delet=
> e
> and insert) statement
> and place it in a table to be replayed. This is called the stager, wh=
> ich
> can be run
> independent of any other part of archecker. The last phase, run as a
> separate archecker
> process, is called the "applier". It reads the previous table extract=
> ing
> each SQL statement
> applying it.
>
> Hope this helps you understand what is going on.
> John
>
> =
>
> "Jim Cramer" =
>
> <jim-cramer@uiowa =
>
> ..edu> =
> To
>
> Sent by: ids@iiug.org =
>
> ids-bounces@iiug. =
> cc
>
> org =
>
> Subj=
> ect
>
> RE: looking for logical log data=
>
> 12/05/2007 09:57 reconstructio.... [10608] =
>
> AM =
>
> =
>
> =
>
> Please respond to =
>
> ids@iiug.org =
>
> =
>
> =
>
> Hi John,
>
> Thanks for your reply. See my previous responses to the
> same suggestion.
>
> To be more specific and to confess my guilt, here is exactly
> why I cannot use archecker's point in time resore, and why
> archecker will do only the physical restore and nothing from
> the logical restore phase.
>
> After installing IDS 10 on an instance, I did a dbexport from the
> 7.31 instance that was being replaced by 10.x. I then set LTAPEDEV
> to /dev/null in onconfig for the new server so that the dbimport
> would not generate a bunch of transactions. Looking at the start
> of the onbar bar_act.log file I see:
> "(-43183) WARNING: Logical Logs will not be backed up / salvaged
> becaus=
> e
> LTAPEDEV value is /dev/null ."
> logged when I did my level-0 after the dbimport into IDS 10.
>
> Apparently I forgot to change this config back to something other than
> /dev/null before the level-0 and so the logical log backup that went
> with the "onbar -b -w -L 0" went into the bit bucket. At some point
> before the next backup, I fixed this and all of the level-1 and level-
> 2=
>
> backups since have been backing up the logical logs.
>
> But, without that initial log backup, I am told by Informix tech
> suppor=
> t
> that archecker cannot proceed with the logical restore. It seems that
> I am hosed...
>
> If you feel that this is not true and that there is actually a way to
> d=
> o
> it,
> please let me know as soon as you can.
>
> Thanks again,
> Jim
>
> Regards,
>
> Jim
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of=
>
> > John Miller iii
> > Sent: Wednesday, December 05, 2007 11:38 AM
> > To: ids@iiug.org
> > Subject: RE: looking for logical log data reconstructio.... [10607]
> >
> > Jim:
> >
> > Why can you not process the logical logs with archecker??
> >
> > Archecker Point-In-Time Table Level Restore
> > will restore the data from both the physical restore
> > followed by restoring the logical logs.
> >
> > You should be able to restore the data up to the exact
> > transaction that started the update
> >
> > John
> >
> > =3D
> >
> > "Jim Cramer" =3D
> >
> > <jim-cramer@uiowa =3D
> >
> > ..edu> =3D
> > To
> >
> > Sent by: ids@iiug.org =3D
> >
> > ids-bounces@iiug. =3D
> > cc
> >
> > org =3D
> >
> > Subj=3D
> > ect
> >
> > RE: looking for logical log data=3D
> >
> > 12/05/2007 09:01 reconstructio.... [10604] =3D
> >
> > AM =3D
> >
> > =3D
> >
> > =3D
> >
> > Please respond to =3D
> >
> > ids@iiug.org =3D
> >
> > =3D
> >
> > =3D
> >
> > Art,
> >
> > As per my previous reply, just now, I would
> > have done that but my logical logs cannot
> > be processed and restored from by archecker
> > or onbar restore.
> >
> > Therefore I was wondering if anyone had a tool
> > for reconstruction data prior to UPDATEs from
> > the logical log.
> >
> > Regards,
> >
> > Jim
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> > Of=3D
> >
> > > Art S. Kagel (Oninit LLC)
> > > Sent: Wednesday, December 05, 2007 10:41 AM
> > > To: ids@iiug.org
> > > Subject: Re: looking for logical log data reconstructio....
> [10600]=
>
> > >
> > > Jim Cramer wrote:
> > > > Hi,
> > > >
> > > >
> > > Jim,
> > >
> > > If the original data is on the latest archive you can use
> archecker=
>
> > t=3D
> > o
> > > extract the data from the archive and restore it to any table,
> > either=3D
> >
> > > the original or a table created just for the recovery. Much easier
> > th=3D
> > an
> > > trying to parse the logical log records.
> > >
> > > You cannot recover completely this way if anyone else modified the
> > sa=3D
> > me
> > > records after the archive however.
> > >
> > > Art S. Kagel
> > >
> > > > Does anyone have a utility that they are willing to donate
> > > > that can scan an IDS (10.0.FC6) logical log and reconstruct
> > > > the original data for rows that were updated?
> > > >
> > > > A user used an UPDATE stmt to update 4 char and 2 SmallInt
> > > > columns and forgot to include a WHERE clause, updating those 6
> > > columns
> > > > in 2700 rows to the wrong value.
> > > >
> > > > All of the transactions are in the same logical log which
> > > > is on-line in the logs dbspaces.
> > > >
> > > > I need something that can scan this logical log and reconstruct
> > > > the "before" data for these 2700 rows and write out the rowid,
> > > > column name, and before values - so that I can create sql to
> > > > update the data back to its original state.
> > > >
> > > > Thanks,
> > > >
> > > > Jim
> > > >
> > > >
> > > >
> > >
> >
> *********************************************************************=
> =3D
> > **
> > > ********
> > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.=3D
> >
> > > >
> > > >
> > >
> > >
> > >
> >
> *********************************************************************=
> =3D
> > **
> > > ********
> > > Forum Note: Use "Reply" to post a response in the discussion
> forum.=
>
> >
> >
> *********************************************************************=
> **
> > =3D
> > ********
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > =3D
> >
> >
> >
> *********************************************************************=
> **
> > ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ***********************************************************************
> =
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• looking for logical log data reconstruction utilit
  Jim Cramer -- Wednesday, 5 December 2007, at 11:34 a.m.
  • Re: looking for logical log data reconstruction ut
    Art S. Kagel (Oninit LLC) -- Wednesday, 5 December 2007, at 11:40 a.m.
    • RE: looking for logical log data reconstructio....
      Jim Cramer -- Wednesday, 5 December 2007, at 12:01 p.m.
      • Re: looking for logical log data reconstructio....
        Art S. Kagel (Oninit LLC) -- Wednesday, 5 December 2007, at 12:09 p.m.
        • RE: looking for logical log data reconstructio....
          Jim Cramer -- Wednesday, 5 December 2007, at 1:04 p.m.
      • RE: looking for logical log data reconstructio....
        John Miller iii -- Wednesday, 5 December 2007, at 12:37 p.m.
        • RE: looking for logical log data reconstructio....
          Jim Cramer -- Wednesday, 5 December 2007, at 12:57 p.m.
          • RE: looking for logical log data reconstruction...
            Clifton Bean -- Wednesday, 5 December 2007, at 1:09 p.m.
            • RE: looking for logical log data reconstructio....
              Jim Cramer -- Wednesday, 5 December 2007, at 1:31 p.m.
          • RE: looking for logical log data reconstructio....
            John Miller iii -- Wednesday, 5 December 2007, at 1:27 p.m.
            • RE: looking for logical log data reconstructio....
              Jim Cramer -- Wednesday, 5 December 2007, at 1:35 p.m.
              • Re: RE: looking for logical log data reconstructio
                DAVID LINTHWAITE -- Thursday, 6 December 2007, at 12:31 p.m.
                • RE: RE: looking for logical log data reconstructio
                  Jim Cramer -- Thursday, 6 December 2007, at 6:26 p.m.
  • Re: looking for logical log data reconstruction ut
    kernoal.stephens@autozone.com -- Wednesday, 5 December 2007, at 11:41 a.m.
  • Re: looking for logical log data reconstruction ut
    Peter_Logan@spartanstores.com -- Wednesday, 5 December 2007, at 11:44 a.m.
    • RE: looking for logical log data reconstructio....
      Jim Cramer -- Wednesday, 5 December 2007, at 11:58 a.m.
      • Re: looking for logical log data reconstructio....
        Art S. Kagel (Oninit LLC) -- Wednesday, 5 December 2007, at 12:06 p.m.
        • RE: looking for logical log data reconstructio....
          Jim Cramer -- Wednesday, 5 December 2007, at 1:08 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.