Hi Sanjay,
I do not have DMS here, but Qlik Replication which would also read the
archived redo logs and online redo logs from ASM to transport to Snowflake.
Similar scenario, different tools.
What we did was to set a secondary archivelog destination by setting
log_archive_dest_3 to a NFS share and then pointed Qlik Replication to read
from there. With the redo logs we couldn't do the same thing as it would
affect database performance, so the BI team has a delay based on
archive_lag_target interval.
In your case it is a migration, so you need the online redo logs. You can
create a member for each redo log group in ACFS and then DMS can read from
there. I would expect a performance penalty due to the ACFS layer, but
shouldn't be much. You have to test and measure the impact on your own. It
should work.
I hope it helps.
Regards,
[image: LORE DATA]
Franky Weber Faust
Consultor de Banco de Dados | LORE DATA
Oracle ACE ♠️
Fone: *47 99125 2714*
Email: franky@xxxxxxxxxxxxxxx
loredata.com.br
On Thu, Aug 4, 2022 at 11:01 AM Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Can we have Redo logs on both ASM and ACFS/NFS? If this works then will
see if AWS DMS can use ACFS/NFS to read the online log and avoid ASM sysasm
role. Any comment
Tx
Sanjay
On Wednesday, August 3, 2022 at 02:38:42 PM EDT, Jeremiah Wilton <
jcwilton93@xxxxxxxxx> wrote:
Hi Sanjay,
What O/S and database version are you moving from? On AWS, what are you
moving to? Self-managed Oracle on EC2? RDS Oracle? Some other database like
Postgres?
If it's just Intel Linux Oracle on prem to Oracle on EC2, you can just use
standby database, no need for DMS.
Thanks
Jeremiah
On Wed, Aug 3, 2022 at 11:27 AM Rajeev Prabhakar <rprabha01@xxxxxxxxx>
wrote:
Sanjay,
For ACL, does this oracle
support document help ?
Doc ID 1596265.1
Rajeev
On Aug 3, 2022 at 12:25 PM, <Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>>
wrote:
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?
Tx
Sanjay
