CDC Guide for Linux, UNIX, and Windows

10.0
- 10.2.2
- 10.2.1
- 10.2

Back Next

Oracle Data Sources

PowerExchange for Oracle provides two alternative methods of capturing change data from Oracle sources: PowerExchange Express CDC for Oracle
and PowerExchange Oracle CDC with LogMiner
. Both methods are delivered as part of the PowerExchange for Oracle CDC option but you can use only one of them in a PowerExchange instance with the same configuration files.

With both methods, Informatica strongly recommends that you use the PowerExchange Logger for Linux, UNIX, and Windows.

PowerExchange Express CDC for Oracle: PowerExchange Express CDC reads change data directly from Oracle active and archived redo logs. It is more efficient and faster than PowerExchange Oracle CDC with LogMiner in many environments. Also, it avoids LogMiner reinitialization issues.
You can run PowerExchange Express CDC on the database server or on another supported 64-bit Linux, UNIX or Windows machine. At initialization, PowerExchange Express CDC stores the Oracle data dictionary in memory.

You must run Oracle in ARCHIVELOG mode with minimal global supplemental logging enabled.

PowerExchange Express CDC supports RAC and non-RAC environments, ASM, and Oracle Data Guard logical and physical standby databases.

Although PowerExchange Express CDC supports many types of Oracle environments, it has the following restrictions:

PowerExchange Express CDC does not capture changes for the following types of objects:
Tables defined with sorted hash cluster columns
Virtual columns
LOB columns that are defined with the STORE AS SECUREFILE storage parameter
Columns that use Oracle Advanced Security Transparent Data Encryption (TDE)
Tablespaces that use any type of encryption other than TDE

PowerExchange Express CDC does not capture the following types of operations:
Direct-path INSERTs
INSERT AS SELECT, MERGE, and PL/SQL FORALL operations that use the APPEND hint or parallel mode
SQL*Loader direct-path loads
CREATE TABLE...AS SELECT operations
PowerExchange Oracle CDC with LogMiner: PowerExchange Oracle CDC with LogMiner uses Oracle LogMiner continuous mining to read change data from the Oracle archive logs that reside at the archive destination to which they were originally written.
You must run Oracle in ARCHIVELOG mode with minimal global supplemental logging enabled. You must also periodically copy the Oracle online data dictionary to the archive log destination so that PowerExchange can determine restart points for change data extraction processing.

PowerExchange Oracle CDC with LogMiner supports RAC and non-RAC environments, ASM, and Oracle Data Guard logical standby databases.

PowerExchange Oracle CDC with LogMiner does not capture change data from the following types of objects and environments:

Oracle Data Guard physical databases
Oracle 11
g
or later tables that use the system partitioning or reference partitioning scheme and virtual columns
Oracle 12
c
multitenant environments

You cannot use both PowerExchange Express CDC for Oracle and PowerExchange Oracle CDC with LogMiner in the same PowerExchange instance with the same dbmover.cfg and pwxccl.cfg configuration files.

PowerExchange CDC Data Sources

Oracle CDC with LogMiner

Express CDC for Oracle

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal