Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

Converting from Single-Instance to 10g RAC

This section will describe the following procedures:

• Conversion of a single instance on a Non-Clustered system to Oracle Database 10g with RAC.
   

• Conversion of a single instance on a Cluster to Oracle Database 10g RAC.
   

Single Instance on a Non-Clustered System to Oracle Database 10g with RAC

Conversion from a single-instance, non-clustered database to a clustered RAC system involves the following procedures, performed in the order given:

• Backup the original single-instance database
   

• Perform the required pre-installation steps
   

• Set up the cluster environment
   

• Copy the preconfigured database image into the cluster
   

• Install the Oracle Database 10g RAC software

Let's look at each of these procedures.

Duplication of the Original Single-Instance Database

It is suggested that you utilize the Database Creation Assistant (DBCA) to create a preconfigured image of your single-instance database. This is accomplished by invoking the DBCA from the bin directory under ORACLE_HOME and then following the menu path:

Welcome Manage Templates > Create a database template [select From an existing database (structure as well as data)] > Database Name [select the database name] > Template Name [enter template name, use database name as the default, and description and template datafile location] > Finish. The DBCA will then generate two files:

•  The database structure file (template_name.dbc)
   

• The database preconfigured image file (template_name.dfb)

By default, these files are generated on UNIX in the ORACLE_HOME/assistants/dbca/templates directory and in the %ORACLE_HOME%\assistants\dbca\templates directory on Windows-based systems.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle 10g Grid & Real Application Clusters", by Rampant TechPress.  Written by top Oracle experts, Mike Ault and Madhu Tumma, this book has a complete online code depot with ready to use scripts. 

To get the code instantly, click here:

http://www.rampant-books.com/book_2004_1_10g_grid.htm