Migration from 8.1.5 to 9.2 RAC

From: Igor Smaglyuk 1293309929 <siv_at_emt.com.ua>
Date: Thu, 12 Sep 2002 10:48:14 +0300
Message-ID: <1031816919.9372@fobos.ldc.net>

Hi, ALL!

I have Oracle 8.1.5 on Linux Red Hat.
And I have to migrate the database to Oracle 9.2 Real Application Cluster. The current
volume of data is about 8 Gb. I can stop the database only for 10 hours.

I can see 2 ways of doing this.

Export from 8.1.5 and import to 9.2 RAC. It seems to me the best solution, but it will take much more time then 10 hours. So it is unacceptible.
Upgrading 8.1.5 to 8.1.7 using Upgrade Assistant . Them upgrading 8.1.7 to 9.2 single using Upgrade Assistant . And then migrating from 9.2 single to 9.2 RAC. Every step should last no longer 10 hours.

And there is a question how to migrate from 9.2 single to 9.2 RAC. Will it be enough to install 9.2 RAC and to use unix dd command to transfer datafiles of 9.2 single database to the corresponding raw devices of 9.2 RAC database? What to do with the SYSTEM tablespace?

May be there are another ways of migration from 8.1.5 to 9.2 RAC?

Igor. Received on Thu Sep 12 2002 - 02:48:14 CDT