CODEWITHSUNDEEP
oracle-databaseamazon-redshiftaws-dms
pChidambaram
pChidambaram

Reputation: 33

AWS DMS - incremental migration from Oracle to Redshift

I am new to AWS DMS service. Plans are to migrate on-prem Oracle to Redshift. Before going into production environment, currently trying out a test Oracle RDS in AWS which is a small subset of actual database as source. So far have been successful in the bulk load and incremental migration from RDS to Redshift.

When it comes to on-prem oracle , particularly for the incremental load

1) As per document : http://docs.aws.amazon.com/dms/latest/sbs/CHAP_On-PremOracle2Aurora.Steps.ConfigureOracle.html, the on-prem needs to be enabled with supplemental logging. Plans are to use the following two commands.

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

The production database has multiple logging locations. Is there any other log settings other than the above two that I should be looking into for DMS to pick up multiple log locations?

2) In the same link given, point 4 says 'Create or configure a database account to be used by AWS DMS.'

Where should I create this user? on-prem oracle or AWS? How do I configure DMS to use this user?

Upvotes: 1

Views: 970

Answers (1)

Andrew Melvin
Andrew Melvin

Reputation: 11

You need to read this documentation:

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html

For your second question; You need to create a user in the Oracle source database, the section 'Working with a Self-Managed Oracle Database as a Source for AWS DMS' tells you all of the grants you need to give.

For your first question, if you look at the SQL Server documentation;

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html

It specifies the limitation of; 'SQL Server backup to multiple disks isn't supported. If the backup is defined to write the database backup to multiple files over different disks, AWS DMS can't read the data and the AWS DMS task fails.'

I can't see a similar stipulation in the oracle documentation, first link, I would hazard a guess that DMS is able, in the case of oracle, to determine and cope with multiple logging locations from a configuration value inside the database.

Upvotes: 0

Related Questions