RE: Database Migration and Upgrade across Servers ( from Solaris to HP)

Bala wrote:

> We have a Requirement to migrate all 10 Oracle databases (10.2.0.1)
> running on Sun Solaris Server ( Solaris 10) to HP-UX Server ( running 
> HP-UX 11i).
> 
> We want to upgrade all the databases to the latest Oracle release 
> 10.2.0.4. 
> 
> What could the most feasible approach ? -- Each of our Databases size 
> is 30 GB.

An upgrade and a platform migration are two different activities.  If you do
them at the same time, you will not necessarily know which one caused your
problems.

I would upgrade to 10.2.0.4 first using a new ORACLE_HOME and catupgrd.sql.
Some feel it is better to upgrade by importing into a new database on the
higher version, in order to achieve various goals, such as segment
reorganization and fresh odor ;-)  My feeling is that segment reorganization
and database deodorization are also activities that have the potential for
causing problems discrete from upgrade and migration, and therefore should
also be undertaken separately.

If you are moving from Solaris SPARC 64-bit to HP-UX 64-bit you are in luck.
There is no need for exp/imp, data pump or even transportable tablespaces.
Migrations between same endian platforms can be achieved with RMAN and
convert database.

Regards,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

--
http://www.freelists.org/webpage/oracle-l

Other related posts: