月度归档:2013年04月

convert goldengate to integrated mode

init.ora
*.compatible='11.2.0.3'
*.streams_pool_size=4096m

ext01.prm
--@@TRANLOGOPTIONS ASMUSER SYS@+ASM1, ASMPASSWORD welcome1
--@@TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 4194304, BUFSIZE 8388608
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 2048, _LOGMINER_READ_BUFFERS 128, parallelism 16)

create.obey
--ADD EXTRACT ext01, TRANLOG, THREAD 1,  BEGIN NOW
ADD EXTRACT ext01, INTEGRATED TRANLOG, BEGIN NOW

but there is errors when start extract 继续阅读