IR (but not CR) skips DDL record when restart after hitting an error on it
(Doc ID 2234148.1)
Last updated on JUNE 05, 2019
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
after hitting an error on DDL, Integrated replicat restart worked - i.e., the problem ddl was skipped.
for classic replicat, on restart it will abend with same error, which is expected behavior.
TEST CASE:
------------------------------
parameters:
.
1) r1
ddl include mapped
ddloptions report
map test.mytab, target test.mytab;
2) rtest1
DBOPTIONS INTEGRATEDPARAMS(parallelism 2)
DDLOPTIONS report
map test.mytab, target test.mytab;
.
TESTCASE STEP-BY-STEP INSTRUCTIONS:
-----------------------------------
1. classic replicat will abend after restart, as expected.
GGSCI (server) 50> alter r1 extseqno 0 extrba 0
2016-12-01 16:58:44 INFO OGG-06594 Replicat R1 has been altered through
GGSCI. Even the start up position might be updated, duplicate suppression
remains active in next startup. To override duplicate suppression, start R1
with NOFILTERDUPTRANSACTIONS option.
REPLICAT altered.
GGSCI (server) 51> start r1 NOFILTERDUPTRANSACTIONS
Sending START request to MANAGER ...
REPLICAT R1 starting
GGSCI (server) 52> info r1
REPLICAT R1 Last Started 2016-12-01 16:58 Status ABENDED
Checkpoint Lag 00:43:02 (updated 00:00:24 ago)
Log Read Checkpoint File ./dirdat/tt000000001
2016-12-01 16:15:49.086668 RBA 1507
GGSCI (server) 53> start r1
Sending START request to MANAGER ...
REPLICAT R1 starting
GGSCI (server) 54> info r1
REPLICAT R1 Last Started 2016-12-01 16:59 Status ABENDED
Checkpoint Lag 00:00:00 (updated 00:00:29 ago)
Log Read Checkpoint File ./dirdat/tt000000001
First Record RBA 1507
2. integarted replicat will hit the error first, but runs fine after restart
(rba moves)
GGSCI (server) 55> alter rtest1 extseqno 0 extrba 0
2016-12-01 17:00:25 INFO OGG-06594 Replicat RTEST1 has been altered
through GGSCI. Even the start up position might be updated, duplicate
suppression remains active in next startup. To override duplicate
suppression, start RTEST1 with NOFILTERDUPTRANSACTIONS option.
REPLICAT (Integrated) altered.
GGSCI (serrver) 56> start RTEST1 NOFILTERDUPTRANSACTIONS
Sending START request to MANAGER ...
REPLICAT RTEST1 starting
GGSCI (server) 57> info RTEST1
REPLICAT RTEST1 Last Started 2016-12-01 17:00 Status ABENDED
INTEGRATED
Checkpoint Lag 00:00:00 (updated 00:00:26 ago)
Log Read Checkpoint File ./dirdat/tt000000001
2016-12-01 17:00:41.056641 RBA 1507
GGSCI (server) 58> start RTEST1
Sending START request to MANAGER ...
REPLICAT RTEST1 starting
GGSCI (server) 59> info RTEST1
REPLICAT RTEST1 Last Started 2016-12-01 17:01 Status RUNNING
INTEGRATED
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Process ID 30697
Log Read Checkpoint File ./dirdat/tt000000001
2016-12-01 17:01:44.292142 RBA 2806
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |