ogg不同版本之间同步

环境:
主库ogg版本:21C
从库ogg版本:12C

 

同步遇到的问题:

2022-10-13 14:52:48  ERROR   OGG-02598  File /goldengate12c/dirdat/cp000000000, with trail format release LEVEL 7, is not compatible with the current software version's trail file format release RELEASE 12.3. Modify the file writer's parameter file to generate the appropriate format using the FORMAT RELEASE RELEASE 12.3 option.

 

解决办法:
分别在抽取进程和投递进程加上FORMAT RELEASE 12.3参数

GGSCI (localhost.localdomain as goldengate@slnngk) 200> view params ext_toc

extract ext_toc
userid goldengate@tns11g, password 123456
SETENV (ORACLE_SID="slnngk")
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
exttrail ./dirdat/cp,FORMAT RELEASE 12.3
br brinterval 20M
numfiles 5000
warnlongtrans 3h, checkinterval 10m

--DDL parameter
DDL &
EXCLUDE INSTR 'shrink space CHECK' &
INCLUDE INSTR 'CREATE INDEX' &
INCLUDE MAPPED OBJTYPE 'TABLE' &
INCLUDE MAPPED OBJTYPE 'INDEX' &
INCLUDE MAPPED OBJTYPE 'SEQUENCE' &
INCLUDE MAPPED OBJTYPE 'VIEW' &
INCLUDE MAPPED OBJTYPE 'PROCEDURE' &
INCLUDE MAPPED OBJTYPE 'FUNCTION' &
INCLUDE MAPPED OBJTYPE 'PACKAGE' 


ddloptions addtrandata report 

table hxlbc.tb_test_bc;

 

投递进程参数

GGSCI (localhost.localdomain as goldengate@slnngk) 202> view params pump_toc   

EXTRACT pump_toc
userid goldengate@tns11g, password 123456
rmthost 192.168.58.111, mgrport 7809 
rmttrail ./dirdat/cp,FORMAT RELEASE 12.3
gettruncates
passthru
table hxlbc.*;