RE: Clarification on ONBAR restore sequence..
Posted in 2003
Topics: Backup & Restore
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>
<P><FONT SIZE=3D2>Hi,</FONT>
</P>
<P><FONT SIZE=3D2> Thanks for your response. </FONT>
</P>
<P><FONT SIZE=3D2> 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 . </FONT></P>
<P><FONT SIZE=3D2>Do you mean to say that the second "onbar -r -p =
-w" will still perform the level-0 restore ?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Rajesh Rajasekaran</FONT>
<BR><FONT SIZE=3D2>Informix Database Administrator</FONT>
<BR><FONT SIZE=3D2>Forest Pharmaceuticals Inc.</FONT>
<BR><FONT SIZE=3D2>314-493-7073 (Work)</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Abraham Kirubakaran [<A =
HREF=3D"mailto:bull_informix@yahoo.com">mailto:bull_informix@yahoo.com</=
A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, July 18, 2003 2:24 PM</FONT>
<BR><FONT SIZE=3D2>To: Rajasekaran, Rajesh; =
'informix-list@iiug.org'</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Clarification on ONBAR restore =
sequence..</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hypothetically, when you begin the restore, you =
should</FONT>
<BR><FONT SIZE=3D2>have all the information from the Level-0 forward =
,</FONT>
<BR><FONT SIZE=3D2>which includes the information about level-1. =
The</FONT>
<BR><FONT SIZE=3D2>engine checks two places, the ixbar file and =
the</FONT>
<BR><FONT SIZE=3D2>sysutils.bar_* tables. Unless you have them in =
place,</FONT>
<BR><FONT SIZE=3D2>the backup will very likely fail.</FONT>
<BR><FONT SIZE=3D2>I have done the restore using the =
"Manipulated" ixbar</FONT>
<BR><FONT SIZE=3D2>file for a full point in time restore, but did'nt =
have</FONT>
<BR><FONT SIZE=3D2>to use the level-1, which prevents me from =
affirming</FONT>
<BR><FONT SIZE=3D2>my opinion.</FONT>
</P>
<P><FONT SIZE=3D2>Thksz</FONT>
<BR><FONT SIZE=3D2>Abraham</FONT>
</P>
<P><FONT SIZE=3D2>--- "Rajasekaran, Rajesh"</FONT>
<BR><FONT SIZE=3D2><RRajasekaran@forestpharm.com> wrote:</FONT>
<BR><FONT SIZE=3D2>> Hi </FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> I would like to clarify regarding the =
ONBAR</FONT>
<BR><FONT SIZE=3D2>> restore.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> I want to perform an alternate client =
restore.The</FONT>
<BR><FONT SIZE=3D2>> backups are serial whole</FONT>
<BR><FONT SIZE=3D2>> system backup using "onbar -b -w -L =
0".I have the</FONT>
<BR><FONT SIZE=3D2>> ixbar file which contains</FONT>
<BR><FONT SIZE=3D2>> only the recent level-0 entries. Assuming =
that the</FONT>
<BR><FONT SIZE=3D2>> RESTARTABLE_RESTORE is</FONT>
<BR><FONT SIZE=3D2>> enabled, i perform the physical restore with =
"onbar</FONT>
<BR><FONT SIZE=3D2>> -r -p -w" and the</FONT>
<BR><FONT SIZE=3D
Related threads
- Conversion to differeent characters sets
- Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)
- Problem in changing locale via dbexport/dbimport
- Re: Matches not Work in 7.30
- DATABASE vs CONNECT TO: Invalid characters error?