RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database instan

From: Adams, Matthew (GECP, MABG, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Mon, 24 Mar 2003 16:24:57 -0500
Message-Id: <24765.322940@fatcity.com>

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.

------=_NextPartTM-000-9b5fa6ee-e71b-420b-bff5-786aac0b5f0d Content-Type: multipart/alternative;

boundary="----_=_NextPart_001_01C2F24B.D1BD2C60"

------_=_NextPart_001_01C2F24B.D1BD2C60
Content-Type: text/plain;

charset="iso-8859-1"

I did this a couple of weeks ago. The answer is yes, but you recover first, then upgrade.

You've got to

0) Note the sequence number of the log file being written to in the source database before you start.

1) put source in hot backup mode
2) copy files to new destination
3) take source out of backup mode
4) NOTE the date/time
5) 'alter system switch logfile' on the source
6) copy all archived log files from the one

noted in the step 0 to the most recent (inclusive) to destination

7) (optional) on source, do a 'alter database backup controlfile to trace'
8) (optional) copy the trace file to destination
9)  (optional) using the 9.2.0 executables, use trace file to re-create

control file, renaming database
10) on destination do 'alter database recover automatic until time 'TIME NOTED IN STEP 4' using backup controlfile'

The 9.2.0 executables can read and understand log files from 8.1.7

11) on destination do 'alter database open resetlogs'
12)  On destination, perform steps for manual upgrade from 8.1.7 to 9.2.0
13) Celebrate with a couple of truely great beers (i recommend Sierra Nevada

Celebration Ale)

Good luck

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com Contrary to popular opinion, Unix is user friendly. It's just particular about who it makes friends with.

-----Original Message-----
From: Nick Wagner [mailto:Nick.Wagner_at_quest.com] Sent: Monday, March 24, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L Subject: Quick Question -- 8.1.7 logs applied to 9.2.0 database instance?

Can I take a hot backup of an 8.1.7 instance... and then upgrade the backup to 9.2.0 (upgrading data dictionary tables and everything) and then apply logs created by the 8.1.7 instance to this 9.2.0 backup?

Please answer as soon as possible...

Thanks!
Nick Wagner

<http://www.quest.com/>

------_=_NextPart_001_01C2F24B.D1BD2C60
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.3105.105" name=GENERATOR></HEAD>
<BODY>
<DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>I did
this a couple of weeks ago.  <SPAN class=933422321-24032003>The answ</SPAN><SPAN class=933422321-24032003>er is </SPAN><SPAN class=933422321-24032003>yes, but you recover</SPAN></SPAN></FONT></DIV>
<DIV><SPAN class=451251421-24032003><SPAN class=933422321-24032003></SPAN><FONT
size=2><FONT color=#0000ff><FONT face=Arial><SPAN class=933422321-24032003>first, then
upgrade.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=451251421-24032003><FONT size=2><FONT color=#0000ff><FONT
face=Arial><SPAN
class=933422321-24032003></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=451251421-24032003><FONT size=2><FONT color=#0000ff><FONT
face=Arial><SPAN class=933422321-24032003></SPAN>You've got to
</FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=451251421-24032003></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>0)
Note the sequence number of the log file being written</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>to in
the source database before you start.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>1) put
source in hot backup mode</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>2)
copy files to new destination</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>3)
take source out of backup mode</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>4)
NOTE the date/time</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>5)
'alter system switch logfile' on the source</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>6)
copy all archived log files from the one</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=451251421-24032003>   noted in the step 0 to the most recent (inclusive) to destination</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>7)
(optional) on source, do a 'alter database backup controlfile to trace'</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>8)
(optional) copy the trace file to destination</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=451251421-24032003>9)  (optional) using the 9.2.0 executables, use trace file to re-create control file, renaming database </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>10) on
destination do 'alter database recover automatic until time 'TIME NOTED IN STEP 4'  using backup controlfile'</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=451251421-24032003>     The 9.2.0 executables can read and understand log files from 8.1.7</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>11) on
destination do 'alter database open resetlogs'</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=451251421-24032003>12)  On destination, perform steps for manual upgrade from 8.1.7 to 9.2.0</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>13)
Celebrate with a couple of truely great beers (i recommend Sierra Nevada Celebration Ale)</SPAN></FONT></DIV>
<DIV><SPAN class=451251421-24032003></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=451251421-24032003>Good
luck</SPAN></FONT></DIV>
<P><FONT color=#0000ff><FONT face=Arial size=2>----<BR>Matt Adams - GE
Appliances - matt.adams_at_appl.ge.com<BR>Contrary to popular opinion, Unix is user friendly. <BR>It's just particular about who it makes friends with.
</FONT></FONT></P></DIV>
<DIV> </DIV>
<P><FONT size=2>----<BR>Matt Adams - GE Appliances -
matt.adams_at_appl.ge.com<BR>Contrary to popular opinion, Unix is user friendly. <BR>It's just particular about who it makes friends with.</FONT>
</P>
<DIV> </DIV>
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> Nick Wagner [mailto:Nick.Wagner_at_quest.com]<BR><B>Sent:</B> Monday, March 24, 2003 3:24 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Quick Question -- 8.1.7 logs applied to 9.2.0 database instance?<BR><BR></FONT></DIV>
<DIV><SPAN class=944512320-24032003><FONT face=Arial size=2>Can I take a hot
backup of an 8.1.7 instance...  and then upgrade the backup to 9.2.0 (upgrading data dictionary tables and everything) and then apply logs created by the 8.1.7 instance to this 9.2.0 backup?  </FONT></SPAN></DIV>
<DIV><SPAN class=944512320-24032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=944512320-24032003><FONT face=Arial size=2>Please answer as
soon as possible...</FONT></SPAN></DIV>
<DIV><SPAN class=944512320-24032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=944512320-24032003><FONT face=Arial size=2>Thanks! 
</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2>Nick Wagner</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV><FONT color=#000000 face=Arial size=2><A
href="http://www.quest.com/"></A></FONT></DIV></DIV> Received on Mon Mar 24 2003 - 15:24:57 CST