让GG支持序列同步的配置:
源端:
在设置支持DDL同步后,进入OGG目录,以SYS用户登录数据库:
sqlplus "/as sysdba"
执行 sequence脚本:
SQL>@sequence.sql
输入gg的DDL同步用户,即之前创建的goldengate,完成后,授权:
GRANT EXECUTE on goldengate.updateSequence TO goldengate;
目标端:
sqlplus "/as sysdba"
执行 sequence脚本:
SQL>@sequence.sql
输入gg的DDL同步用户,即之前创建的goldengate,完成后,授权:
GRANT EXECUTE on goldengate.replicateSequence TO goldengate;
抽取进程:
GGSCI (rac1) 35> view params extfull
extract extfull
setenv ( NLS_LANG = " AMERICAN_AMERICA.ZHS16GBK " )
TRANLOGOPTIONS ASMUSER SYS@ASM1, ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 80000 IOLATENCY 160000
DBOPTIONS ALLO
源端:
在设置支持DDL同步后,进入OGG目录,以SYS用户登录数据库:
sqlplus "/as sysdba"
执行 sequence脚本:
SQL>@sequence.sql
输入gg的DDL同步用户,即之前创建的goldengate,完成后,授权:
GRANT EXECUTE on goldengate.updateSequence TO goldengate;
目标端:
sqlplus "/as sysdba"
执行 sequence脚本:
SQL>@sequence.sql
输入gg的DDL同步用户,即之前创建的goldengate,完成后,授权:
GRANT EXECUTE on goldengate.replicateSequence TO goldengate;
抽取进程:
GGSCI (rac1) 35> view params extfull
extract extfull
setenv ( NLS_LANG = " AMERICAN_AMERICA.ZHS16GBK " )
TRANLOGOPTIONS ASMUSER SYS@ASM1, ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 80000 IOLATENCY 160000
DBOPTIONS ALLO