20170920 ogg

源端

GGSCI (hpcs01) 104> info all

Program          Status      Group       Lag at Chkpt  Time Since Chkpt 

MANAGER     RUNNING                                           

EXTRACT      RUNNING     EXT_CA      00:00:00      00:00:06   

EXTRACT      RUNNING     PUMP_CA     00:00:00      00:00:02   

 

GGSCI (hpcs01) 107> view params mgr

PORT 8050
DYNAMICPORTLIST 8801-8820,8830
AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*, usecheckpoints, minkeepdays 1
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45

GGSCI (hpcs01) 105> view params ext_ca

EXTRACT ext_ca
dynamicresolution
Setenv (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
Setenv (ORACLE_HOME="/oracle/app/oracle/product/11.2.0/db_1")
USERID ogg,PASSWORD ogg
DISCARDFILE /oracle/gg/dirrpt/ex.dsc, APPEND, MEGABYTES 1024
WARNLONGTRANS 10h,CHECKINTERVAL 10m,SKIPEMPTYTRANS
EXTTRAIL /oracle/gg/dirdat/ex
TRANLOGOPTIONS  CONVERTUCS2CLOBS
gettruncates
GETUPDATEBEFORES
REPORTCOUNT EVERY 1 MINUTES, RATE
TABLE scott.*;

add extract ext_ca,tranlog begin now
add exttrail /oracle/gg/dirdat/ex,extract ext_ca megabytes 1024

GGSCI (hpcs01) 106> view params pump_ca

EXTRACT pump_ca
PASSTHRU
DYNAMICRESOLUTION
RMTHOST 133.224.218.61, MGRPORT 8050
RMTTRAIL /oracle/gg/dirdat/ra
TABLE *.*;

add extract pump_ca,exttrailsource /oracle/gg/dirdat/ex
add rmttrail /oracle/gg/dirdat/ra ,extract pump_ca,megabytes 1024 

 

目标端

GGSCI (hpcs02) 55> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           

REPLICAT      RUNNING     IMP_CA      00:00:00      00:00:05 

GGSCI (hpcs02) 56> view params mgr

PORT 8050
DYNAMICPORTLIST 8801-8820,8830
AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*, usecheckpoints, minkeepdays 1
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45

GGSCI (hpcs02) 57> view params imp_ca

REPLICAT imp_ca
ASSUMETARGETDEFS
allownoopupdates
DYNAMICRESOLUTION
USERID ogg, PASSWORD ogg
DISCARDFILE ./dirrpt/imp_ca.dsc,append
MAP SCOTT.* , TARGET SCOTT.*;

add checkpointtable ogg.checkpoint
add replicat imp_ca,exttrail /oracle/gg/dirdat/ra,begin now,checkpointtable ogg.checkpoint