Capture From Oracle Using LogMiner
Capture from Oracle using the LOGMINER method will be deprecated in one of the future HVR 6 releases. We encourage you to consider migrating to BFILE or DIRECT capture methods.
In this capture method (Capture_Method=LOGMINER), Fivetran HVR reads transaction log records using Oracle's logminer interface (dbms_logmnr package). This capture method reads change data over an SQL connection and does not require the HVR Agent to be installed on the source database machine. However, this capture method is slower than the Direct Redo Access method and exposes additional load on the source database.
Grants for LogMiner
The HVR database User must have the privileges mentioned in section Grants for Log-Based Capture and additionally the following privileges for capturing from Oracle using LogMiner interface:
grant execute on sys.dbms_logmnr to username; grant select any transaction to username; grant execute_catalog_role to username; /* The following grant is required for Oracle 12.1 and later */ grant logmining to username;
Limitations of LogMiner Capture Method
- Only Oracle version 11.2.0.3 and above are supported for capturing changes from LogMiner.
- Capture of truncate statements is not supported.
- Capture from XML Data Type columns is not supported.
- Updates that only change LOB columns are not supported.
- Index Organized Tables (IOT) with an overflow segment is not supported.
- Capturing DDL (using action AdaptDDL) changes such as
add table as...,drop table...andalter table...including partition operations are not supported.