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.
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)