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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ