IDS Forum

RE: onbar restore blocked on checkpoint

Posted By: Martin Fuerderer
Date: Tuesday, 18 March 2008, at 11:23 a.m.

In Response To: RE: onbar restore blocked on checkpoint (JOHAN BACKLUND)

Hi,

last question first:

Yes, a whole system backup and restore
will bring up the restored system in a consistent
state even without logical log restore.

Now to the original problem:

I would (again) like to know in more detail, what onbar
is doing when the logical log restore phase begins
(or should begin). At one point (I think) you said that
there is no message in the ON-Bar activity log file,
but this sounds a bit strange.

To me it is not clear whether onbar was able to restore
any logical log files or no log files were restored at all.
Does the hang occur before any log file is restored?
Or after some log files, but not all those necessary, were
restored? Or does the hang occur after all necessary
log files were restored?
In the latter case it would most probably be a problem
in the server. In the other two cases it may well be a
problem of onbar (and/or the SM or its configuration).

To get more info from onbar it is possible to switch on
some tracing by setting the onconfig file parameter
BAR_DEBUG to a value like 6 (medium tracing).
You also need to set parameter BAR_DEBUG_LOG
to an absolute file pathname, so that the information
can be written to that file.

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland Entwicklung GmbH
Chairman of the Supervisory Board: Martin Jetter
Board of Management: Herbert Kircher
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

ids-bounces@iiug.org wrote on 18.03.2008 14:47:03:

> Thanks for your response!
>
> There are no messages in the TSM error logs.
>
> Maybe I should have pointed out that this is an imported restore, so I
am
> restoring to another instance on another machine (but with
identicalhardware,
> disk configuration and software setup).
>
> Prior to starting onbar, I am copying
>
> * sm_versions
> * ixbar.0
> * oncfg_*
> * onconfig (changing dbservername to match target instance)
>
> from the source (production) instance to the target (test) instance.
>
> Since last post I have tried
>
> onbar -r
>
> with the same (negative) results.
>
> However, I managed to get the server to online mode by skipping the
logical
> restore using the following command sequence:
>
> onbar -r -p ...
> onmode -m
>
> But from what I understand, this kind of restore won't guarantee a
consistent
> database since the backup was taken in parallel. Is this correct? Would
it be
> consistent if a serial (whole, -w) backup is being made instead?
> This could be
> useful information for setting up an intermediate solution while trying
to
> locate the checkpoint problem.
>
> Thanks.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference
> The Power Conference for Informix Professionals
> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
> http://www.iiug.org/conf
> Registration Now Open!!

Messages In This Thread

• onbar restore blocked on checkpoint
  JOHAN BACKLUND -- Monday, 17 March 2008, at 9:18 a.m.
  • Re: onbar restore blocked on checkpoint
    JOHAN BACKLUND -- Monday, 17 March 2008, at 12:05 p.m.
    • RE: onbar restore blocked on checkpoint
      Everett Mills -- Monday, 17 March 2008, at 12:41 p.m.
      • Re: RE: onbar restore blocked on checkpoint
        JOHAN BACKLUND -- Tuesday, 18 March 2008, at 3:49 a.m.
        • Re: RE: onbar restore blocked on checkpoint
          NORMA JEAN SEBASTIAN -- Tuesday, 18 March 2008, at 8:59 a.m.
          • RE: onbar restore blocked on checkpoint
            JOHAN BACKLUND -- Tuesday, 18 March 2008, at 9:47 a.m.
            • RE: onbar restore blocked on checkpoint
              Martin Fuerderer -- Tuesday, 18 March 2008, at 11:23 a.m.
              • Re: RE: onbar restore blocked on checkpoint
                NORMA JEAN SEBASTIAN -- Tuesday, 18 March 2008, at 11:31 a.m.
              • RE: onbar restore blocked on checkpoint
                JOHAN BACKLUND -- Tuesday, 18 March 2008, at 12:20 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.