f



RE: [Info-ingres] Ingres Upgrade from Version 2.0 to Version 2.6 #2

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_01C52E34.1F3A78F0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

You can carry a cold backup of an Ingres database (offline checkpoint) quite
easily as follows:-

PROCEDURE (NOT Supported by CA)

1.  Use infodb to identify ALL data locations
2.  ingstop
3.  Remove ALL underlying database files:-
4.  For each data_loc# do
    cd <data_loc#>; rm *
    Recover the underlying database files from .ckp saveset (using tar or
cpio)
5.  Use cbf to format the transaction log file(s)
6.  ingstart
7.  Patch iidbdb to demote the dataabse back to version 2.0
8.  sql +Y iidbdb
9.  update iidatabase set dbcmptlvl = 8.0 where name = <dbname>;\p\g\q
10.  Upgradedb <dbname>

CHECKPOINT <dbname> AS SOON AS POSSIBLE

************************************************************************
DISCLAIMER
The information contained in this e-mail is confidential and is intended
for the recipient only.
If you have received it in error, please notify us immediately by reply 
e-mail and then delete it from your system. Please do not copy it or
use it for any other purposes, or disclose the content of the e-mail
to any other person or store or copy the information in any medium. 
The views contained in this e-mail are those of the author and not 
necessarily those of Admenta UK Group.
************************************************************************

------_=_NextPart_001_01C52E34.1F3A78F0
Content-Type: text/html; charset="us-ascii"
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=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [Info-ingres] Ingres Upgrade from Version 2.0 to Version 2.6</TI=
TLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Arial">You can carry a cold backup of an Ingres d=
atabase (offline checkpoint) quite easily as follows:-</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">PROCEDURE (NOT Supported by CA)</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">1.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ari=
al">Use infodb to identify ALL data locations</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">2.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">ingstop</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">3.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">Remove ALL underlying database files:-</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">4.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">For each data_loc# do</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;</FONT> <FONT SIZE=3D2 =
FACE=3D"Arial">cd &lt;data_loc#&gt;; rm *</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;</FONT> <FONT SIZE=3D2 =
FACE=3D"Arial">Recover the underlying database files from .ckp</FONT> <FONT=
 SIZE=3D2 FACE=3D"Arial">saveset</FONT><FONT SIZE=3D2 FACE=3D"Arial"> (usin=
g tar or cpio)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">5.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">Use cbf to format the transaction log file(s)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">6.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">ingstart</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">7.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">Patch iidbdb to demote the dataabse back to version 2.0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">8.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">sql +Y iidbdb</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">9.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"Ar=
ial">update iidatabase set dbcmptlvl =3D 8.0 where name =3D &lt;dbname&gt;;=
\p\g\q</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">10.&nbsp;</FONT> <FONT SIZE=3D2 FACE=3D"A=
rial">Upgradedb &lt;dbname&gt;</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">CHECKPOINT &lt;dbname&gt; AS SOON AS POSSI=
BLE</FONT>
</P>


<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">**************************************************=
**********************</SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">DISCLAIMER</SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">The information contained in this e-mail is confid=
ential and is intended</SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">for the recipient only.</SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">If you have received it in error, please notify us=
 immediately by reply </SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">e-mail and then delete it from your system. Please=
 do not copy it or</SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">use it for any other purposes, or disclose the con=
tent of the e-mail</SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">to any other person or store or copy the informati=
on in any medium. </SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">The views contained in this e-mail are those of th=
e author and not </SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">necessarily those of Admenta UK Group.</SPAN>
</P>
<P STYLE=3D"margin-top: 0pt;margin-bottom: 0pt;"><SPAN STYLE=3D"FONT-FAMILY=
:'Arial';FONT-SIZE:8pt;">**************************************************=
**********************</SPAN> </P></BODY>
</HTML>

------_=_NextPart_001_01C52E34.1F3A78F0--
0
David
3/21/2005 4:36:24 PM
comp.databases.ingres 5857 articles. 0 followers. specially (35) is leader. Post Follow

0 Replies
980 Views

Similar Articles

[PageSpeed] 5

Reply: