Migrate an on-premises Oracle database to Amazon RDS for Oracle - AWS Prescriptive Guidance

Migrate an on-premises Oracle database to Amazon RDS for Oracle

Created by Baji Shaik (AWS)

R Type: Replatform

Source: Databases: Relational

Target: Amazon RDS for Oracle

Created by: AWS

Environment: PoC or pilot

Technologies: Databases; Migration

Workload: Oracle

AWS services: Amazon RDS

Summary

This pattern describes the steps for migrating on-premises Oracle databases to Amazon Relational Database Service (Amazon RDS) for Oracle. It describes two options for migration: using AWS Database Migration Service (AWS DMS) or using native Oracle tools such as Oracle Data Pump import/export and Oracle GoldenGate.

Prerequisites and limitations

Prerequisites

  • An active AWS account

  • An Oracle database in an on-premises data center

Limitations

  • Database size limit: 64 TB

Product versions

Architecture

Source technology stack

  • On-premises Oracle databases 

Target technology stack

  • Amazon RDS for Oracle

Source and target architecture

Using AWS DMS:

Using native Oracle tools:

Tools

  • AWS DMSAWS Database Migration Service (AWS DMS) helps you migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), or between combinations of cloud and on-premises setups. For information about the Oracle database versions and editions that are supported, see Using an Oracle Database as a Source for AWS DMS.  

  • Native Oracle tools - Oracle Data Pump import/export, Oracle GoldenGate

Epics

TaskDescriptionSkills required
Validate the versions of the source and target databases.

DBA
Identify the hardware requirements for the target server instance.

DBA, SysAdmin
Identify storage requirements (storage type and capacity).

DBA, SysAdmin
Choose the proper instance type based on capacity, storage features, and network features.

DBA, SysAdmin
Identify the network access security requirements for the source and target databases.

DBA, SysAdmin
Identify the application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Create a virtual private cloud (VPC).

SysAdmin
Create security groups.

SysAdmin
Configure and start an Amazon RDS DB instance.

SysAdmin
TaskDescriptionSkills required
Use native Oracle tools or third-party tools to migrate database objects and data.

These tools include Oracle Data Pump import/export and GoldenGate.

DBA, SysAdmin
TaskDescriptionSkills required
Migrate the data with AWS DMS.

DBA
TaskDescriptionSkills required
Follow the application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Switch the application clients to the new infrastructure.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Shut down the temporary AWS resources.

DBA, SysAdmin
Review and validate the project documents.

DBA, SysAdmin, App owner
Gather metrics for time to migrate, percentage of manual vs. tool, cost savings, etc.

DBA, SysAdmin, App owner
Close out the project and provide feedback.

References

Tutorials and videos