Move an Oracle database from on-prem to AWS : EC2 or RDS?

Now with Cloud, many customer want to move their database On-Prem to some clouds as AWS, Oracle and IBM. Here I describe the differences if you want to move your Oracle database On-Prem to Amazon AWS.

EC2: You manage the database at AWS by yourself.
RDS (RELATIONAL DATABASE SERVICE) : Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations .

Then if the customer chooses for EC2 you have these migrations options:

Migrating Oracle database to EC2:

  • RMAN backup restore
    • Platform
    • Version
  • Golden gate
  • EC2 Instance for Golden Gate
  • Zero Downtime
  • Cost
  • Database Migration Service
    • Most cost effective
    • Zero Downtime
  • Data Guard
    • Zero Downtime

Otherwise if the customer wants RDS:

Migrating Oracle to RDS:

Data Pump:

  • Cross Platform
  • Cross version

Golden Gate (additional licences)

  • EC2 instance for replicat process
  • Zero Downtime
  • Cost

Database Migration Service (most cost effective)

  • Most cost effective
  • Zero Downtime

These options also impact in some Oracle options:

Oracle Rac is not supported in RDS. (RAC: ACTIVE X ACTIVE, RDS: ACTIVE X PASSIVE)
ASM supported both EC2 and RDS.
Multitenant is not supported in RDS just EC2.
Data Guard is not supported in RDS just EC2.

Also in some application:

PeopleSoft: support EC2 and RDS;
Siebel: support EC2 and RDS;
JD Edwards: support EC2 and RDS;
ISV Applications : support EC2 and RDS
E-BUSINESS SUITE: Application who needs to access the file system which is not provided by RDS so just EC2 is supported.

Related posts

Leave a Comment