RE: onbar restore question

Bill, Sorry, I should have asked you if you are doing serial or parallel backup. It is true the onbar -b -w -L 0 is serial, but it should not block the system during its course or the duration of the backup . I am in a 24x7 environment also. I am doing it frequently and not seen this behavior yet. However, I don't see why you can't achieve your task with a backup taken without the -w. The only difference would be in your command line . Type onbar -- to verify the syntax onbar -r {-t <time> | -n <log> } up to the log number you want to restore to or point in time It should work for both parallel and serial backups. JP Bill Dare <dareb@jevic.com> To 09/28/2004 11:12 "'jpierrot@chubb.com'" AM <jpierrot@chubb.com> cc informix-list@iiug.org Subject 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