风哥教程

培训 . 交流 . 分享
Make progress together!

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

[复制链接]
内容发布:风哥| 发布时间:2016-3-31 13:59:40
oracle goldengate 12c由ADG抽取数据的配置参数:

12c新特性关于对ADG支持描述如下:

       Active Data Guard (ADG) - A new processing option (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.

其实也就是在参数文件中多了上面参数MINEFROMACTIVEDG.

配置简单获取本地extract文件:
--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.*


GGSCI>add extract  ep_fme1,tranlog ,threads 2,begin now  
GGSCI>add exttrail ./dirdat/f1, extract ep_fme1, megabytes 100

现在就可以收取ADG中的日志文件啦。



上一篇:Oracle GoldenGate 12c版本18个新功能全面曝光_详解OGG 12c新特性
下一篇:Oracle GoldenGate实施手册精华资料
专业提供Oracle/MySQL/NoSQL/Linux数据库培训与技术支持服务,QQ号:113257174
关注风哥教程微信公众号itpux_com  ,了解本站最新技术资料的分享.

欢迎加QQ群,提供超多高质量Oracle/Unix/Linux技术文档与视频教程的下载。

Oracle/MySQL/Linux群4-5:189070296  150201289  
Oracle/MySQL/Linux群6-8:244609803   522261684   522651731
备注:请勿重复加群,另请注明 from itpux
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
  • PostgreSQL数据库中文培训手册
  • Navicat for MySQL最新版下载地址及注册码
  • Oracle OCP认证考试IZ0-053题库共712题数据
  • MySQL5权威指南(第3版)PDF电子版下载
  • Oracle Database 12c 数据库100个新特性与
快速回复 返回顶部 返回列表