: oracle database 11 g
Goldengate: 11 g
The source side configuration:
Management process:
GGSCI (ZJG) 118 & gt; Edit params MGR
The PORT 7809
DYNAMICPORTLIST 7800-7900
AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 3
PURGEOLDEXTRACTS./dirdat/*, usecheckpoints, minkeepdays 3
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
Extraction process:
GGSCI (ZJG) 117 & gt; Edit params the ext
Extract the ext
Userid ogg, password ogg
Dynamicresolution
The setenv (NLS_LANG="AMERICAN_AMERICA. AL32UTF8")
The setenv (ORACLE_HOME="/u01/app/oracle/product/11204/db_1")
The setenv (ORACLE_SID=former)
DDL include all
Ddloptions addtrandata, report
Exttrail./dirdat/t1
Table ogg. *;
Pump process:
GGSCI (ZJG) 119 & gt; Edit params however
Extract however
The SETENV (NLS_LANG="AMERICAN_AMERICA. AL32UTF8")
Userid ogg, password ogg
RMTHOST 192.168.31.101 mgrport 7809
RMTTRAIL/u01/app/oracle/product/ogg/dirdat/t2
Table ogg. *;
End goals:
GGSCI (ZJG) 7 & gt; Edit params MGR
The PORT 7809
DYNAMICPORTLIST 7800-7900
AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 3
PURGEOLDEXTRACTS./dirdat/*, usecheckpoints, minkeepdays 3
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
Replication process:
GGSCI (ZJG) 8 & gt; Edit params repl1
REPLICAT repl1
The setenv (NLS_LANG="AMERICAN_AMERICA. AL32UTF8")
The setenv (ORACLE_SID=former)
Userid ogg, password ogg
ASSUMETARGETDEFS
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
Ddlerror default ignore retryop maxretries 3 retrydelay 5
Discardfile/u01/app/oracle/product/ogg/discard. SQL, append, 50 megabytes
The map ogg. *, target ogg. *;
After this configuration, the DDL operation can be realized, and the DML is not synchronized, if simple DML configuration can be used, could you tell me how to solve the