Onbar - failures with pit recovery
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C4D814.B7A8E020
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
We have implemented onbar on IBM AIX 5.2 64 bit with IDS 9.40.fc3. When
we do a point-in-time recovery it sticks if fast-recovery for some time
and then fails with an assertion failure and problems with shm. I can't
give the exact messages at this time as we are trying a point-in-log
recovery at the moment and I don't have the ability to dial in when the
recovery is underway.
For background information we tried three pit recoveries before we went
live and two worked. As we had started trying to do a log backup whilst
recovering on the attempt that failed we assumed that this was the
cause.
The site is 24 x 7 and today a junior support person reloaded a table
wrongly and corrupted a live table. So we decided to use pit recovery
to restore to about 5 minutes before the error occurred. This failed
with the assertion failure so we tried another usiing a point-in-time
before the current log. That failed as well.
I am told that FC5 is now available and fixes problems with similar
symptoms to this, but the scheduling of a software upgrade like that is
not easy. However, if we were sure that this would fix the recovery I
would be able to force installation in a very short time. Can anybody
look through the bug lists fixed in FC5 to see if there is anything
likely, (FC5 release notes are not on IBM web site yet), or does naybody
have any ideas what we are doing wrong.
regards
Malcolm
------=_NextPart_000_0001_01C4D814.B7A8E020
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial size=3D2>We =
have implemented=20
onbar on IBM AIX 5.2 64 bit with IDS 9.40.fc3. When we do a =
point-in-time=20
recovery it sticks if fast-recovery for some time and then fails with an =
assertion failure and problems with shm. I can't give the exact =
messages=20
at this time as we are trying a point-in-log recovery at the moment and =
I don't=20
have the ability to dial in when the recovery is underway. =20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial size=3D2>For =
background=20
information we tried three pit recoveries before we went live =
and two=20
worked. As we had started trying to do a log backup whilst =
recovering on=20
the attempt that failed we assumed that this was the cause. =20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial size=3D2>The =
site is 24 x 7=20
and today a junior support person reloaded a table wrongly and corrupted =
a live=20
table. So we decided to use pit recovery to restore to about 5 =
minutes=20
before the error occurred. This failed with the assertion failure =
so we=20
tried another usiing a point-in-time before the current log. That =
failed=20
as well. </FONT></SPAN></DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial size=3D2>I am =
told that FC5=20
is now available and fixes problems with similar symptoms to this, but =
the=20
scheduling of a software upgrade like that is not easy. However, =
if we=20
were sure that this would fix the recovery I would be able to force =
installation=20
in a very short time. Can anybody look through the bug lists fixed =
in FC5=20
to see if there is anything likely, (FC5 release notes are not on IBM =
web site=20
yet), or does naybody have any ideas what we are doing=20
wrong.</FONT></SPAN></DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial=20
size=3D2>regards</FONT></SPAN></DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D156060302-02122004><FONT face=3DArial=20
size=3D2>Malcolm</FONT></SPAN></DIV></BODY></HTML>
------=_NextPart_000_0001_01C4D814.B7A8E020--
sending to informix-list