ogg不同版本之间同步

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.

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.*;