Feature: create agent to run on database host about openlogreplicator HOT 3 OPEN

This feature is complicated to implement.. If there is a demand from users more focus could be given here.

from openlogreplicator.

Regarding the feature request to create an agent capable of operating on the database host, I'd like to propose an alternative approach that could simplify the implementation and enhance compatibility across different infrastructure configurations. Instead of developing an agent to externally transfer redo log files, why not leverage the native connection interfaces of the Oracle database to access the archive log files directly?

Utilizing a directory object within Oracle itself or accessing directly via the ASM instance are feasible techniques that could allow for efficient file reading. This approach would simplify data transfer and pave the way to support more complex topologies in the future, such as Grid Infrastructure and Oracle RAC. I believe this solution could offer significant flexibility and potentially ease implementation challenges, aligning with the needs of users facing restrictions on direct access to redo log files.

Given the importance of adapting OpenLogReplicator to diverse environments and the current limitations on external file access, this proposal could represent an important step towards a more universal and accessible solution. I am open to discussing this possibility further and exploring how this integration could be technically achieved, aiming to maximize the adoption of OpenLogReplicator across a wider range of scenarios.

from openlogreplicator.

Thank you very much @marlon-costa-dc for a valid point. Indeed this is a must have for any cdc source replication tool. But this approach is different and deserves a separate ticket. I have created #103.

from openlogreplicator.