Who can help ?
A user accidentally deleted ~300,000 rows from an OLTP table via a purge job run with wrong parameters and asked whether the data could be recovered from the logical logs (no backup existed, and IBM support offered no help). Jack Parker said a restore from a level-0 backup is normally the easiest route; failing that, you can replay logs with onlog and parse the output (tedious, reportedly weeks of work), or dump the table's raw pages and extract rows still present but flagged deleted — so the table must be kept out of use immediately. He pointed to Art Kagel's utilities at iiug.org/software/archive/utils_ak and suggested hiring him. Another poster simply asserted recovery from logical logs is possible. No confirmed outcome is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello all, One of our employees deleted 300,000 fresh data from our OLTP database. (It was a purge process which got activated with the wrong parameters and it kept deleting fresh/new transactions). Is there any way I could get this data back from the logical logs ? If so how ? (IBM tech support is no help in this issue) Thanks. Ravi. --------------------------------- Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online
Sigh. Always a fun one. Should be in the FAQ.
Restore from backup is going to be your easiest route.
You can use onlog to play back the logs and parse them, however the data you
will find therein is not going to be organized neatly and the last time I
ran into someone who tried this, it took him weeks.
You can also dump the pages the table was on and (if no inserts or updates
which required a rewrite have occured) you will find the data as it is
supposed to be in the table, but with a delete flag lit up. So you would
have to parse the data out of the table in question.
Now as to specifics, hmmm - hang on a bit and I'll go try a few things. But
for right now, take the table out of circulation so that option two may
still be an option.
cheers
j.
----- Original Message -----
From: "Ravi T " <ravit29@yahoo.com>
To: <ids@iiug.org>
Sent: Monday, February 16, 2004 10:06 AM
Subject: Who can help ? [2539]
> Hello all,
>
> One of our employees deleted 300,000 fresh data from our OLTP database.
(It was a purge process which got activated with the wrong parameters and it
kept deleting fresh/new transactions).
>
> Is there any way I could get this data back from the logical logs ? If so
how ? (IBM tech support is no help in this issue)
>
> Thanks.
>
> Ravi.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
>
>
I just replied from another box - and to the wrong list. I sent to the =
informix list, not the ids list. =20
I also slapped my head as soon as I hit the send button - I referred to =
chapter 2 of the reference manual, I should have said chapter 3 - the =
data types chapter (I think - my copy seems to have walked off). It =
also occurs to me that this is the sort of thing that Art Kagel likes to =
play with, perhaps his utilities package already addresses this, or =
perhaps you could hire him to assist.
Regards,
Jack Parker
----- Original Message -----=20
From: Ravi T=20
To: Jack Parker ; ids@iiug.org=20
Sent: Monday, February 16, 2004 12:06 PM
Subject: Re: Who can help ? [2539]=20
Thanks Jack,
Yes please send us the specifics when you have them. =20
(Restore from level 0 backup is not an option because they never got =
to the backup).
Thanks.
Ravi.
Jack Parker <vze2qjg5@verizon.net> wrote:
Sigh. Always a fun one. Should be in the FAQ.
Restore from backup is going to be your easiest route.
You can use onlog to play back the logs and parse them, however the =
data you
will find therein is not going to be organized neatly and the last =
time I
ran into someone who tried this, it took him weeks.
You can also dump the pages the table was on and (if no inserts or =
updates
which required a rewrite have occured) you will find the data as it =
is
supposed to be in the table, but with a delete flag lit up. So you =
would
have to parse the data out of the table in question.
Now as to specifics, hmmm - hang on a bit and I'll go try a few =
things. But
for right now, take the table out of circulation so that option two =
may
still be an option.
cheers
j.
----- Original Message -----=20
From: "Ravi T "=20
To:=20
Sent: Monday, February 16, 2004 10:06 AM
Subject: Who can help ? [2539]
> Hello all,
>
> One of our employees deleted 300,000 fresh data from our OLTP =
database.
(It was a purge process which got activated with the wrong =
parameters and it
kept deleting fresh/new transactions).
>
> Is there any way I could get this data back from the logical logs =
? If so
how ? (IBM tech support is no help in this issue)
>
> Thanks.
>
> Ravi.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
>
>
-------------------------------------------------------------------------=
-----
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
Thanks Jack for all your help.
Art Kagel, please respond and let us know how to get your utility.
Thanks.
Ravi.
Jack Parker <vze2qjg5@verizon.net> wrote:
I just replied from another box - and to the wrong list. I sent to the
informix list, not the ids list.
I also slapped my head as soon as I hit the send button - I referred to
chapter 2 of the reference manual, I should have said chapter 3 - the data
types chapter (I think - my copy seems to have walked off). It also occurs to
me that this is the sort of thing that Art Kagel likes to play with, perhaps
his utilities package already addresses this, or perhaps you could hire him to
assist.
Regards,
Jack Parker
----- Original Message -----
From: Ravi T
To: Jack Parker ; ids@iiug.org
Sent: Monday, February 16, 2004 12:06 PM
Subject: Re: Who can help ? [2539]
Thanks Jack,
Yes please send us the specifics when you have them.
(Restore from level 0 backup is not an option because they never got to the
backup).
Thanks.
Ravi.
Jack Parker <vze2qjg5@verizon.net> wrote:
Sigh. Always a fun one. Should be in the FAQ.
Restore from backup is going to be your easiest route.
You can use onlog to play back the logs and parse them, however the data you
will find therein is not going to be organized neatly and the last time I
ran into someone who tried this, it took him weeks.
You can also dump the pages the table was on and (if no inserts or updates
which required a rewrite have occured) you will find the data as it is
supposed to be in the table, but with a delete flag lit up. So you would
have to parse the data out of the table in question.
Now as to specifics, hmmm - hang on a bit and I'll go try a few things. But
for right now, take the table out of circulation so that option two may
still be an option.
cheers
j.
----- Original Message -----
From: "Ravi T "
To:
Sent: Monday, February 16, 2004 10:06 AM
Subject: Who can help ? [2539]
> Hello all,
>
> One of our employees deleted 300,000 fresh data from our OLTP database.
(It was a purge process which got activated with the wrong parameters and it
kept deleting fresh/new transactions).
>
> Is there any way I could get this data back from the logical logs ? If so
how ? (IBM tech support is no help in this issue)
>
> Thanks.
>
> Ravi.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
>
>
---------------------------------
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
---------------------------------
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
Oh sorry. Try http://www.iiug.org/software/archive/utils_ak
cheers
j.
----- Original Message -----=20
From: Ravi T=20
To: Jack Parker ; ids@iiug.org=20
Sent: Monday, February 16, 2004 4:43 PM
Subject: Re: Who can help ? [2539]=20
Thanks Jack for all your help. =20
Art Kagel, please respond and let us know how to get your utility. =20
Thanks.
Ravi.
Jack Parker <vze2qjg5@verizon.net> wrote:
I just replied from another box - and to the wrong list. I sent to =
the informix list, not the ids list. =20
I also slapped my head as soon as I hit the send button - I referred =
to chapter 2 of the reference manual, I should have said chapter 3 - the =
data types chapter (I think - my copy seems to have walked off). It =
also occurs to me that this is the sort of thing that Art Kagel likes to =
play with, perhaps his utilities package already addresses this, or =
perhaps you could hire him to assist.
Regards,
Jack Parker
----- Original Message -----=20
From: Ravi T=20
To: Jack Parker ; ids@iiug.org=20
Sent: Monday, February 16, 2004 12:06 PM
Subject: Re: Who can help ? [2539]=20
Thanks Jack,
Yes please send us the specifics when you have them. =20
(Restore from level 0 backup is not an option because they never =
got to the backup).
Thanks.
Ravi.
Jack Parker <vze2qjg5@verizon.net> wrote:
Sigh. Always a fun one. Should be in the FAQ.
Restore from backup is going to be your easiest route.
You can use onlog to play back the logs and parse them, however =
the data you
will find therein is not going to be organized neatly and the =
last time I
ran into someone who tried this, it took him weeks.
You can also dump the pages the table was on and (if no inserts =
or updates
which required a rewrite have occured) you will find the data as =
it is
supposed to be in the table, but with a delete flag lit up. So =
you would
have to parse the data out of the table in question.
Now as to specifics, hmmm - hang on a bit and I'll go try a few =
things. But
for right now, take the table out of circulation so that option =
two may
still be an option.
cheers
j.
----- Original Message -----=20
From: "Ravi T "=20
To:=20
Sent: Monday, February 16, 2004 10:06 AM
Subject: Who can help ? [2539]
> Hello all,
>
> One of our employees deleted 300,000 fresh data from our OLTP =
database.
(It was a purge process which got activated with the wrong =
parameters and it
kept deleting fresh/new transactions).
>
> Is there any way I could get this data back from the logical =
logs ? If so
how ? (IBM tech support is no help in this issue)
>
> Thanks.
>
> Ravi.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
>
>
-------------------------------------------------------------------------=
-
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
-------------------------------------------------------------------------=
-----
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
Yes you can restore the data from logical logs. Thanks, Shiller > -----Original Message----- > From: Ravi T [SMTP:ravit29@yahoo.com] > Sent: Monday, February 16, 2004 7:36 PM > To: ids@iiug.org > Subject: Who can help ? [2539] > > Hello all, > > One of our employees deleted 300,000 fresh data from our OLTP database. > (It was a purge process which got activated with the wrong parameters and > it kept deleting fresh/new transactions). > > Is there any way I could get this data back from the logical logs ? If so > how ? (IBM tech support is no help in this issue) > > Thanks. > > Ravi. > > > > --------------------------------- > Do you Yahoo!? > Yahoo! Finance: Get your refund fast by filing online ************************************************************************** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. **************************************************************************