My Oracle Support Banner

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 later
Information 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


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