Q

How to migrate Oracle 10g to RAC cluster on Linux

What's the best way to migrate a single-instance Oracle database, version 10.1.0.3, on Tru64 to a RAC cluster, version 10.2, on Linux?

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.

This was first published in April 2007
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close