Skip to content

SYSTEM Cited by 1 source

Oracle LogMiner

Oracle LogMiner is an Oracle Enterprise Edition utility (packaged as the DBMS_LOGMNR PL/SQL package) for mining the redo log stream — Oracle's write-ahead-log equivalent — to reconstruct row-level change events (inserts, updates, deletes) after they have occurred. It is the canonical substrate that modern Oracle-source CDC ecosystems consume.

Stub page — canonical wiki home introduced by the 2026-04-09 Redpanda Connect Oracle CDC launch. Expand on future Oracle- internals or LogMiner-specific sources.

What it is

LogMiner reads the contents of Oracle's redo log — the sequential on-disk log of every row-level change committed to the database — and reconstructs the higher-level SQL operations (INSERT / UPDATE / DELETE) and their before/after row images. Downstream consumers then have access to a structured stream of change events without having to parse the redo log format directly.

Two operating modes:

  • Ad-hoc mining — a tool or user invokes DBMS_LOGMNR to mine a specific archived redo-log range.
  • Continuous mining — a client continuously consumes the redo stream as new transactions commit. This is the mode CDC pipelines use.

Why CDC ecosystems prefer LogMiner

Compared to the pre-LogMiner alternatives:

  • Trigger-based capture — invasive, slows down source transactions, must be maintained per captured table, does not capture DDL cleanly.
  • Query-based polling — inefficient (repeated scans), misses deletes unless schema has soft-delete column, inaccurate ordering.

LogMiner provides a non-invasive, transactionally-consistent, ordered stream of changes, because it consumes the redo log that Oracle itself uses for crash recovery and physical replication.

Licensing

  • Enterprise Edition only. "Oracle LogMiner, which ships with Oracle Enterprise Edition" (Source: sources/2026-04-09-redpanda-oracle-cdc-now-available-in-redpanda-connect). Oracle Standard Edition users cannot build a redo-log-based CDC pipeline on LogMiner.
  • Verbatim: "there's no additional Oracle licensing required" — meaning: no additional licence beyond the existing Oracle Enterprise Edition licence. (This is a different licensing story from Oracle GoldenGate, which is a separate commercial product.)

Consumers in the wiki

  • Redpanda Connect oracledb_cdc — consumer canonicalised in the 2026-04-09 launch post. Rides on LogMiner for the streaming phase; checkpoint position is stored in Oracle itself (in-source checkpointing).
  • [[systems/debezium|Debezium] Oracle connector — the Kafka- Connect-hosted Oracle CDC consumer (also LogMiner-based); named as the competitive foil in the 2026-04-09 launch post but not extensively described.

Operational caveats (not walked by the 2026-04-09 post)

The launch post names LogMiner as the substrate but does not walk the operational surface. Known Oracle-operator concerns:

  • Supplemental logging — required on tables captured by LogMiner to ensure the redo stream contains enough information to reconstruct before-images. Must be enabled at the table or database level.
  • Archive-log generation rate — LogMiner consumes archived redo logs; archive-log-generation rate under peak OLTP load can be substantial.
  • Performance overhead on the source primary — mining the redo log while the source is under OLTP load has a measurable CPU / memory / IO cost.
  • Continuous mining deprecation — Oracle 19c deprecated the continuous-mining mode in favour of external consumers that manage their own redo-log-file discovery; modern CDC pipelines typically use the LogMiner APIs in a client-driven mode.

None of these are addressed in the 2026-04-09 Redpanda post.

Seen in

Last updated · 470 distilled / 1,213 read