Replicat Process stuck at a particular DDL. (Doc ID 2178276.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.1 and later
Information in this document applies to any platform.

Goal

 Integrated replicat was stuck at a particular DDL, it seems to be looping.

2016-08-30 01:37:47.206 DEBUG|gglog.std.system |main| 159 replicat/processread.cpp | READ_EXTRACT_RECORD return status: 0
2016-08-30 01:37:47.206 INFO |ggstd.ptrace |main| 160 replicat/processread.cpp | exited READ_EXTRACT_RECORD (stat=0, seqno=8520, rba=7797318)
2016-08-30 01:37:47.206 DEBUG|gglog.std.system |main| 729 replicat/replicat.cpp | check_extract_restart_abend: standard header i/o type: 160
2016-08-30 01:37:47.206 INFO |ggapp.CDBObjNameParser |main| 178 ggapp/CDBObjNameParser.c | Empty string - returning NULL object name array
2016-08-30 01:37:47.206 INFO |ggstd.ptrace |main| 1049 replicat/processloop.cpp | processing record for
2016-08-30 01:37:47.206 DEBUG|gglog.ir |main| 4948 ggdbora/iroci.cpp | fallback_to_classic: seqno 8520 rba 7797318 trans_seqno 8520 trans_rba 7797318
2016-08-30 01:37:47.206 DEBUG|gglog.ir |main| 3568 ggdbora/iroci.cpp | Rollback operation for txid 0x000000000213eb60
2016-08-30 01:37:47.206 DEBUG|gglog.std.system |main| 204 replicat/processloop.cpp | process_replicat_loop: main loop ----------------------------------------------*
2016-08-30 01:37:47.206 INFO |ggstd.ptrace |main| 78 replicat/processread.cpp | * --- entering READ_EXTRACT_RECORD --- *
2016-08-30 01:37:47.206 INFO |gglog.std.application |main| 3147 er/api.c | FILE IO-NAME: /ggsci/target121/dirdat/replicat/SUW1/3t008520

2016-08-30 01:42:19.569 DEBUG|gglog.std.system |main| 159 replicat/processread.cpp | READ_EXTRACT_RECORD return status: 0
2016-08-30 01:42:19.569 INFO |ggstd.ptrace |main| 160 replicat/processread.cpp | exited READ_EXTRACT_RECORD (stat=0, seqno=8520, rba=7797318)
2016-08-30 01:42:19.569 DEBUG|gglog.std.system |main| 729 replicat/replicat.cpp | check_extract_restart_abend: standard header i/o type: 160
2016-08-30 01:42:19.569 INFO |ggapp.CDBObjNameParser |main| 178 ggapp/CDBObjNameParser.c | Empty string - returning NULL object name array
2016-08-30 01:42:19.569 INFO |ggstd.ptrace |main| 1049 replicat/processloop.cpp | processing record for
2016-08-30 01:42:19.569 DEBUG|gglog.ir |main| 4948 ggdbora/iroci.cpp | fallback_to_classic: seqno 8520 rba 7797318 trans_seqno 8520 trans_rba 7797318
2016-08-30 01:42:19.569 DEBUG|gglog.ir |main| 3568 ggdbora/iroci.cpp | Rollback operation for txid 0x000000000213eb60
2016-08-30 01:42:19.569 DEBUG|gglog.std.system |main| 204 replicat/processloop.cpp | process_replicat_loop: main loop ----------------------------------------------*
2016-08-30 01:42:19.569 INFO |ggstd.ptrace |main| 78 replicat/processread.cpp | * --- entering READ_EXTRACT_RECORD --- *
2016-08-30 01:42:19.569 INFO |gglog.std.application |main| 3147 er/api.c | FILE IO-NAME: /ggsci/target121/dirdat/replicat/SUW1/3t008520

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms