代码改变世界

小知识:OGG的TRANLOGOPTIONS MINEFROMACTIVEDG参数

2020-08-28 09:15  AlfredZhao  阅读(1343)  评论(0编辑  收藏  举报

最近客户有一个需求,OGG源端需要配置在ADG环境,按历史配置规范,开启抽取进程报错:

2020-08-26 18:02:27  ERROR   OGG-00060  Extract requires a value specified for parameter ALTARCHIVELOGDEST when in archived log only mode.

2020-08-26 18:02:27  ERROR   OGG-01668  PROCESS ABENDING.

这是因为默认无法在ADG环境抽取redo,解决方案是在抽取进程中添加参数:

TRANLOGOPTIONS MINEFROMACTIVEDG

再次启动抽取进程后解决问题。

这个依据是参考MOS文档,注意OGG版本需在 12.1.2.1.0 及以后。

  • Does GoldenGate Support Extracting Redo from Active Data Guard? (Doc ID 1299805.1)

Does GoldenGate support extract reading redo from generated from an active data guard?

Yes, this is supported in 12.1.2.1.0 (but not previous version) GoldenGate classic extract, with parameter:

TRANLOGOPTIONS MINEFROMACTIVEDG

For versions older than 12.1.2.1.0 the below error can occur:

ERROR OGG-00303 Unrecognized option (MINEFROMACTIVEDG) for TRANLOGOPTIONS.

So Goldengate must be upgraded to 12.1.2.1.0 or later versions to resolve it.