Oracle GoldenGate实现DDL同步

环境描述

	Oracle 版本	抽取	投递	复制
源端	19.16.0.0	EXT1	PUMP1	-
目标端	19.16.0.0	-	-	REP1

各个进程配置：

抽取进程EXT1：

GGSCI (ogghost) 1> view params ext1

EXTRACT Ext1
USERID c##ogg,PASSWORD ogg
EXTTRAIL /goldengate/dirdat/orcl_orcl/et
DBOPTIONS  ALLOWUNUSEDCOLUMN
WARNLONGTRANS 2h,CHECKINTERVAL 5m
CACHEMGR CACHESIZE 2G
SOURCECATALOG pdb_orcl
table scott.test;

投递进程PUMP1：

GGSCI (ogghost) 2> view params PUMP1

extract pump1
userid c##ogg,password ogg
rmthost 192.168.88.82,mgrport 7809
rmttrail /goldengate/dirdat/orcl_orcl/rt
SOURCECATALOG PDB_ORCL
table scott.test;

复制进程REP1

GGSCI (ogghost) 3> view params REP1

replicat rep1
userid ogg@192.168.88.82/pdb_orcl,password ogg
ASSUMETARGETDEFS
MAXSQLSTATEMENTS 250
DISCARDFILE /goldengate/rep1_discard.txt,append,megabytes 10
DISCARDROLLOVER AT 02:00
DDLERROR DEFAULT IGNORE RETRYOP
SOURCECATALOG pdb_orcl
map scott.test,target benjamin.test;

运行脚本

	进入到OGG的安装目录下:
	$ cd /goldengate
	$ sqlplus / as sysdba
    
    执行marker_setup.sql脚本：
    SQL>@marker_setup.sql

编辑进程

	为抽取与投递进程添加如下参数:
	DDL INCLUDE ALL
	DDLOPTIONS ADDTRANDATA, REPORT
    
    为复制进程添加如下参数:
    DDL INCLUDE MAPPED
    DDLOPTIONS REPORT

重启进程

GGSCI> stop ext1
GGSCI> stop pump1
GGSCI> stop rep1

GGSCI> start ext1
GGSCI> start pump1
GGSCI> start rep1

经测试可以实现DML以及DDL的同步。