Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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

Argomenti
Migrazione e modernizzazioneAnalisiDatabase
Tag
Servizio di migrazione dei database AWSAmazon Relational Database ServiceOracle
Lingua
English
AWS
AWS-User-3953881
posta 6 anni fa640 visualizzazioni
1 Risposta
0
Risposta accettata

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.

ESPERTO
AWS-User-7019129
con risposta 6 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente