How to migrate a RDS Oracle to RDS Custom for Oracle?

1. Backup Your Source Database

• Use RDS Snapshots: Create a manual snapshot of your RDS for Oracle database, ensuring a consistent and recoverable point in time.
• Export Data: Alternatively, use Oracle tools like Data Pump (expdp and impdp) for logical backups if you prefer or need to filter or transform data during migration.

2. Transfer Data to RDS Custom for Oracle

• Restore from RDS Snapshot: If RDS Custom supports direct snapshot import (which might not be directly supported between RDS for Oracle and RDS Custom for Oracle), use the snapshot to create your RDS Custom database.
• Data Pump Import: More commonly, you'll transfer your data using Oracle Data Pump or similar tools to import your data into the RDS Custom for Oracle instance.

Hello,

You can migrate from RDS for Oracle to RDS Custom for Oracle using physical migration, logical migration, or a combination. Below are a few of the methods that you can select based on the size , complexity and the downtime that can be afford.

1. Oracle Datapump Export & Import
2. Oracle Datapump for Initial Load + setup Database Migration Service (DMS) for CDC
3. Database Migration Service (DMS) for Initial load and CDC
4. RMAN full , incremental backups and archivelogs for point in time reovery (Refer this link to perform RMAN tasks on RDS for Oracle)

Migrating a Database from RDS for Oracle to RDS Custom for Oracle

RDS Custom for Oracle provides more flexibility in terms of OS-level permissions and supports features that are unavailable in standard RDS. The migration strategy depends on your database size and acceptable downtime window.

Oracle RDS features may require either Enterprise Edition (EE) or Bring Your Own License (BYOL) arrangements.

Here are some of the recommended migration approaches:

1. For Databases with TDE or Specific RDS Features:
         RMAN (preferred method for TDE-enabled databases)
         Oracle GoldenGate (for near-zero downtime, though more complex and costly)
   

2. For One-time Full Migration:
        Oracle Data Pump is the most cost-effective option and supports re-mapping features
   

3. For Minimal Downtime with Ongoing Synchronization:
       AWS Database Migration Service (DMS) is recommended