GoldenGate Fails To Get New Transactions After The Daylight Savings Time Change. (Doc ID 2209526.1)

Last updated on DECEMBER 27, 2023

Applies to:

Symptoms

We noticed that several processes were, though running, not applying any new transactions.
This afternoon - well after the time switch - the current checkpoint was still 11-06-2016 01:52 because no new trails were coming over.
No alerts to the true lag time came were made because essentially, the replicat was caught up.

At this time we are not sure what has caused this.

Source database is DB2 for i Series - 7.1 TR10
Target database is Oracle 11.2.0.4

I have altered the extract pump on source to start at extrba 0 of the last trailfile received on the target system. I verified that the pump could communicate with the target system, and it continued to process trails in the sequence. However, transactions stop at the time of the time switch. The last transaction applied has a timestamp of 2016/11/06 01:00:00.591.936 RBA 92656175. All processes are shown to be running.

It really seems like the extract is unable to get any transactions from the journals as no transactions are seen from the STATS EXTRACT command.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.