實驗環境:
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 *

為已經執行的GoldenGate開啟DDL選項

相關文章