RE: Clarification on ONBAR restore sequence..

#1 (**permalink**) 04-19-2008, 07:13 PM

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:bul l_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
 > 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</=
FONT>
 > "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!
 <A HREF=3D"http://sbc.yahoo.com" =
TARGET=3D"_blank">http://sbc.yahoo.com</A>


</BODY>
</HTML>
------_=_NextPart_001_01C34D63.F0A0D8C0--
sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode