Oracle8i Parallel Server Setup and Configuration Guide Release 2 (8.1.6) A76934-01 |
|
This chapter describes how to convert from a single instance Oracle8i database to a multi-instance Oracle8i database using the Oracle Parallel Server Option, and how to add nodes to an existing configuration.
Specific topics discussed are:
This section explains how to enable your database structure to support multiple instances. It also explains how to begin a project with a single instance Oracle database even though you intend to migrate to the multi-instance parallel server. In addition, this chapter can help you extend an existing Oracle Parallel Server configuration to additional nodes. This sections covers the following topics:
You may decide to convert to a multi-instance database when you have designed your application with Oracle Parallel Server in mind.
Do not convert to Oracle Parallel Server in the following situations:
This section contains the following sections:
To convert to Oracle Parallel Server you must have:
Making your database run in parallel does not automatically mean you have effectively implemented Oracle Parallel Server. Besides migrating your existing database from single instance Oracle to multi-instance Oracle, you must also migrate existing applications that were designed for single-instance Oracle. Preparing an application for use with a multi-instance database may require application partitioning and physical schema changes.
Note the following administrative issues of conversion:
The following procedure explains how to migrate an existing database from single-instance Oracle to multi-instance Oracle. Remember that you must also migrate the application from single- to multi-instance.
To migrate from a single instance to an Oracle Parallel Server, perform the following tasks:
Task 2: Evaluate Tablespaces and Log Files of Single Instance
Task 4: Export Data from Old Database
Task 5: Install Operating System Dependent Files
Task 6: Install Oracle8i Enterprise Edition and Oracle8i Parallel Server
Task 8: Transfer Data From Old Data to Empty Database
See your vendor documentation for information about setting up Oracle Parallel Server hardware.
Because tablespaces must be identical on the Oracle Parallel Server as a single instance database, it is important that you do any consolidation, addition, or renaming of tablespaces on the single instance at this time.
Each additional node in the cluster requires two log files. Typically, a single instance database only has two log files. You must add additional log files for each node using the ALTER DATABASE ADD LOGFILE statement.
Create the raw devices needed for the data files, control files, and log files for Oracle Parallel Server, as explained in "Setting Up Raw Devices".
Export the entire database from the single instance database. Use a tool such as the Export utility
To use the Export utility to export all data from an existing database to the new database:
Run the Export utility:
exp username/password file=file.dmp full=y log file.log
file
.dmp
represents the data from the full database export of the database, while file
.log
represents the log of the operation.
For all nodes, see your Operating System Dependent vendor documentation for instructions about installing Operating System Dependent files.
Except on the server already running Oracle8i Enterprise Edition, install Oracle8i Enterprise Edition along with the Oracle Parallel Server option, as described in Chapter 3. If your current single instance database does not have the supporting hardware, perform a clean install on new cluster hardware.
On the server already running Oracle8i Enterprise Edition, install Oracle Parallel Server using the Custom installation type.
Create a new database on the raw partitions. Depending on the install type and subsequent configuration options, a database may be created with the following methods:
Import the entire database into the empty database. Use a tool such as the Import utility.
To run the Import utility:
imp system/password file=file.dmp full=y log file.log
file
.dmp
represents the data from the full database export of the database, while file
.log
represents the log of the operation.
See "Starting the Database in Parallel Mode" to start the Oracle Parallel Server.
If you have already configured cluster and want to add other nodes, Oracle recommends the follow procedure:
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|