Tuesday , March 19 2024

RDS to RDS Database Refresh-Oracle

 

This document covers steps involved in refreshing an Oracle database schema where source and target both are AWS RDS databases

 

Prerequisites:

RDS Instances with enough free space
EC2 Instance to perform export-import- May be referred as a Jump Instance

Note: All the expdp/impdp commands and sql connections to be triggered from EC2 instance

Database Link Creation

Create a database link on Source DB

Command

 

Note: the above link must be created in source RDS Database

Schema backup
Take the backup of the both the target and source schema.

Command:

 

Where Database_name is the TNS entry for source/target database.

This dump file will be transferred from source to target and used in import.

“Use DBMS_FILE_TRANSFER to place the exported dump file to an Amazon RDS DB instance

Command:

 

Import on target Instance

Source DB server:

“Use Data Pump to import the data file on the DB instance

Create impdp parfile and start the import.

 

Check if the schema is imported to RDS.

Command:

Loading

About Sameer Sharma

One comment

  1. Alexandre Hernandez

    thank you!!!!!!!!!

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories