Shulou(Shulou.com)06/01 Report--

1.

Problem: goldengate synchronization is unresponsive, unsuccessful, ggserr does not report error log, and the process is not abended

Solution: the reason is that the delivery process pump can not read the trail file, or the pump setting to read the trail file path is incorrect.

two。 Looking at the actual case, there are three process groups configured: grab data process group ext1, transfer data group pump1, and application data group rep1. All three process groups are running normally, ggserr does not report an error, and ext1 can fetch data from the database normally. However, because the pump process group cannot transfer data, there is no response in synchronization.

GGSCI (paytest01) 45 > info extract ext1

EXTRACT EXT1 Last Started 2017-10-26 18:34 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:09 ago)

Log Read Checkpoint Oracle Redo Logs

2017-10-27 11:57:15 Seqno 104, RBA 737280

SCN 0.3095938 (3095938)

GGSCI (paytest01) 51 > info pump1

EXTRACT PUMP1 Last Started 2017-10-27 12:01 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:09 ago)

Log Read Checkpoint File dirdat/sp000000

First Record RBA 0

GGSCI (oracle93.weconex.com) 25 > info replicat rep1

REPLICAT REP1 Last Started 2017-10-26 18:34 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:09 ago)

Log Read Checkpoint File dirdat/rp000000

First Record RBA 0

3. Analysis problem: the pump process reads the sp files in the directory dirdat, but there are these files in that directory. Such as:

[oracle@paytest01 gg] $ls-l dirdat-h

Total 3.1M

-rw-rw-rw- 1 oracle oinstall 24K Oct 26 18:30 sp000001

-rw-rw-rw- 1 oracle oinstall 246K Oct 26 18:34 sp000002

-rw-rw-rw- 1 oracle oinstall 2.9m Oct 27 11:31 sp000003

4. Finally, the problem is found: the pump1 process reads the sp000000 file, but only the sp000001 file, of course, First Record RBA is 0. 0.

The same thing happens if the pump process group path is set incorrectly: goldengate synchronization is unresponsive, unsuccessful, ggserr does not report error logs, and the process is not abended.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.