Oracle GoldenGate 11gR2 Configuration On Oracle Database 11gR2 RAC ACFS(三)
errors
STATUS OF SEQUENCE SUPPORT
--------------------------------------------------------------
SUCCESSFUL installation of Oracle Sequence Replication support
create mgr
GGSCI (ggos) 6> view params mgr
PORT 7839
DYNAMICPORTLIST 7840-7914
USERID goldengate, PASSWORD goldengate
--AUTOSTART REPLICAT *
AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*,USECHECKPOINTS, MINKEEPDAYS 10
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
create replicat group
GGSCI (ggos) 8> add replicat repa, exttrail ./dirdat/ra, nodbcheckpoint
REPLICAT added.
GGSCI (ggos) 12> view params repa
REPLICAT repa
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID="oraprod")
setenv (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
USERID goldengate, PASSWORD goldengate
--DDLOPTIONS MAPSESSIONSCHEMA ZWC TARGET ZHONGWC
DDL include mapped
ddloptions report
ddlerror 30568, ignore
ddlerror 942, ignore
ddlerror 955, ignore
ddlerror 1430, ignore
ddlerror 54,ignore
ddlerror 904,ignore
ddlerror 4081,ignore
ddlerror 1418,ignore
REPORT AT 01:59
REPORTCOUNT EVERY 30 MINUTES, RATE
REPERROR DEFAULT, ABEND
HANDLECOLLISIONS
assumetargetdefs
DISCARDFILE ./dirrpt/repa.dsc, PURGE, MEGABYTES 1024
DISCARDROLLOVER AT 02:30
ALLOWNOOPUPDATES
GROUPTRANSOPS 2000
BATCHSQL
MAPEXCLUDE ZWC.TAB2;
MAP ZWC.*, TARGET ZWC.*;
--MAP ZWC.*, TARGET ZHONGWC.* ,filter (@range (1, 6));
check source/target status
GGSCI (vzwc1) 1>
info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTA 00:00:00 00:00:00
EXTRACT RUNNING PUMPA 00:00:00 00:00:06
GGSCI (ggos) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPA 00:00:00 00:00:01