Migrate on-prem Oracle 12c Database to AWS RDS 19c instance

Name: Migrate on-prem Oracle 12c Database to AWS RDS 19c instance
Rating: 4.4 (24 reviews)

Learn step-by-step how to migrate Oracle 12c to AWS RDS 19c using Data Pump export/import

Created byHamid Ozair

Last updated 5/2025

English

What you'll learn

Understand the key differences between Oracle 12c on-premises and AWS RDS 19c.
Prepare an Oracle 12c database environment for migration.
Perform an AWS RDS setup and configure the target Oracle 19c instance.
Use Oracle Data Pump expdp/impdp effectively for database migration.
Handle pre-migration tasks such as user management, schema analysis, and object dependencies.
Ensure data integrity and validate the post-migration Oracle RDS environment.
Understand the S3 integration in RDS instance
Understand the Parameter and Option groups

Course content

1 section • 17 lectures • 1h 10m total length

Course Overview2:49
Create s3 Bucket1:22
Create s3 Bucket Policy2:52
Create IAM Role1:40
Create RDS Parameter Group1:37
Create a custom parameter group for the BTS Oracle 19c instance to modify SGA, cursor sharing, and other parameters, since default groups cannot be modified.
Create RDS Option Group1:24
Create AWS RDS 19c instance31:03
Learn how to create an Oracle 19c AWS RDS instance from the console, configuring storage, instance class, public access, and enterprise edition options for a cost-conscious dev/test setup.
Attach IAM Role to RDS Instance1:16
Connect RDS instance with TNS service name4:02
Connect RDS Instance directory without TNS service name1:24
Export on-prem Oracle 12c with Data Pump5:06
Install AWSCLI on the Linux server to run AWS commands1:27
Upload Data Pump dump files to s3 Bucket3:41
Download Data Pump Dump files from s3 Bucket into RDS instance1:35
Create Tablespaces in RDS instance before running import1:55
Import Data into RDS using Data Pump import3:24
Perform RDS database Validation by comparing with on-perm database3:49

Requirements

Basic understanding of Oracle Database
Basic understanding of AWS RDS instance
Account in AWS
A 64-bit Windows PC with 12GB of memory and 80GB of free disk space

Description

Are you looking to migrate your on-premise Oracle 12c database to the cloud using Amazon RDS 19c? This hands-on course provides a complete, step-by-step guide to successfully perform the migration process using Oracle Data Pump expdp/impdp

Whether you're a Database Administrator (DBA), Cloud Engineer, or IT professional exploring AWS, this course walks you through the practical details and best practices of cloud migration using real-world scenarios.

We’ll cover everything from setting up your AWS RDS instance to exporting and importing data, handling schema-level migration, and validating post-migration integrity.

No prior AWS experience is required, but a basic understanding of Oracle databases and Linux command line is recommended. By the end of the course, you'll be able to confidently migrate Oracle databases to AWS RDS using data pump for future migrations.

What You Will Learn

Key differences between Oracle 12c (on-prem) and Oracle 19c in AWS RDS
Setting up AWS RDS for Oracle 19c
Preparing Oracle 12c for migration
Exporting data using Oracle Data Pump (expdp)
Importing data into AWS RDS 19c (impdp)
Perform an AWS RDS setup and configure the target Oracle 19c instance.
Handling pre- and post-migration validation
Monitoring, troubleshooting, and performance tuning
Creating a par file from the Data export
Crating a par file for the data pump import

Who this course is for:

Students who want to learn how to migrate Oracle database into AWS RDS
Students who want to learn how to upload and down objects from s3 bucket
Students who want to learn how AWS Roles and Poplices work