Re: Migration from 8.1.5 to 9.2 RAC

> 2. 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.
>

It seems there arent other solution 2 upgrade from 8.1.5 to 9.2 because 9.2 doesnt have any script to upgrade from 8.1.5 so it seems you have to upgrade to 8.1.7 before, if you have an 8.1.7 installation. It should takes 1/2 hour or so.

> 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?

You could migrate directly from 8.1.7 to 9.2 RAC... i Dont see any reason to upgrade to 9.2 and then to RAC. About your question i copied data from raw devices (well...volume manager volumes) to file system, used the database for a while and then to raw devices again and i havent got any problem...you have just to stop all the instances in cluster, copy the files from filesystem (system tablespace,controlfiles, redolog files and so on) on your shared disks with dd command, then you can do the upgrade. If migration manager would fail in some way, always remember that migration scripts are located in $ORACLE_HOME/rdbms/admin on the target oracle home and they are name u[release you are upgrading from].sql so for you u0801070.sql and they should be ran under the sys user (you can find some infos on the header of your script file). Anyway remember that if your are upgrading from single instance to parallel instance you should have a redo log thread for instance, so maybe you would have to rebuild the control file.

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

Dont think so but i dont kn ow everything :) Received on Thu Sep 12 2002 - 05:08:23 CDT