On-prem Oracle to RDS Oracle SE2 migration and replication

0

Hi,

I need to migrate and create bi-directional replication from on-prem Oracle to Oracle RDS. I have used SCT for DMS migration assessment. How do I start the migration using AWS DMS is the challenge I am facing. There are multiple schemas which I need to migration and replicate. Can I use DMS for this task? DMS can not create schemas in Oracle, Do I create all required schemas first then create migration tasks?

Thank you, /AJ

3 個答案
2

This blog Migrating Oracle databases with near-zero downtime using AWS DMS provides some good technical guidance to evaluate

The solution in blog includes the following steps:

  1. Provision an AWS DMS replication instance with the source and target endpoints
  2. Export the schema using Oracle Data Pump from the on-premises Oracle database
  3. Import the schema using Oracle Data Pump into the Amazon RDS for Oracle database
  4. Create an AWS DMS replication task using CDC to perform live replication
  5. Validate the database schema on the target Amazon RDS for Oracle database

Reference : https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/

profile pictureAWS
專家
已回答 1 年前
  • Thank you Nitin! I read the blog but wondering if we can export/import schema without Oracle Data Pump? Is there a way to use AWS DMS/SCT? What steps will be required? e.g create all the schemas first on target then use DMS to migrate data?

1

Hello,

As this your planning to migrate on-premises Oracle to Amazon RDS for Oracle database, most of the native tool like datapump, also can help in migration. In case you do not have downtime window to carry out datapump export import then you may plan to use DMS replication.

In both cases, its good to create metadata first (schema, table, etc.) before importing or start replicating data.

I do no think DMS can create schema. Also pls. review https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-oracle-database-to-amazon-rds-for-oracle.html

Thanks

AWS
已回答 1 年前
0

Hello,

As suggested the best approach would be to use the native replication tools like Data pump to create the Database skeleton (metadata) and post migrate the data using the AWS DMS. Alot depends on the dynamics involved like the size , downtime and the underlying the NW bandwidth between On-premise DC and the AWS. AWS Schema conversion tool (AWS SCT) also provides capability for schema conversion between Onpremise Oracle to Amazon Oracle RDS. The steps on high level would be - Assessment -> Schema Conversion -> Data Migration.

Please refer to this workshop for your hands-on and detailed instructions # https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/oracle-oracle

AWS
SSaxena
已回答 9 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南