My Oracle Support Banner

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

Last updated on JUNE 05, 2019

適用範囲:

Oracle GoldenGate - バージョン 12.2.0.1.0 以降
この文書の内容はすべてのプラットフォームに適用されます。
本文書利用上のご注意
  本文書は英語の文書 <Document 2234148.1> (最終メジャー更新日: 2017年2月15日) の日本語翻訳版です。
  英語の文書の最終メジャー更新日が新しい場合は本文書に適宜反映いたします。

現象

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

変更点

 

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.