oracle資料庫：11G
goldengate：11G
源端配置：
管理行程：
GGSCI (zjg) 118> edit params mgr
PORT 7809
DYNAMICPORTLIST 7800-7900
AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 3
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
抽取行程：
GGSCI (zjg) 117> edit params ext1
extract ext1
userid ogg,password ogg
dynamicresolution
setenv (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
setenv (ORACLE_HOME = "/u01/app/oracle/product/11204/db_1")
setenv (ORACLE_SID = orcl)
ddl include all
ddloptions addtrandata,report
exttrail ./dirdat/t1
table ogg.*;
pump行程：
GGSCI (zjg) 119> edit params ext2
extract ext2
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.*;
目標端：
GGSCI (zjg) 7> edit params mgr
PORT 7809
DYNAMICPORTLIST 7800-7900
AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 3
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
復制行程：
GGSCI (zjg) 8> edit params repl1
REPLICAT repl1
setenv (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
setenv (ORACLE_SID = orcl)
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, megabytes 50
map ogg.*, target ogg.*;
這樣配置完后，DDL操作可以實作，而DML卻不能同步。如果單純DML配置是可以用的。請問怎么解決
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/96325.html
標籤：基礎和管理