Archecker - Can you skip over a log?
On IDS 11.50.FC5 / AIX 6.1, a table-level restore via ON-Bar/archecker loaded the table but hit an "unknown error" while rolling logical logs forward, before reaching the target timestamp. The poster asked whether a bad log could simply be skipped. One suggestion was to hand-edit a copy of the ixbar file to omit the offending log entry. IBM's John Miller replied that archecker starts from the level-0 archive's log ID and applies all logs up to the requested point: you can tell it to stop at a given time or log ID, but it cannot skip logs. No fix for the underlying error was recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IDS 11.50.fc5
Aix - 6.1
When doing a table level restore ... using onbar ... TSM ... The table
loads ... then the logs are applied. At a point prior to reaching the
timestamp, I'm getting an unknown error. My question ... is there a way
to skip over the offending log? I realize I might miss something from the
table that I'm restoring ... but am willing to take that risk ..
thanks for any and all help ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
I can't guarantee the results, but you could try to use a modified ixbar file
before launching archecker, omitting the offending log (saving the real one
obviously).
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, February 10, 2010 7:47 AM
To: ids@iiug.org
Subject: Archecker - Can you skip over a log? [18981]
IDS 11.50.fc5
Aix - 6.1
When doing a table level restore ... using onbar ... TSM ... The table
loads ... then the logs are applied. At a point prior to reaching the
timestamp, I'm getting an unknown error. My question ... is there a way
to skip over the offending log? I realize I might miss something from the
table that I'm restoring ... but am willing to take that risk ..
thanks for any and all help ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
So .. archecker is doing it's work based on the ixbar file? not the
cooresponding database tables?
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Plugge, Joe R." <JRPlugge@west.com>
To:
ids@iiug.org
Date:
02/10/2010 09:28 AM
Subject:
RE: Archecker - Can you skip over a log? [18982]
Sent by:
ids-bounces@iiug.org
I can't guarantee the results, but you could try to use a modified ixbar
file
before launching archecker, omitting the offending log (saving the real
one
obviously).
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, February 10, 2010 7:47 AM
To: ids@iiug.org
Subject: Archecker - Can you skip over a log? [18981]
IDS 11.50.fc5
Aix - 6.1
When doing a table level restore ... using onbar ... TSM ... The table
loads ... then the logs are applied. At a point prior to reaching the
timestamp, I'm getting an unknown error. My question ... is there a way
to skip over the offending log? I realize I might miss something from the
table that I'm restoring ... but am willing to take that risk ..
thanks for any and all help ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Archecker calls onbar, which is using ixbar file ... however, since this is
(warm restorelike) , it may bypass it ... can it hurt to try?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, February 10, 2010 8:49 AM
To: ids@iiug.org
Subject: RE: Archecker - Can you skip over a log? [18983]
So .. archecker is doing it's work based on the ixbar file? not the
cooresponding database tables?
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Plugge, Joe R." <JRPlugge@west.com>
To:
ids@iiug.org
Date:
02/10/2010 09:28 AM
Subject:
RE: Archecker - Can you skip over a log? [18982]
Sent by:
ids-bounces@iiug.org
I can't guarantee the results, but you could try to use a modified ixbar
file
before launching archecker, omitting the offending log (saving the real
one
obviously).
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, February 10, 2010 7:47 AM
To: ids@iiug.org
Subject: Archecker - Can you skip over a log? [18981]
IDS 11.50.fc5
Aix - 6.1
When doing a table level restore ... using onbar ... TSM ... The table
loads ... then the logs are applied. At a point prior to reaching the
timestamp, I'm getting an unknown error. My question ... is there a way
to skip over the offending log? I realize I might miss something from the
table that I'm restoring ... but am willing to take that risk ..
thanks for any and all help ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
*******************************************************************************
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.
Thanks .. I'll give it a shot ..
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Plugge, Joe R." <JRPlugge@west.com>
To:
ids@iiug.org
Date:
02/10/2010 09:59 AM
Subject:
RE: Archecker - Can you skip over a log? [18984]
Sent by:
ids-bounces@iiug.org
Archecker calls onbar, which is using ixbar file ... however, since this
is
(warm restorelike) , it may bypass it ... can it hurt to try?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, February 10, 2010 8:49 AM
To: ids@iiug.org
Subject: RE: Archecker - Can you skip over a log? [18983]
So .. archecker is doing it's work based on the ixbar file? not the
cooresponding database tables?
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Plugge, Joe R." <JRPlugge@west.com>
To:
ids@iiug.org
Date:
02/10/2010 09:28 AM
Subject:
RE: Archecker - Can you skip over a log? [18982]
Sent by:
ids-bounces@iiug.org
I can't guarantee the results, but you could try to use a modified ixbar
file
before launching archecker, omitting the offending log (saving the real
one
obviously).
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, February 10, 2010 7:47 AM
To: ids@iiug.org
Subject: Archecker - Can you skip over a log? [18981]
IDS 11.50.fc5
Aix - 6.1
When doing a table level restore ... using onbar ... TSM ... The table
loads ... then the logs are applied. At a point prior to reaching the
timestamp, I'm getting an unknown error. My question ... is there a way
to skip over the offending log? I realize I might miss something from the
table that I'm restoring ... but am willing to take that risk ..
thanks for any and all help ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
*******************************************************************************
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.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
archecker will take the logid from the associated level 0 archive
then all logical log id up to the time you requested. Now you
can tell it to stop at any time (or logid), but archecker can not
skip log files by default.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 02/10/2010 07:26:56 AM:
> Thanks .. I'll give it a shot ..
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Plugge, Joe R." <JRPlugge@west.com>
> To:
> ids@iiug.org
> Date:
> 02/10/2010 09:59 AM
> Subject:
> RE: Archecker - Can you skip over a log? [18984]
> Sent by:
> ids-bounces@iiug.org
>
> Archecker calls onbar, which is using ixbar file ... however, since this
> is
> (warm restorelike) , it may bypass it ... can it hurt to try?
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: Wednesday, February 10, 2010 8:49 AM
> To: ids@iiug.org
> Subject: RE: Archecker - Can you skip over a log? [18983]
>
> So .. archecker is doing it's work based on the ixbar file? not the
> cooresponding database tables?
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Plugge, Joe R." <JRPlugge@west.com>
> To:
> ids@iiug.org
> Date:
> 02/10/2010 09:28 AM
> Subject:
> RE: Archecker - Can you skip over a log? [18982]
> Sent by:
> ids-bounces@iiug.org
>
> I can't guarantee the results, but you could try to use a modified ixbar
> file
> before launching archecker, omitting the offending log (saving the real
> one
> obviously).
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: Wednesday, February 10, 2010 7:47 AM
> To: ids@iiug.org
> Subject: Archecker - Can you skip over a log? [18981]
>
> IDS 11.50.fc5
> Aix - 6.1
>
> When doing a table level restore ... using onbar ... TSM ... The table
> loads ... then the logs are applied. At a point prior to reaching the
> timestamp, I'm getting an unknown error. My question ... is there a way
> to skip over the offending log? I realize I might miss something from the
> table that I'm restoring ... but am willing to take that risk ..
>
> thanks for any and all help ...
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
*******************************************************************************
>
> 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.
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
That's what I figured .. thanks anyway ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"John Miller iii" <miller3@us.ibm.com>
To:
ids@iiug.org
Date:
02/10/2010 11:28 AM
Subject:
RE: Archecker - Can you skip over a log? [18991]
Sent by:
ids-bounces@iiug.org
archecker will take the logid from the associated level 0 archive
then all logical log id up to the time you requested. Now you
can tell it to stop at any time (or logid), but archecker can not
skip log files by default.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 02/10/2010 07:26:56 AM:
> Thanks .. I'll give it a shot ..
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Plugge, Joe R." <JRPlugge@west.com>
> To:
> ids@iiug.org
> Date:
> 02/10/2010 09:59 AM
> Subject:
> RE: Archecker - Can you skip over a log? [18984]
> Sent by:
> ids-bounces@iiug.org
>
> Archecker calls onbar, which is using ixbar file ... however, since this
> is
> (warm restorelike) , it may bypass it ... can it hurt to try?
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: Wednesday, February 10, 2010 8:49 AM
> To: ids@iiug.org
> Subject: RE: Archecker - Can you skip over a log? [18983]
>
> So .. archecker is doing it's work based on the ixbar file? not the
> cooresponding database tables?
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Plugge, Joe R." <JRPlugge@west.com>
> To:
> ids@iiug.org
> Date:
> 02/10/2010 09:28 AM
> Subject:
> RE: Archecker - Can you skip over a log? [18982]
> Sent by:
> ids-bounces@iiug.org
>
> I can't guarantee the results, but you could try to use a modified ixbar
> file
> before launching archecker, omitting the offending log (saving the real
> one
> obviously).
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: Wednesday, February 10, 2010 7:47 AM
> To: ids@iiug.org
> Subject: Archecker - Can you skip over a log? [18981]
>
> IDS 11.50.fc5
> Aix - 6.1
>
> When doing a table level restore ... using onbar ... TSM ... The table
> loads ... then the logs are applied. At a point prior to reaching the
> timestamp, I'm getting an unknown error. My question ... is there a way
> to skip over the offending log? I realize I might miss something from
the
> table that I'm restoring ... but am willing to take that risk ..
>
> thanks for any and all help ...
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
*******************************************************************************
>
> 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.
>
>
>
*******************************************************************************
>
> 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.