||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 3 - High
Performance and Highly Available
As we noticed in the above examples, the
database instance has been freshly started after required resources
are online. It is a mutually exclusive condition in which the
database instance resides on a primary node or on a backup node.
Normally the Fail-Over cluster is implemented
in two types of architectures. They are Active/Passive architecture
and Active/Active architecture.
Active/Passive Clusters – This type comprises
two near identical infrastructures, logically sitting side-by-side.
One node hosts the database service or application, while the other
rests idly waiting in case the primary system goes down. They share
a storage component, and the primary server gracefully turns over
control of the storage to the other server or node when it fails. On
failure of the primary node, the inactive node becomes the primary
and hosts the database or application.
Active/Active Clusters – In this type, one node
acts as primary to a database instance and another one acting as
secondary node for fail over purpose. At the same time, the
secondary node acts as primary for another instance and the primary
node act as the backup/secondary node.
Fig. 3.9 shows an example of active / active
Figure 3.9 Two Node Cluster with Active
/Active Resource groups
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