oracle goldengate 12c由ADG抽取数据的配置参数

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:539

oracle goldengate 12c由ADG抽取数据的配置参数:

[color=#464646]12c新特性关于对ADG支持描述如下:

[color=#464646] Active Data Guard (ADG) - A new processing option ([color=#4300FF]TRANLOGOPTIONS MINEFROMACTIVEDG) is introduced allowing you to configure Classic Extract to mine online redo logs shipped to the Oracle Active Data Guard standby system allowing real-time replication directly from ADG hosts. Oracle GoldenGate connects to the standby database to get metadata and other required data as needed. This mode is useful in load sensitive environments where ADG is already in place or can be implemented. It can also be used as cost effective method to implement high availability using the ADG Broker role planned (switchover) and failover (unplanned) changes.
[color=#464646]
[color=#464646]其实也就是在参数文件中多了上面参数MINEFROMACTIVEDG.

[color=#464646]配置简单获取本地extract文件:
[color=#464646]--local extract file
Extract ep_fme1
SetEnv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
UserID ggs, Password 123456
ExtTrail ./dirdat/f1
TranlogOptions RawDeviceOffset 0
TranlogOptions ALTARCHIVEDLOGFORMAT yj1a-%r-%t-%S.arc
TranlogOptions MINEFROMACTIVEDG
DynamicResolution
NoCompressUpdates
NoCompressDeletes

ReportCount Every 30 Minutes, Rate
Report at 01:00
ReportRollover at 01:15
DiscardFile ./dirrpt/ep_fme1.dsc, Purge
DiscardRollover at 02:00 ON SUNDAY

TABLE SUN.*
[color=#464646]
GGSCI>add extract ep_fme1,tranlog ,threads 2,begin now
GGSCI>add exttrail ./dirdat/f1, extract ep_fme1, megabytes 100

[color=#464646]现在就可以收取ADG中的日志文件啦。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】