Clarification on ONBAR 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_01C34B9F.8C29F8B0
Content-Type: text/plain;
charset="iso-8859-1"
Hello All,
I have a clarification regarding the database restore. We are planning
for a h/w upgrade for our SAP R/3 database server running on IDS 7.31UD2XG
under Solaris 8. Iam currently devising a plan for the upgrade keeping in
mind the possibility of downtime only for the essential things during the
switch.
On the database restore part, here is my brief plan.
1) Restore the database links on the new box- OFFLINE.
2) While the original PRD is up and running, perform the database restore
using "onbar -r -p -w" on the new system -OFFLINE
3) Stop the database on the Original PRD(old) after backing up all the
logs-ONLINE
4)Alter the ixbar.0 on the new system to include all log backup entries
since the last level-0 / level-1.
5) Once it completes the physical restore for the DBspaces on the new box,
restore all the logical logs that were backed up since the last
level0/level1 backup using "onbar -r -l - ONLINE.
Before performing the step (5), i will alter as in step(4) the ixbar.0 on
the new box to include all log backup entries upto that point which was
backed up on the orignal system. Our physical dbspace (onbar -r -w -p)
restore approximately takes 10 hrs. During the 10 hrs, the idea is to retain
the original system up and running. This way, i can restore the database on
the new system upto the latest level without much of a downtime and the
users may not be affected for a longer period.
Queries
-----------
1) On the new box, will ONBAR(onbar -l -c) detect the changes and restore
the logs as per the latest ixbar.0 on step(4) ?
2) Should i have to restore using "onbar -r -n <log number>" for each log ?
Any comments/suggesstions are appreciated.
Regards
Rajesh Rajasekaran
Informix Database Administrator
Forest Pharmaceuticals Inc.
314-493-7073 (Work)
------_=_NextPart_001_01C34B9F.8C29F8B0
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>Clarification on ONBAR restore.....</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hello All,</FONT>
</P>
<P><FONT SIZE=3D2> I have a clarification regarding the =
database restore. We are planning for a h/w upgrade for our SAP R/3 =
database server running on IDS 7.31UD2XG under Solaris 8. Iam currently =
devising a plan for the upgrade keeping in mind the possibility =
of downtime only for the essential things during the =
switch.</FONT></P>
<P><FONT SIZE=3D2>On the database restore part, here is my brief =
plan.</FONT>
</P>
<P><FONT SIZE=3D2>1) Restore the database links on the new box- =
OFFLINE.</FONT>
<BR><FONT SIZE=3D2>2) While the original PRD is up and running, perform =
the database restore using "onbar -r -p -w" on the new system =
-OFFLINE</FONT></P>
<P><FONT SIZE=3D2>3) Stop the database on the Original PRD(old) after =
backing up all the logs-ONLINE</FONT>
<BR><FONT SIZE=3D2>4)Alter the ixbar.0 on the new system to include all =
log backup entries since the last level-0 / level-1.</FONT>
<BR><FONT SIZE=3D2>5) Once it completes the physical restore for the =
DBspaces on the new box, restore all the logical logs that were backed =
up since the last level0/level1 backup using "onbar -r -l - =
ONLINE.</FONT></P>
<P><FONT SIZE=3D2>Before performing the step (5), i will alter as in =
step(4) the ixbar.0 on the new box to include all log backup entries =
upto that point which was backed up on the orignal system. Our physical =
dbspace (onbar -r -w -p) restore approximately takes 10 hrs. During the =
10 hrs, the idea is to retain the original system up and running. =
This way, i can restore the database on the new system upto the latest =
level without much of a downtime and the users may not be affected for =
a longer period.</FONT></P>
<P><FONT SIZE=3D2>Queries</FONT>
<BR><FONT SIZE=3D2>-----------</FONT>
<BR><FONT SIZE=3D2>1) On the new box, will ONBAR(onbar -l -c) detect =
the changes and restore the logs as per the latest ixbar.0 on =
step(4) ?</FONT></P>
<P><FONT SIZE=3D2>2) Should i have to restore using "onbar =
-r -n <log number>" for each log ?</FONT>
</P>
<P><FONT SIZE=3D2>Any comments/suggesstions are appreciated.</FONT>
</P>
<P><FONT SIZE=3D2>Regards </FONT>
<BR><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>
</BODY>
</HTML>
------_=_NextPart_001_01C34B9F.8C29F8B0--
sending to informix-list