Moving Oracle to the cloud: RDS for Oracle and Oracle Database@Azure, AWS and Google Cloud

An Oracle database can now run as a managed service on all three large clouds. The options differ a lot in what they allow, how they are licensed and how close they are to your current installation. This guide gives an overview, explains the version question, and lists the migration tools.

Start with the version

Oracle 11g and 12c have long been out of support, and 18c and 21c have also reached or are nearing their end. The long-term releases are Oracle Database 19c and Oracle Database 23ai, which continues as Oracle AI Database 26ai (release 23.26). A move to the cloud is usually combined with an upgrade to one of those two.

From Oracle 21c onwards, only the multitenant architecture (a container database with pluggable databases) is supported. A database that still uses the old non-CDB architecture has to be converted to a pluggable database along the way. Direct upgrades to 19c are possible from 11.2.0.4, 12.1.0.2, 12.2 and 18c; to 26ai only from 19c and 21c, so older releases need an intermediate step. Oracle's AutoUpgrade tool automates most of the steps.

The options

  • Amazon RDS for Oracle: Oracle as a managed service on AWS, with automatic backups, patching and Multi-AZ failover. Versions 19c, 21c and 23ai/26ai. You do not get SYSDBA or access to the operating system.
  • Oracle Database@Azure, Oracle Database@AWS and Oracle Database@Google Cloud: Oracle Exadata infrastructure, operated by Oracle, inside the data centres of the cloud provider. The database runs on the same technology as in Oracle's own cloud, including Real Application Clusters, with low latency to the applications in that cloud. Versions 19c and 23ai/26ai.
  • Oracle on a virtual machine (Amazon EC2, Azure VM, Compute Engine): full control and every feature, but you manage it yourself, and licensing on third-party clouds has its own rules.

What changes on Amazon RDS for Oracle

RDS for Oracle runs a real Oracle database, so SQL and PL/SQL keep working. The limitations are in administration: no SYSDBA, no operating system access, and tasks such as directory management, Data Pump and tablespace operations run through RDS-specific procedures. Code that writes files on the server, calls external programs or relies on some database options may need changes. Storage goes up to 256 TiB with additional storage volumes.

When Oracle Database@ makes sense

Oracle Database@Azure, @AWS and @Google Cloud suit databases that need Exadata performance or Real Application Clusters, or that use features a managed service like RDS does not offer. Compatibility with an existing Exadata or on-premises installation is the highest of all options. The service is bought through the cloud provider's marketplace, which lets you use existing cloud commitments.

Migration tools

  • Oracle Data Pump for an export and import, via Amazon S3 for RDS for Oracle
  • RMAN backup and restore, to a virtual machine
  • Oracle Zero Downtime Migration (ZDM), Oracle's tool for migrations to Exadata and the Oracle Database@ services
  • Oracle GoldenGate or AWS DMS with change data capture, to keep the new database in sync until the switch-over

How the free scan helps

The scan has a read-only script for Oracle that collects the structure of your schemas: tables, columns, indexes, PL/SQL objects and which features they use. Paste the result and compare Amazon RDS for Oracle, the Oracle Database@ services and your own server, or a move to PostgreSQL. The analysis runs in your browser and nothing is uploaded.

Questions

Which Oracle versions does Amazon RDS for Oracle offer?

Oracle Database 19c, 21c and 23ai/26ai, with end dates per version announced by AWS. 19c and 23ai/26ai are the long-term releases.

What is the difference between RDS for Oracle and Oracle Database@AWS?

RDS for Oracle is a managed service run by AWS on standard cloud infrastructure, with limited administration rights. Oracle Database@AWS is Oracle Exadata, operated by Oracle inside AWS data centres, with full Oracle functionality including RAC.

Do I need to upgrade before moving?

Usually yes: the managed services only offer 19c and later. The upgrade can be part of the migration, for example with Data Pump or ZDM.

Can I leave Oracle altogether?

Yes, PostgreSQL is the most common alternative. The scan shows for each object what needs conversion, so you can compare a move to PostgreSQL with a move to Oracle in the cloud.

Compare the cloud options for your own Oracle database: run the read-only script, paste the result and see the issues per target. Free, and nothing leaves your browser.

Start the free scan