By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Support for RDS Oracle as source while using DMS SCN for CDC

0

I have a scenario where the customer would like to have a ongoing replica for an RDS Oracle (SE2) database as source to another RDS Oracle (SE2) database as target in a different region. Given the new support for SCN in DMS, can we do an offline backup and export of the source databse using Oracle native tools, and use DMS with SCN for CDC? I know this was not recommended before, but going through the documentation at https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html it looks possible. Any comments? The database has LOBs and is large at over 5-6 TB. Thanks

Topics
Migration & ModernizationAnalyticsDatabase
Tags
AWS Database Migration ServiceAmazon Relational Database ServiceOracle
Language
English
AWS
AWS-User-3953881
asked 6 years ago627 views
1 Answer
0
Accepted Answer

Yes this was possible before the native SCN support also, without the SCN support you had the option to start the CDC task using the timestamp only and the issue was that the specific timestamp there could be several SCN's associated with it . Now with Native SCN support you can specify the SCN to the CDC task.

EXPERT
AWS-User-7019129
answered 6 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content