AWS DMS with ASM database
From: Sanjay Mishra <"Sanjay>
Date: Wed, 3 Aug 2022 16:25:38 +0000 (UTC)
Message-ID: <1762620656.249925.1659543938174_at_mail.yahoo.com>
Date: Wed, 3 Aug 2022 16:25:38 +0000 (UTC)
Message-ID: <1762620656.249925.1659543938174_at_mail.yahoo.com>
Hi
Has anyone used Oracle migration to AWS using DMS where Oracle is using ASM storage? We have over 100s of the database on share ASM storage and moving only a few to AWS. DMS tool needs SYSASM access which can be a security issue as ASM is shared with multiple other databases.So need some opinion on the following 1. Can we create some ACL kind of permission to create ASM user and restrict the access to only set of files like Arch/Redo destination ?2. Is it good to move Redo/Arch for AWS migration to ACFS or NFS ? Any pros and cons?
TxSanjay
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 03 2022 - 18:25:38 CEST