Wiki Admin

Capture from Oracle using LogMiner - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Capture from Oracle using LogMiner - DSS 6 | Data Source Solutions Documentation

Capture From Oracle Using LogMiner

Capture from Oracle using the LOGMINER method is deprecated in DSS 6.2 and will be removed from the product in DSS 6.3. Consider migrating to BFILE or DIRECT capture methods, or evaluate Data Source Solutions's Oracle Connector.

In this capture method (Capture_Method=LOGMINER), Data Source Solutions DSS 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 DSS 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 DSS 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 <em>username</em>;

grant select any transaction to <em>username</em>;

grant execute_catalog_role to <em>username</em>;

/* The following grant is required for Oracle 12.1 and later */

grant logmining to <em>username</em>;

Limitations of LogMiner Capture Method

  • Only Oracle version 11.2.0.3 and above are supported for capturing changes from LogMiner.
  • Capture from Oracle RAC is not supported.
  • 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 <b>add table as...</b> , <b>drop table...</b> and <b>alter table...</b> including partition operations are not supported.

See Also