7 Options for Migrating Oracle SE2 & RAC to 19c
Real Application Clustering (RAC) is no longer supported on Oracle 19c. However, our Database Experts have assembled 7 options for migrating Oracle SE2 & RAC to 19c.
Real Application Clustering (RAC) is no longer supported on Oracle 19c. However, our Database Experts have assembled 7 options for migrating Oracle SE2 & RAC to 19c.
Introduction
Key benefits of SE2
A benefit of having an Oracle Standard Edition 2 (SE2) licence is the ability to utilise Oracle Real Application Clusters (RAC), which allows you to achieve high availability as it binds together multiple servers to operate as a single system.
Another benefit is that SE2 can be licenced for 2 sockets, which with current processing power is generally enough to run many workloads.
But since the release of Oracle Database 19c, Oracle RAC is no longer available with SE2.
Why upgrade to version 19c?
The latest database version (19c) comes with a range of vital security features. Increased database security is always welcome, but the removal of RAC does pose the question:
Do you stay on an older version for RAC’s business continuity features, or do you look at other options?
So, what are the options?
At Xynomix we appreciate that every organisation’s needs differ. Our expertise and flexibility mean that our consultants can find the solution that best suits your needs.
With this in mind, we’ve collated 7 options for migrating Oracle SE2 & RAC to 19c.
Option 1
Remain on the current version of SE2
- Oracle 18c still supports RAC, so you may wish to minimise the impact to your RAC configuration.
- However, consider that Oracle support for 18c has ended as of June 2021. This means no more quality of life additions or critical security updates.
- Consider converting your RAC database to a non-RAC database (single instance prior to upgrading to 19c.
What features are available on SE2 19c?
Included
- JServer JAVA Virtual Machine
- Oracle Application Express
- Oracle Database Catalog Views
- Oracle Database Java Packages
- Oracle Database Packages and Types
- Oracle Multimedia
- Oracle Text
- Oracle Workspace Manager
- Oracle XDK
- Oracle XML Database
- Spatial
Excluded
- OLAP Analytic Workspace
- Oracle Database Vault
- Oracle Label Security
- Oracle OLAP API
Option 2
Upgrade to Enterprise Edition
RAC now is available as a feature of the Oracle Enterprise Edition (EE) licence. You can do this by migrating to or purchasing EE licences to preserve your Oracle RAC database.
However upgrading to EE to take advantage of Real Application Clusters (RAC) should not be the only driver. EE has a host of other features, including no-cost options that that may equally provide the HA (High Availability) / DR (Disaster Recovery) strategy you are looking to achieve. RAC within EE is a chargeable addition.
Data Guard is arguably one of the most proficient features of EE, allowing for the creation and deployment of an advanced HA / DR solution, offering:
- Synchronised copy of production databases, transactionally consistent with primary
- Fast repair of computer outages, human intervention, data corruption, etc.
- Redo application, transport and transitions
- Configurable automatic failover configurations
RMAN - Oracle Recovery Manager
RMAN (Oracle Recovery Manager) in conjunction with Data Guard will in the majority of cases provide a sophisticated HA / DR solution that guarantees zero data loss at the database level.
Other options:
Advanced Data Guard is a chargeable feature of EE that provides an advanced layer of database integrity, designed to improve production database performance for critical transactions. Featuring read-only access to a physical standby database while Redo Apply is active, queries and reports can be moved away from the production system to a synchronized physical standby database.-
The Maximum Availability Architecture (MAA) is Oracle’s best practice methodology in which all options can be discussed in conjunction with your company’s Recovery Point Objectives (RPO) / Recovery Time Objectives (RTO) to ensure results are matched to budgets.
Option 3
Utilise DBVisit Standby
Should you find that migrating to or purchasing EE licences is not your preferred option then you may wish to consider Dbvisit Standby.
Xynomix have worked with Dbvisit for years, using their software as an alternative to RAC on SE2.
Dbvisit Standby is a disaster recovery tool, allowing a standby Oracle database to mirror changes made to the primary database.
There are minor risks of data loss at database level,
so guaranteeing zero data loss will require an alternative solution.
Option 4
Standard Edition High Availability (SEHA)
Standard Edition High Availability (SEHA) was released in 2020 and allows for cluster-based failover for a single-instance Oracle Database utilising Oracle Clusterware.
SEHA uses existing cluster capabilities and storage solutions that already exist in Oracle Grid Infrastructure, such as Oracle Clusterware, Oracle Automatic Storage Management (Oracle ASM) and Oracle ASM Cluster File System (Oracle ACFS).
Option 5
Migrate to Oracle Cloud Infrastructure (OCI)
Migrate to Oracle Cloud Infrastructure (OCI)
Oracle Cloud infrastructure (OCI) is scalable, faster, and reduces reliance on normal infrastructure, including RAC. Oracle Cloud can be seen as the easy upgrade path for a wide array of applications that need predictable costs, with state-of-the-art reliability from the hyperscaled Cloud operators.
When migrating with OCI, it’s possible to spread the costs, ensuring that you only pay for the period that the systems are running. If after a while you would like to stop, you can just cancel the bill.
Option 6
Move to Oracle Autonomous Database
Move to Oracle Autonomous Database
- Convert SE RAC database to an Autonomous
- Database Autonomous uses RAC-enabled Oracle EE by default
- SLA 99.995% uptime = less than 30 mins downtime per year
Self-reparing, self-securing, automated failure detection & failover, and straightforward scaling are just a handful of advantages offered by the Oracle Autonomous Database option.
Option 7
Oracle Database Appliance (ODA)
ODA is a great option for the company facing the dilemma of upgrading beyond SE2 18c with the removal of the RAC options. The release of Standard Edition High Availability for 19c combined with an Oracle ODA is the ideal solution.
Oracle ODA is a turnkey hardware solution engineered by Oracle, for Oracle. In our experience, it provides a greater price performance against other hardware options.
Supported by Xynomix
Got any questions? Email us at [email protected]
or give us a call on 0345 222 9600.