实验环境:
source: Oracle 11.2.0.4 RAC
target：Oracle 11.2.0.4 单实例+ASM
GoldenGate：11.2.1.0.1
1.分别停止source、target端的OGG进程
stop *
stop mgr
2.source端抽取进程参数添加DDL选项
GGSCI (node3) 43> edit params ex1
EXTRACT ex1
USERID oggadmin, PASSWORD oggadmin
TRANLOGOPTIONS DBLOGREADER
EXTTRAIL /goldengate/dirdat/ex
DDL INCLUDE ALL
DDLOPTIONS ADDTRANDATA, REPORT
TABLE snow.*;
3.target端复制进程添加DDL选项
GGSCI (single) 19> edit params rt1
REPLICAT rt1
USERID oggadmin, PASSWORD oggadmin
ASSUMETARGETDEFS
DISCARDFILE /goldengate/discards.dsc, PURGE
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
MAP snow.*, TARGET snow.*;
4. 为OGG用户显示添加权限
--drop user oggadmin cascade;
--create user oggadmin identified by oggadmin default tablespace GOLDENGATE;
grant dba to oggadmin;
grant create table,create sequence to oggadmin;
GRANT GGS_GGSUSER_ROLE TO oggadmin;
@marker_setup.sql
@ddl_setup.sql
@ddl_enable.sql
--@ddl_disable.sql
--@ddl_remove.sql
--@marker_remove.sql
5.分别开启source、target端各个进程
start mgr
start *
source: Oracle 11.2.0.4 RAC
target：Oracle 11.2.0.4 单实例+ASM
GoldenGate：11.2.1.0.1
1.分别停止source、target端的OGG进程
stop *
stop mgr
2.source端抽取进程参数添加DDL选项
GGSCI (node3) 43> edit params ex1
EXTRACT ex1
USERID oggadmin, PASSWORD oggadmin
TRANLOGOPTIONS DBLOGREADER
EXTTRAIL /goldengate/dirdat/ex
DDL INCLUDE ALL
DDLOPTIONS ADDTRANDATA, REPORT
TABLE snow.*;
3.target端复制进程添加DDL选项
GGSCI (single) 19> edit params rt1
REPLICAT rt1
USERID oggadmin, PASSWORD oggadmin
ASSUMETARGETDEFS
DISCARDFILE /goldengate/discards.dsc, PURGE
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
MAP snow.*, TARGET snow.*;
4. 为OGG用户显示添加权限
--drop user oggadmin cascade;
--create user oggadmin identified by oggadmin default tablespace GOLDENGATE;
grant dba to oggadmin;
grant create table,create sequence to oggadmin;
GRANT GGS_GGSUSER_ROLE TO oggadmin;
@marker_setup.sql
@ddl_setup.sql
@ddl_enable.sql
--@ddl_disable.sql
--@ddl_remove.sql
--@marker_remove.sql
5.分别开启source、target端各个进程
start mgr
start *
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29047826/viewspace-1342553/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
