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

1回答
0
承認された回答

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.

エキスパート
回答済み 6年前

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

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

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

関連するコンテンツ