Does DMS support Oracle Logical Standby hosted on EC2 as source for full load and CDC migration to AWS RDS?

Question

Does DMS support oracle logical standby hosted on EC2 as source for full load and CDC migration to RDS supported target engines. If this is supported configuration, are there any gotchas/limitations to use Oracle logical standby as source for DMS for full load and CDC?

Answer

Hi,

[Our docs ](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html)go into this a bit further but AWS DMS currently supports only Oracle Active Data Guard Standby and you will need to use Binary Reader in DMS as LogMiner will not work.

| For this workflow step | If you perform CDC using LogMiner, do this| If you perform CDC using Binary Reader, do this |
| --- | --- | --- |
| Configure Oracle Standby as a source for CDC. | AWS DMS doesn't support Oracle Standby as a source. | See [Using a self-managed Oracle Standby as a source with Binary Reader for CDC in AWS DMS.](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.Self-Managed.BinaryStandby) |

Does DMS support Oracle Logical Standby hosted on EC2 as source for full load and CDC migration to AWS RDS?

Relevant content