This Content Component encountered an error

Oracle on Linux tips, tutorials and expert advice

Installing and upgrading Oracle on Linux <<previous|next>> :Help for beginner installing Oracle 10g on Linux

Oracle database export, import and migration

How to migrate Oracle 10g to RAC cluster on Linux

How to migrate Oracle 10g to RAC cluster on Linux

By  Maria Anderson, Production DBA, Autodesk

SearchOracle.com

I need to migrate a single-instance Oracle database, version 10.1.0.3, on Tru64 to a RAC cluster, version 10.2, on Linux. What is the best methodology to do this?

There are three major changes happening here: one is an upgrade from Oracle 10g release 1 to release2, the next is a database move to a different platform, and the final change involves converting a single-instance database to RAC. First, you will want to decide how to upgrade your database to 10.2 as well as how to migrate it from Tru64 to Linux. A good reference is the Oracle Database 10g Release 2 (10.2) Upgrade Guide.

You have a couple of choices with respect to the upgrade:

  • Perform an upgrade in place to 10.2 (as long as your operating system is at 5.1b) and then use the cross-platform transportable tablepaces feature to move the database to the Linux server.
  • Create a new database on the Linux server and use export/import, or a database link to copy the data across.

Which option you choose will depend on how large your database is and how much of an outage you have to perform this migration. The upgrade guide discusses all of these options. For more information on transportable tablespaces, the Oracle Database 10g Release 2 (10.2) Administrator's Guide is a good reference.

After the upgrade is completed and the database has been migrated to the Linux server, then you need to consider how to configure RAC. A good place to start is to review the Oracle Database 10g Release 2 (10.2) for Linux - Oracle Clusterware and Oracle Real Application Clusters Installation Guide.

Carefully review the section titled "Converting to Oracle Real Application Clusters from Single-Instance Oracle Databases."

Another good reference is the Oracle Database 10g Release 2 (10.2) - Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide.

12 Apr 2007