ITPub博客

首页 > Linux操作系统 > Linux操作系统 > goldengate(24)

goldengate(24)

Linux操作系统 作者:caisanpx 时间:2016-10-31 17:01:33 0 删除 编辑

goldengate(24)---goldengate 11.2.0.1 新特性参数选项TRANLOGOPTIONS DBLOGREADER

goldengate 版本11.2.0.1

TRANLOGOPTIONS参数选项DBLOGREADER

(Oracle) Valid for Extract in classic capture mode.
Causes Extract to use a newer ASM API that is available asof Oracle 10.2.0.5 and later 10g R2 versions, and Oracle11.2.0.2 and later 11g R2 versions (but not in Oracle 11g R1versions). This API uses the database server to access theredo and archive logs, instead of connecting directly to theOracle ASM instance. The database must contain thelibraries that contain the API modules and must berunning.To use this feature, the Extract database user must have SELECT ANY TRANSACTION privilege.

extract抽取进程配置:

GGSCI (dbhouse) 4> view params S_EX_LI

EXTRACT s_ex_li
-- SETENV (NLS_LANG = "CHINESE_CHINA.ZHS16GBK")
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "dbking")
USERID ggs, PASSWORD ggs
-- TRANLOGOPTIONS ASMUSERsys@asm, ASMPASSWORD grid sysdba
TRANLOGOPTIONS DBLOGREADER
EXTTRAIL /u01/app/oracle/ggs/dirdat/trail/tt
TABLE gis_test.*;

在goldengate 11.2.0.1版本,该TRANLOGOPTIONS DBLOGREADER 替代TRANLOGOPTIONS ASMUSERsys@asm, ASMPASSWORD grid sysdba 以及不需要设置TNS网络.再赋予权限SELECT ANY TRANSACTION 给ggs.



 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26844646/viewspace-2127370/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-04-12

  • 博文量
    165
  • 访问量
    443071