Home > database >  Ogg DDL and DML cannot be used at the same time how to solve
Ogg DDL and DML cannot be used at the same time how to solve

Time:09-29

: 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
  • Related