Does Creating archivelog_dir and onlinelog_dir Impact Disk Usage?
Question
When I set up an Oracle RDS connection and configure it to use the Binary Log Reader incremental sync method, will the following commands create directories that could impact disk usage?
BEGIN rdsadmin.rdsadmin_master_util.create_archivelog_dir; rdsadmin.rdsadmin_master_util.create_onlinelog_dir; END;
Environment
Connector: Oracle RDS
Answer
No, these commands create Oracle directory objects, which are logical pointers that give Fivetran read-only access to archived and online redo log files. Fivetran requires these directory objects because AWS doesn’t allow direct access to the underlying file system where these log files are stored.
Binary Log Reader can affect disk usage because it relies on generated redo logs. However, the directory objects themselves don't consume significant disk space or contribute to redo log storage usage.
For more information, see the Oracle documentation on DIRECTORY Objects.