CDC Guide for Linux, UNIX, and Windows

10.2
- 10.2.2
- 10.2.1
- 10.0

Back Next

Configuring Oracle CDC with LogMiner - Without the PowerExchange Logger

If you plan to run extractions in real-time extraction mode and not
use the PowerExchange Logger for Linux, UNIX, and Windows, complete the following tasks to configure PowerExchange Oracle CDC with LogMiner:

When you configure the dbmover configuration file on the Oracle source machine, include the following statements:

CAPT_PATH

CAPT_XTRA

ORACLEID

ORCL CAPI_CONNECTION

UOWC CAPI_CONNECTION

For more information, see the PowerExchange Reference Manual
.

In the PowerExchange Navigator, create a capture registration for each Oracle source table.

If capture registrations already exist for these tables, delete the existing registrations and extraction maps and create new ones.

You must enter a name in the

Supplemental Log Group Name

field.

Set the

Condense

option to

Part

even though you do not plan to use the PowerExchange Logger, unless you have a specific reason not to do so. This practice prevents having to edit the capture registrations later if you decide to use the PowerExchange Logger. You might want to set the

Condense

option to

None

if you plan to run both real-time and continuous extractions against tables defined by the same capture registrations and do not want the PowerExchange Logger to capture change data for some registered tables.

The PowerExchange Navigator generates a corresponding extraction map and the DDL for creating a supplemental log group. If you selected the

Execute DDL now

option, PowerExchange executes the DDL for creating a supplemental log group when you click

Finish

. If you did not select this option, you must execute the DDL prior to starting extraction processing.

Activate the capture registrations. Usually, you do this task after materializing the targets.

Next Step:
Configure and start extractions. You must use real-time extraction mode.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Configuring Oracle CDC with LogMiner - Without the PowerExchange Logger

Configuring Oracle CDC with LogMiner - Without the PowerExchange Logger