Configure Replicate to delete archived redo logs from Alternate Archived Redo Logs destination Id

[ubanerjee]

HI,

We have configured an Alternate Archived Redo Logs Destination in our Oracle Database. This secondary copy of the archive logs is meant for use with replicate only as shown in the diagram below. 

 This will allow Oracle to write the logs and We want replicate to delete the archive logs once it is done loading into Log Stream. The CDC Process succeeds as expected.  

We enabled the Delete processed archived redo log files as shown below.

However the log files are not being deleted from the secondary location. Is there some additional configuration that we are missing? 

All GRANTS to the asm user done as per the install guide. 

[john_wang]

Hello @ubanerjee ,

In your configuration the redo log files will not be deleted. Replicate will not delete/write to Oracle original redo log files, whatever it's managed by ASM, or locate on regular OS file system.

However, if you enable option "Copy redo logs to temporary folder" (Replicate will copy redo logs from ASM to a temporary folder which locates on Oracle server. and you need not setup an additional DEST ID), then "Delete processed archived redo log files" takes action - it will delete the 'copied' redo log files after consumed it completely. Again, the original ASM redo logs will not be deleted.

You can get detailed usage from Replicate 7.0 user guide page 361 , section "Setting advanced connection properties using Replicate Log Reader".

BTW, enabling "Copy redo logs to temporary folder" speeds up the ASM redo log files process performance, it's recommended solution if you want to tune the read performance.

Hope this helps,

Regards,

John.