IR (CRではなく) がエラーによって再起動した際に DDL レコードをスキップする (Doc ID 2378397.1)

Last updated on NOVEMBER 14, 2019

適用範囲:

現象

DDL でのエラー発生後、統合 Replicat の再起動が成功する、つまり問題となった DDL はスキップされる。
クラシック Replicat では、Replicat の起動は同じエラーで ABEND する、この動作が想定動作である。

テストケース:

------------------------------

パラメータ:
.
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;
.
テストケースの実行手順:
-----------------------------------
1. classic replicat will abend after restart, as expected.

GGSCI > 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 > start r1 NOFILTERDUPTRANSACTIONS

Sending START request to MANAGER ...
REPLICAT R1 starting

GGSCI> 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 > start r1

Sending START request to MANAGER ...
REPLICAT R1 starting

GGSCI > 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 > 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 > start RTEST1 NOFILTERDUPTRANSACTIONS

Sending START request to MANAGER ...
REPLICAT RTEST1 starting

GGSCI > 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 > start RTEST1

Sending START request to MANAGER ...
REPLICAT RTEST1 starting

GGSCI > 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

変更点

原因

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