S3 Integration Oracle RDS and DMS

0

hello

Im trying out a migration approach where a oracle database backup has been exported to an S3 bucket.

I created my target Oracle RDS instance with S3 Integration option. I Imported the oracle dump from S3 using S3 integration import command and run data pump to restore the database to my target Oracle RDS. I then run DMS to sync the delta from the source database using an SCN starting point which was provided after the dump was created.

So far it looks good and my Oracle RDS is able to sync the delta changes after the dump was created. I used a small database data for this demo.

I want to get some insights on this approach and if you would still recommend using DMS when importing data from S3 instead of S3 integration? I like how this approach I used where I never have to manually create table objects. It would be good if someone can point out some AHAs! I might be missing? or was there someone who did a similar approach before on a production environment?? thanks

1개 답변
2
수락된 답변

I believe it is good to use db dump to create Oracle db schema because DMS is using minimalist approach, so it doesn't create all schema structures that you will need. Then using DMS to sync data, for Oracle db make sure that you replicate all applications schemas (developers tend to create multiple schemas for an application) and in case of 12c or later versions make sure that all pluggable databases used by the application are migrated.

AWS
중재자
답변함 4년 전
profile picture
전문가
검토됨 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠