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

Adams, Matthew (GECP, MABG, 088130) Mon, 24 Mar 2003 14:15:04 -0800

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 - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.
It's just particular about who it makes friends with.

-----Original Message-----
From: Nick Wagner [mailto:[EMAIL PROTECTED]
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

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

Reply via email to