RE: onbar restore question
Posted in 2004
Thanks Brice.
> -----Original Message-----
> From: briceavila@hotmail.com [SMTP:briceavila@hotmail.com]
> Sent: Wednesday, September 29, 2004 11:22 AM
> To: informix-list@iiug.org
> Subject: Re: onbar restore question
>
> Bill,
>
> Editing the ixbar file to do a point-in-time restore in your version
> of IDS will not work, according to IBM techdoc #1143976. onbar will
> initial uses the ixbar file to restore, but then will default to the
> information in the sysutils database once the instance starts,
> restoring past your ixbar editing.
>
> This means that to ensure that you are running a point-in-time
> restore, you'll need to use the "-t" option with your point-in-time
> definition:
>
> onbar -r -t "2004-09-06 07:00:00">
> Please double-check the syntax; I'm writing this off the top of my
> head. Hope this information helps.
>
> Brice Avila
>
> Bill Dare <dareb@jevic.com> wrote in message
> news:<cjbrjg$h5r$1@news.xmission.com>...
> > IDS 9.40.FC3 AIX 5.2
> >
> > I do a daily level 0 backup and a monthly level 0 backup on the 1st of
> the
> > month. Hypothetically, say I want to restore from the monthly level 0
> to a
> > point in time of 2004-09-06 07:00:00. So I edit the ixbar file and
> remove
> > the entries for all the level 0's since the monthly and leave just the
> logs.
> > Will this work? Will onbar do logical restore on the logs after the
> other
> > level 0's? Is there anything written to the logical logs to indicate
> that a
> > level 0 backup took place?
> >
> > Bill
> > sending to informix-list
sending to informix-list