||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 3 - High
Performance and Highly Available
Issues with FO Clusters – Hidden Risks
Maintenance and backup is a challenge. In
the case of an active/active architecture for a database
cluster, the executables and other related files that you store
on local storage have to be kept synchronized. Any mismatch of
executables or patches might have an effect on the start up of
the standby database during the fail over process.
Configuration of the critical resources
that make up resource or service group is very significant and
careful thought has to be given to the design configuration.
Dependencies have to be accurately reflected, for example, in a
service group, MQ Series, the database instance and Listener are
defined as critical resources. In this situation, even if MQ-series
fails for any reason, the database instance and listener are
brought down or failover unnecessarily.
So far, we have covered many details about the
FO Clusters and Database deployment and failure process. Now let us
move on to basic features of parallel scalable clusters.
Parallel Database Clusters
The Parallel Clustered Database (PDB) is a
complex application, which provides access to the same database,
(group of data tables, indexes and other objects) from any server in
the cluster concurrently without compromising on data integrity.
Well known examples include Oracle Real Application Cluster (Oracle
RAC), the subject matter of this book, IBM UDB DB2 Enterprise
Extended Edition (EEE) and IBM S/390 Parallel Sysplex Clusters.
Parallel Databases typically contain multiple
nodes (or servers) accessing the same physical storage or data
concurrently. PDB Architecture allows multi-server data sharing
technology, allowing direct, concurrent read/write access to shared
data from all the processing nodes in the parallel configuration.
This, however, necessitates complex lock management to maintain the
data integrity and resource coordination.
In terms of storage access type, a Parallel
Clustered System is implemented in two ways, the Shared Nothing
Model and the Shared Disk Model.
For more information,
see the book
Grid and Real Application Clusters 30% off if you
buy it directly from Rampant TechPress .
Written by top Oracle
experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
Oracle Consulting Services
Burleson Oracle Consulting offers Senior Oracle consultants which are available
for all areas of Oracle support. Common Oracle consulting support
activities include short-term Oracle tuning, Oracle database troubleshooting,
Oracle9i and Oracle10g migration,
Oracle9iAS App Server
consulting, Oracle design reviews and
Oracle requirements evaluation support. Oracle support and Oracle consulting
services are priced by the hour, so you only pay for what you need. These
one-time Oracle consulting services commonly include:
Answering questions from your Oracle DBA technical staff
Repairing down production Oracle database systems
One-time Oracle tuning evaluation
Guru support for your Oracle DBA
Installation of Oracle application packages
For more information, please visit