Re: Migration from 8.1.5 to 9.2 RAC

Jayaraman Ashok wrote:
> Hi
> I believe that export/import is the best method to migrate from a
> single instance to a parallel server setup. Before import you need to
> create all application objects with the necessary freelists/freelist
> groups for tables/indexes. You need to have separate set of rollback
> segments for each instance. You need to configure gc* parameters for
> each datafile in the database based on the transactions that would
> afffect them. Mere moving of physical files to raw devices is not a
> good idea. You should have a separate raw slice for each datafile and
> hence plan it accordingly for future growth. Also take into account
> your controlfile growth if using rman as you would be creating raw
> files for all except archived logs. I have done this exercise while
> migrating from HP single instance to IBM parallel server setup on
> 8.1.6.3.
> Hope this helps.

I personally moved files from file sistem to logical volumes and vice-versa so i am sure it works.
BTW you have to take in account how much time is needed to export/import 8 gigabytes of data. Of course migrating from an OS to another would force you to use exprt/import but if the OS is the same why dont use phisical copies with upgrade scripts? It's outtrangeus faster Received on Fri Sep 13 2002 - 03:02:35 CDT