Other: HVR - Oracle as Source - Bfile on ASM sources, read redo logs as well
Not planned
Bfile has been the preferred method of data replication for us. This is because it gives good replication speed with minimal impact on databases and does not require any superuser rights like direct method.
However, there is a drawback that for asm storage oracle sources, it cannot read redo files and only replicates from archive logs. This causes substantial latency in the data load and is not acceptable as we aim to achieve near real-time replication.
So, please enhance bfile method to enable replication from redo logs as well
-
Official comment
Hi Safoora,
Enhancing the BFILE method to read online redo logs in ASM is not technically feasible due to Oracle’s own restrictions. Oracle does not allow online redo logs stored in ASM to be read or copied using the BFILE interface or any other file-based method. A BFILE can only point to files that exist in the server’s regular filesystem. Since ASM is not a traditional filesystem, Oracle intentionally blocks any external access to files inside it, including online redo logs. As a result, it’s not possible to expose online redo logs as BFILEs or copy them out using normal OS tools. See also https://fivetran.com/docs/hvr6/requirements/source-and-target-requirements/oracle-requirements/oracle-as-source/capture-from-oracle-using-bfile#capturingarchivelogsonoraclewithasmstorage .
Best regards,
Edwin
-
Hi Edwin,
In that case, can we please have minimal permissions model for direct method of replication. User need not have sysasm admin level privilege. Let me know
Please sign in to leave a comment.
Comments
2 comments