环境:
主库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.*;
标签:同步,FORMAT,12.3,RELEASE,版本,MAPPED,OBJTYPE,ogg,INCLUDE From: https://www.cnblogs.com/hxlasky/p/16788867.html