Oracle Real Application Clusters (Oracle RAC) is the only solution to build an active – active cluster using
shared storage for your Oracle database. Up to Oracle 18c RAC is available as a feature within
Standard Edition 2 (SE2) and comes as an extra-cost option with Enterprise Edition.
Oracle RAC typically protects your database against node failure. It does not protect your database against
storage failure (it is shared by two nodes) or against human errors.
As from Oracle 19c (corresponding with 22.214.171.124 in the old version numbering!), Oracle announced that
RAC will no longer be supported / allowed within Standard Edition 2. It will still be
available as an extra-cost option within Enterprise Edition.
Removing Oracle RAC from Standard Edition 2 brings customers using RAC on Standard Edition 2 a
new challenge: configure a high available database environment without RAC.
Oracle and high availability
Let us have a look at what the options are. The first questions you should ask yourself:
– What are your business requirements?
– Why did you choose RAC on SE2? To perform patching operations online? To protect against
what kind of failure (instance, host failure etc)?
In the paper we describe six alternative solutions, their pros and their cons:
- Configure active – passive cluster using Oracle clusterware
- Configure active – passive cluster using operating system clustering
- Configure active – passive cluster using Oracle VM
- Move to the Oracle cloud
- Configure disaster recovery using Dbvisit Standby
- Upgrade to Enterprise Edition