|
 |
|
Oracle Database Tips by Donald Burleson |
Oracle10g Grid Computing
with RAC Chapter 15 - RAC Migration
Topics
Migration Features
-
For Release
3.5 MP1 of DBE/AC for Oracle9i RAC, disk groups created on shared
volumes are not automatically configured with I/O fencing enabled. To
enable I/O fencing, the shared disk group must be deported and then
imported.If the
current database files are using the Veritas Quick I/O feature, we
should convert them to regular VxFS files before installing VERITAS
DBE/AC for Oracle9i RAC, which uses the ODM (Oracle Disk Manager) interface
for high performance file access.
-
If
the current database files are using the Veritas Quick I/O feature,
we should convert them to regular VxFS files before installing
VERITAS DBE/AC for Oracle9i RAC, which uses the ODM (Oracle Disk
Manager) interface for high performance file access.
-
Remove of
the earlier version VCS software and install patches and the new
DBE/AC packages. Follow the Veritas documentation to configure the CVM,
CFS, and VCS with default service groups. Start the cluster and keep
it running.
-
Ensure that
DB files are moved to the CFS based file system. Then perform the same
changes at the database level as explained in the previous section,
'Procedure-A' (Steps 6 to 12), to move DB files into a RAC database.
These steps convert the single instance Oracle into a multi-node RAC
database.
Packaged
Applications
When the
Oracle database supporting vendor-supplied packaged applications is
migrated or converted to a multi-node RAC database, there are specific
ways these applications can utilize the features of the RAC database.
With the multiple instances providing more scalability and high
availability at the database level, the applications need to make use
of such features. As example cases, we will briefly look at the
discipline followed in an application client environment.
In the Case
of SAP Applications
The server
side and client side configuration changes may include:
Verification
Process
Before the
database files are transferred to the target system, verify that the
Oracle database on the existing system is in the right condition for
the upgrade. Specifically for this task, SAP provides two specific SQL
scripts to perform some checks in advance of the Oracle Database 10g
database upgrade. The scripts are called checks.sql and premig.sql and
they can be found on the first RDBMS CD from SAP for Oracle Database
10g Release 10.1.
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
|