ogg oracle 测试kafka_OGG同步ORACLE数据到KAFKA

源端配置：

1、为要同步的表添加附加日志

dblogin USERID [email protected], PASSWORD ogg

add trandata scott.tab1

add trandata scott.tab2

2、 添加抽取进程

GGSCI>add extract EXT_KAF1,integrated tranlog, begin now

GGSCI>add EXTTRAIL ./dirdat/k1, extract EXT_KAF1,MEGABYTES 200

编辑抽取进程参数：

GGSCI> edit params EXT_KAF1

extract EXT_KAF1

userid c##ggadmin,PASSWORD ggadmin

LOGALLSUPCOLS

UPDATERECORDFORMAT COMPACT

exttrail ./dirdat/k1,FORMAT RELEASE 12.3

SOURCECATALOG orclpdb --(指定pdb)

table scott.tab1;

table scott.tab2;

注册进程

GGSCI> DBLOGIN USERID c##ggadmin,PASSWORD ggadmin

GGSCI> register extract EXT_KAF1 database container (orclpdb)

3、添加投递进程：

GGSCI>add extract PMP_KAF1, exttrailsource ./dirdat/k1

GGSCI>add rmttrail ./dirdat/f1,EXTRACT PMP_KAF1,MEGABYTES 200

编辑投递进程参数：

GGSCI>edit param PMP_KAF1

EXTRACT PMP_KAF1

USERID c##ggadmin,PASSWORD ggadmin

PASSTHRU

RMTHOST 10.1.1.247, MGRPORT 9178

RMTTRAIL ./dirdat/f1,format release 12.3

SOURCECATALOG orclpdb

TABLE scott.tab1;

table scott.tab2;

4、添加数据初始化进程(Oracle initial load) 可以多个表分开初始化也可以一起初始化，此处选择分开初始化

GGSCI> add extract ek_01, sourceistable

编辑参数：

GGSCI> EDIT PARAMS ek_01

EXTRACT ek_01

USERID c##ggadmin,PASSWORD ggadmin

RMTHOST