最近客户有一个需求,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.