RE: onbar restore question
> -----Original Message-----
> From: jpierrot@chubb.com [SMTP:jpierrot@chubb.com]
> Sent: Tuesday, September 28, 2004 10:27 AM
> To: Bill Dare
> Cc: informix-list@iiug.org
> Subject: Re: onbar restore question
>
>
> Bill,
> If you want to play safe and save some time. How about leaving untouched
> the ixbar file and then try the following
>
> onbar -r -w -p -t "2004-09-01 xx:xx:xx"
[Bill Dare] Why whole-system restore? My backups are not done using the
whole-system option. I never tried -w, but from reading the manual it seems
an onbar -b -L 0 -w would block the system for the duration of the backup.
Also, onbar would backup the server serially. I use BAR_MAX_BACKUP 3. We
are 24x7 here.
Is there any reason this would not work without using whole-system
restore?
Bill
> where xx:xx:xx is your time stamp on the 1st of the month. (usually I
> chosen sometime right after the completion of the backup I wanted to
> restore). That time seems to be very flexible, it does not have to be
> exact.
> Then restore logs to the point in time of "2004-09-06 07:00:00"
> onbar -r -l -t "2004-09-06 07:00:00"> This should definitely work for you too.
>
>
>
>
>
> Bill Dare
>
> <dareb@jevic.com>
>
> Sent by: To
>
> owner-informix-li "''" <informix-list@iiug.org>
>
> st@iiug.org cc
>
>
>
> Subject
>
> 09/28/2004 07:50 onbar restore question
>
> AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 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