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.