oracle goldengate 12c由ADG抽取数据的配置参数
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中的日志文件啦。