RE: Clarification on ONBAR restore sequence..

Posted in 2003

Rajasekaran, Rajesh — Fri, 18 Jul 2003 14:36:53 -0500 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C34D63.F0A0D8C0 Content-Type: text/plain; charset="iso-8859-1" Hi, Thanks for your response. Onbar will look only the ixbar.0 file until the database comes to quiescent/online mode. So i thought, i can restore the level 0 with the original ixbar.0 using "onbar -p -r -w" and then while the database is in recovery mode, after altering the ixbar.0 to include the level 1 entries, restarting with "onbar -p -r -w" will restore only level 1 . Do you mean to say that the second "onbar -r -p -w" will still perform the level-0 restore ? Rajesh Rajasekaran Informix Database Administrator Forest Pharmaceuticals Inc. 314-493-7073 (Work) -----Original Message----- From: Abraham Kirubakaran [mailto:bull_informix@yahoo.com] Sent: Friday, July 18, 2003 2:24 PM To: Rajasekaran, Rajesh; 'informix-list@iiug.org' Subject: Re: Clarification on ONBAR restore sequence.. Hypothetically, when you begin the restore, you should have all the information from the Level-0 forward , which includes the information about level-1. The engine checks two places, the ixbar file and the sysutils.bar_* tables. Unless you have them in place, the backup will very likely fail. I have done the restore using the "Manipulated" ixbar file for a full point in time restore, but did'nt have to use the level-1, which prevents me from affirming my opinion. Thksz Abraham --- "Rajasekaran, Rajesh" <RRajasekaran@forestpharm.com> wrote: > Hi > > I would like to clarify regarding the ONBAR > restore. > > I want to perform an alternate client restore.The > backups are serial whole > system backup using "onbar -b -w -L 0".I have the > ixbar file which contains > only the recent level-0 entries. Assuming that the > RESTARTABLE_RESTORE is> enabled, i perform the physical restore with "onbar > -r -p -w" and the > database comes to "Fast recovery mode". > > At this point, i wanted to restore a subsequent > level-1. So i will be either > replacing the ixbar.0 file with another ixbar that > contains level 1 entries > or an ixbar which contains both the already restored > level-0 and the new > level 1 entries. I now start again the restore > "onbar -r -p -w" since there > is no specific command to restore only level 1. > > The whole issue is that I can take the level 1 > backup from the source system > only towards the end time of level 0 restore on > the alternate client. > Hence I will not have the updated ixbar (level1) > entries during the level0 > restore. Hence i got to replace the ixbar and hoping > to kick off only level > 1. > > 1)Will ONBAR restore only the level 1 ? or Will it > go back and restore > level-0 followed by level-1 ? > 2)Will it restore only level 1 if the newly replace > ixbar file contains > only the level1 entries ? > > Your suggestions/comments are greatly appreciated. > > Rajesh Rajasekaran > Informix Database Administrator > Forest Pharmaceuticals Inc. > 314-493-7073 (Work) > > sending to informix-list __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com ------_=_NextPart_001_01C34D63.F0A0D8C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: Clarification on ONBAR restore sequence..</TITLE> </HEAD> <BODY> Hi,   Thanks for your response.    Onbar will look only the ixbar.0  file = until the database comes to quiescent/online mode. So i thought, i can = restore the level 0 with the original ixbar.0 using "onbar -p -r = -w" and then while the database is in recovery mode, after = altering the ixbar.0 to include the level 1 entries, restarting with = "onbar -p -r -w" will restore only level 1 . Do you mean to say that the second "onbar -r -p = -w" will still perform the level-0 restore ? Rajesh Rajasekaran Informix Database Administrator Forest Pharmaceuticals Inc. 314-493-7073 (Work) -----Original Message----- From: Abraham Kirubakaran [<A = HREF=3D"mailto:bull_informix@yahoo.com">mailto:bull_informix@yahoo.com</= A>] Sent: Friday, July 18, 2003 2:24 PM To: Rajasekaran, Rajesh; = 'informix-list@iiug.org' Subject: Re: Clarification on ONBAR restore = sequence.. Hypothetically, when you begin the restore, you = should have all the information from the Level-0 forward = , which includes the information about level-1. = The engine checks two  places, the ixbar file and = the sysutils.bar_* tables. Unless you have them in = place, the backup will very likely fail. I have done the restore using the = "Manipulated" ixbar file for a full point in time restore, but did'nt = have to use the level-1, which prevents me from = affirming my opinion. Thksz Abraham --- "Rajasekaran, Rajesh" <RRajasekaran@forestpharm.com> wrote: > Hi > >  I would like to clarify regarding the = ONBAR > restore. > > I want to perform an alternate client = restore.The > backups are serial whole > system backup using "onbar -b -w -L = 0".I have the > ixbar file which contains > only the recent level-0 entries. Assuming = that  the > RESTARTABLE_RESTORE is > enabled, i perform the physical restore with = "onbar > -r -p -w"  and the <FONT SIZE=3D

RE: Clarification on ONBAR restore sequence..

Related threads

Your privacy choices