Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Determining If the PowerExchange Logger Captured Changes

Determining If the PowerExchange Logger Captured Changes

To determine if the PowerExchange Logger for Linux, UNIX, and Windows captured committed changes for registered tables of interest, look for the following message in the PowerExchange message log:
PWX-09967 CAPI i/f: End of log for time 10/05/20 14:18:18 reached
This message indicates that the PowerExchange Logger read all of the changes that were available at the start the logging cycle. Look for this message if a PowerExchange Logger log file does not receive change data within the time period you expect. Delays can occur for various reasons. For example, if you cold start the PowerExchange Logger from the current restart point but a recent copy of the Oracle online catalog is not available in the archived redo logs, PowerExchange might need to read many archived logs before determining the point from which to begin capturing changes.
This message also indicates the point at which the PowerExchange Logger CATINT, CATBEGIN, and CATEND parameters take effect. These parameters control how often Oracle copies the catalog and the time period within which the copy operation occurs.

0 COMMENTS

We’d like to hear from you!