Minimize downtime when migrating your Oracle database to Amazon RDS for Oracle with transportable tablespaces and AWS DMS
Database Blog
This article provides a solution for migrating Oracle databases from legacy platforms to Amazon RDS for Oracle with minimal downtime. It combines two approaches: RMAN Cross-Platform Transportable Tablespaces Backup Sets (XTTS) for full data load, and AWS Database Migration Service (AWS DMS) for incremental data sync.
Specifically, the article covers:
- Solution overview
- Prerequisites
- Setting up the source database
- Taking a full backup on the source database using XTTS
- Restoring the backup to the target database
- Taking and restoring incremental backups
- Restoring the final backup and importing metadata
- Replicating changes using AWS DMS
- Clean up steps
- Conclusion
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Mar 25
2024
2024
Demystifying AWS Backup for Amazon RDS for Oracle
Jun 21
2024
2024
Perform a two-step database migration from an on-premises Oracle database to Amazon RDS for Oracle using RMAN
Dec 17
2024
2024
Migrating Oracle Databases from Exadata to Amazon RDS for Oracle: Addressing Performance Considerations
Oct 28
2025
2025
Migrate Oracle reference partitioned tables to Amazon RDS or Aurora PostgreSQL with AWS DMS
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.