Oracle LogMiner Agent

Introduction

The Oracle LogMiner agent provides Change Data Capture (CDC) capabilities using Oracle’s native LogMiner utility. This approach enables capturing changes from Oracle’s redo logs (both online and archived) to replicate data in real-time.

Key Features

Native integration with Oracle’s transaction logs
Real-time change data capture
Minimal impact on source database performance
Built-in JDBC driver connection

Supported Versions

The Oracle LogMiner agent requires:

Oracle Database version 11.2.0.4 (11.2g) or higher
Oracle Database Standard or Enterprise edition
Oracle RAC is also supported in this agent.

Connecting

Gluesync connects to Oracle using a standard JDBC connection. You can configure the agent in two ways:

Custom connection string

Within the agent configuration wizard, open the //Advanced// section and paste your custom JDBC string. Start from the TNS entry you already manage and build a full connection string similar to:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=your_host)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=your_service_name)))

Use this option whenever you must reuse an existing tnsnames.ora definition or need advanced Oracle descriptors.

Connection via SCAN (Single Client Access Name)

Alternatively, you can connect through Oracle SCAN.

Platform supported features

Feature	Support	Notes
Target role	✅	Writes to Oracle via the built-in JDBC driver.
Source role	✅	Captures transaction log changes through native LogMiner.
Snapshots	✅	Supports snapshot tasks before CDC to seed target systems.
CDC	✅	Real-time CDC using LogMiner.
CDC type	Oracle LogMiner (transaction logs)	See Oracle LogMiner documentation.
User defined data types	✅	Supports user defined data types.
Bulk load	❌	This agent does not currently support bulk loading.
Source persisted internal cache	✅	This agent supports local in-agent persistence see Source agent caching layer.
Target persisted internal cache	N/A	Writes flow directly through JDBC; no extra caching.
Driver / connector	Built-in JDBC driver	Requires standard Oracle JDBC driver.
Chains	N/A	Not supported.
Truncate operation support (reading)	✅	CDC stream detects TRUNCATE operations from redo logs.
Truncate operation support (writing)	✅	Supports Core Hub “TRUNCATE before snapshot” option.

Feature

Support

Notes

Target role

✅

Writes to Oracle via the built-in JDBC driver.

Source role

✅

Captures transaction log changes through native LogMiner.

Snapshots

✅

Supports snapshot tasks before CDC to seed target systems.

CDC

✅

Real-time CDC using LogMiner.

CDC type

Oracle LogMiner (transaction logs)

See Oracle LogMiner documentation.

User defined data types

✅

Supports user defined data types.

Bulk load

❌

This agent does not currently support bulk loading.

Source persisted internal cache

✅

This agent supports local in-agent persistence see Source agent caching layer.

Target persisted internal cache

N/A

Writes flow directly through JDBC; no extra caching.

Driver / connector

Built-in JDBC driver

Requires standard Oracle JDBC driver.

Chains

N/A

Not supported.

Truncate operation support (reading)

✅

CDC stream detects TRUNCATE operations from redo logs.

Truncate operation support (writing)

✅

Supports Core Hub “TRUNCATE before snapshot” option.

Setup Options

Choose your setup guide based on your Oracle database infrastructure: