Message-Id: <24765.322940@fatcity.com> From: "Adams, Matthew (GECP, MABG, 088130)" Date: Mon, 24 Mar 2003 16:24:57 -0500 Subject: RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database instan 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@appl.ge.com Contrary to popular opinion, Unix is user friendly. It's just particular about who it makes friends with. ---- Matt Adams - GE Appliances - matt.adams@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@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 ------_=_NextPart_001_01C2F24B.D1BD2C60 Content-Type: text/html; 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@appl.ge.com
Contrary to popular opinion, Unix is user friendly.
It's just particular about who it makes friends with.

----
Matt Adams - GE Appliances - matt.adams@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@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