ogg配置DDL复制

记录一下

 

 

集成提取模式下的配置，简单

GGSCI (server247 as ogg@prod247) 73> view param E_TEST01

EXTRACT e_test01
SETENV (ORACLE_SID = "prod247")
SETENV (ORACLE_HOME= /u01/app/oracle/product/19c/db_1)
SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
USERID ogg, PASSWORD Passw0rd123456
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
-- Log all scheduling columns if using integrated Replicat
LOGALLSUPCOLS
DBOPTIONS ALLOWUNUSEDCOLUMN
WARNLONGTRANS 2h, CHECKINTERVAL 300s
FETCHOPTIONS NOUSESNAPSHOT
REPORTCOUNT EVERY 10 MINUTES, RATE
exttrail /data001/ogg/ggs/dirdat/e1,FORMAT RELEASE 19.1
discardfile /data001/ogg/ggs/dirrpt/e_test01.dsc, append, megabytes 500
table test001.*;