Oracle CDC with LogMiner is an alternative to PowerExchange Express CDC for Oracle.

Oracle CDC with LogMiner supports Oracle Real Application Cluster (RAC) and Automatic Storage Management (ASM) environments.

Oracle CDC with LogMiner uses the UOW Cleanser component to reconstruct UOWs from archived redo logs into complete and consecutive UOWs that are in chronological order by end time.

To implement Oracle CDC with LogMiner, you need to perform configuration tasks in Oracle, PowerExchange, and PowerCenter.

In Oracle, ensure that ARCHIVELOG mode and global minimal supplemental logging are enabled so that change data can be retrieved from archived redo logs. Also, ensure that a copy of the Oracle online catalog exists in the archived log destination. PowerExchange requires a copy of the catalog to determine restart points for change data extraction processing.

In PowerExchange, define a capture registration for each source table. In the capture registration, you can select a subset of columns for which to capture data. PowerExchange generates a corresponding extraction map.

Use of the PowerExchange Logger for Linux, UNIX, and Windows is optional but strongly recommended. The PowerExchange Logger captures change data from Oracle logs and write only the successful units of work (UOWs), in chronological order based on commit time, to PowerExchange Logger log files. The change data is then extracted from the PowerExchange Logger log files in either continuous extraction mode or batch extraction mode. Benefits of using the PowerExchange Logger include fewer database accesses, faster CDC restart, and no need to prolong retention of the Oracle redo files for change capture.

PowerExchange works with the PowerExchange Client for PowerCenter (PWXPC) and PowerCenter to extract change data from Oracle redo logs or PowerExchange Logger log files and load that data to one or more targets.