Oracle9i Real Application Clusters Setup and Configuration Release 2 (9.2) Part Number A96600-01 |
|
This chapter describes the procedures for migrating from single-instance Oracle databases to cluster-enabled Real Application Clusters databases. It also describes procedures for upgrading from Oracle8i Parallel Server to Oracle9i Real Application Clusters. The topics in this chapter are:
This section explains how to enable your single instance database to support Real Application Clusters. It also explains how to begin a project with a single-instance Oracle database and migrate to Real Application Clusters. This section covers the following topics:
See Also:
Oracle9i Database Migration for complete procedures on migrating to Real Application Clusters |
Do not migrate to Real Application Clusters if:
If your platform supports a cluster file system, then you can use it for Real Application Clusters. You can also migrate to Real Application Clusters and use a non-shared file system. To do this, copy the ORACLE_HOME
to the identical location on each node in your cluster.
To migrate to Real Application Clusters, consider both the hardware and software requirements and the administrative issues described in this section.
To migrate to Real Application Clusters you must have:
Note the following administrative issues of conversion:
This procedure explains how to migrate a database from single instance to cluster-enabled Oracle. This procedure assumes you are currently using a file system for your single instance Oracle. To use Real Application Clusters, you must migrate the database from the file system to raw devices.
If your database already uses a shared file system, review the additional notes about these procedures under the heading "Migrating with Raw Devices or Shared File Systems".
To migrate a database from a single instance to Real Application Clusters, complete the following procedures:
Task 3: Evaluate Tablespaces and Log Files of Single Instance
Task 4: Export Data from Old Database
Task 5: Install Operating System-Dependent Cluster Software
Task 6: Install Oracle9i Enterprise Edition and Oracle9i Real Application Clusters
Task 8: Import from Old Database into New Database
See your vendor documentation for information about setting up Real Application Clusters hardware.
Create the raw devices needed for the datafiles, control files, and redo log files for Real Application Cluster databases as explained in "Configuring Shared Disk Subsystems for Real Application Clusters".
Because each tablespace on the single instance database must have a matching, identical tablespace on the Real Application Clusters database, it is important that you consolidate, add, or rename the tablespaces on the single instance at this time if needed.
Each additional node in the cluster requires at least two redo log files. Typically, a single instance database only has two redo log files. Therefore, add redo log files for each node using the ALTER DATABASE ADD LOGFILE
statement.
Note:: If you are not changing operating system platforms for your database, then you do not need to perform Task 4: Export Data from Old Database and Task 8: Import from Old Database into New Database. Instead, use the |
Export the entire database from the single instance database. Use a tool such as the Export utility by entering the following:
exp username/password file=file.dmp full=y log file.log
Where file.dmp
represents the data from the full database export of the database, and file.log
represents the log of the operation.
See Also:
Oracle9i Database Utilities for further information about this tool |
For UNIX, refer to your vendor's operating system-dependent documentation for instructions about installing operating system-dependent cluster software.
For Windows NT and Windows 2000, use the Oracle-supplied preinstall tool to install the Oracle OSD clusterware.
Except on the server already running the Oracle9i Enterprise Edition, install Oracle9i Enterprise Edition along with the Oracle9i Real Application Clusters option as described in Oracle9i Real Application Clusters Setup and Configuration.
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 Oracle9i Enterprise Edition, install Oracle9i Real Application Clusters using one of the preconfigured database configuration types.
Create a new database on the raw partitions. Depending on the install type and subsequent configuration options, you can create a database with the following methods:
Import the entire database into the empty database using 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.out
represents the log of the operation.
See Also:
Oracle9i Database Utilities for more information about this tool |
You should make the following parameter changes to accommodate Real Application Clusters:
INSTANCE_NUMBER
parameter to a unique value for each instance.DB_CACHE_SIZE
and DB_
nK_CACHE_SIZE
parameters accordingly.
See Also:
Oracle9i Database Performance Tuning Guide and Reference for more details about optimizing your memory configuration |
For more information on this procedure, refer to Oracle9i Real Application Clusters Administration.
If your database is already using raw devices on shared disk storage, or if you are using certain operating system file system architectures that are vendor-provided, then you do not have to rebuild the database as described in the previous procedures. Instead:
The procedure in this case is much simpler than the procedure described in "Migrating Databases from Single Instance to Cluster-Enabled Environments". The process may only require that you execute an operating system copy
command to move your files to a new location, rather than having to rebuild the database.
See Also:
Oracle9i Database Migration for procedures for upgrading from Oracle 7.3, Oracle 8.0, and Oracle8i to Oracle9i release 2 (9.2) |
If you are upgrading from Oracle8i Parallel Server to Oracle9i Real Application Clusters, upgrade your configuration information using the following post-installation procedure. Do this for each Real Application Clusters database:
gsdctl stop
command.
conf
file is located:
srvconfig -conv $Oracle_Home/ops/db_name.conf
The environment variable referred to in this example is an Oracle8i environment variable.
|
Copyright © 1998, 2002 Oracle Corporation. All Rights Reserved. |
|