以前安装的比较乱,想重新测试一次,重新做了如下:
以前有DDL操作,但目前删除了DDL的部分,目前不涉及DDL操作。
源端:
1,add trandata test2.*
2,GGSCI (host1) 41> view param mgr
port 7809
3,GGSCI (host1) 43> view param ext1
extract ext1
userid ggs,password ggs
exttrail /home/oracle/lt
table test2.t;
4,GGSCI (host1) 44> view param ./globals
GGSCHEMA ggs
CHECKPOINTTABLE ggs.checkpoint
5,GGSCI (host1) 46> view param dpump
EXTRACT dpump
USERID ggs, PASSWORD ggs
rmthost 192.168.0.101,mgrport 7809
rmttrail /home/oracle/gg/discard/lt
noPASSTHRU
TABLE test2.t;
6,
GGSCI (host1) 47> add extract ext1,tranlog, begin now
EXTRACT added.
GGSCI (host1) 48> add exttrail /home/oracle/lt, extract ext1
EXTTRAIL added.
7,
GGSCI (host1) 50> add extract dpump,exttrailsource /home/oracle/lt
EXTRACT added.
GGSCI (host1) 51> add rmttrail /home/oracle/gg/discard/lt, extract dpump
RMTTRAIL added.
目标端:
1,GGSCI (host2) 16> view param mgr
port 7809
2,GGSCI (host2) 17> view param rep1
replicat rep1
userid ggs,password ggs
assumetargetdefs
discardfile /home/oracle/gg/discard/repsz.dsc,append,megabytes 100
map test2.*, target test2.*;
3,
GGSCI (host1) 52> view param ./globals
GGSCHEMA ggs
CHECKPOINTTABLE ggs.checkpoint
4,
GGSCI (host2) 18> add replicat rep1,exttrail /home/oracle/gg/discard/lt, checkpointtable ggs.checkpoint
REPLICAT added.
问题是:start rep1,出错:
2012-02-03 10:09:31ERROR OGG-00458Oracle GoldenGate Delivery for Oracle, rep1.prm:Cannot find metadata property DDL_MK_DDLSTATEMENT.DDL metadata [? ????t??
??u???\??3?`?9?$/?M???'?q*??B>? ??].
2012-02-03 10:09:31ERROR OGG-01668Oracle GoldenGate Delivery for Oracle, rep1.prm:PROCESS ABENDING.
网上没有找到相关说明,可能是说明原因呢?如何处理呢?
|