OGG经典模式调整为集成模式步骤

cp ex_bdf.prm ex_bdf.prm_20230725

GGSCI> SEND EXTRACT ex_bdf, SHOWTRANS

dblogin USERID ogg, PASSWORD

REGISTER EXTRACT ex_bdf DATABASE

INFO EXTRACT ex_bdf UPGRADE

STOP EXTRACT ex_bdf

ALTER EXTRACT ex_bdf UPGRADE INTEGRATED TRANLOG

EXTRACT ex_bdf
EXTTRAIL ./dirdat/df
SETENV (ORACLE_HOME = /oracle/app/oracle/product/12.2.0.1/dbhome_1)
SETENV (ORACLE_SID = cxbdzxdb1)
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID ogg, PASSWORD 
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 2000, parallelism 1)
DDL &
INCLUDE MAPPED OBJTYPE 'table' &
INCLUDE MAPPED OBJTYPE 'index'
ddloptions REPORT
LOGALLSUPCOLS
UPDATERECORDFORMAT compact 
table policy.*;

START EXTRACT ex_bdf

EXTRACT ext_ara
EXTTRAIL ./dirdat/pa
SETENV (ORACLE_HOME = oracle/app/oracle/product/12.2.0.1/dbhome_1)
SETENV (ORACLE_SID = cxbdzxdb1)
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID ogg, PASSWORD 
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 4000, parallelism 1)
DDL &
INCLUDE MAPPED OBJTYPE 'table' &
INCLUDE MAPPED OBJTYPE 'index'
ddloptions REPORT
LOGALLSUPCOLS
UPDATERECORDFORMAT compact 
TABLE policy.AUTHORITY;
TABLE policy.CFG_AGRKINDMAPPING_DETAIL;


extract ex_bdf
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID ogg, PASSWORD 
FETCHOPTIONS FETCHPKUPDATECOLS
TRANLOGOPTIONS DBLOGREADER
exttrail ./dirdat/df
NOCOMPRESSUPDATES
CACHEMGR CACHESIZE 2G
BR BROFF
table policy.*;