系统配置:Linux CentOS 5、Oracle Enterprise Edition Release 10.2.0.1.0、表级单向流复制 问题现象:流复制失效,源表更新,目标表没有更新 排错过程:
1) 查看捕获进程状态 select capture_name,status from dba_capture;
Capture status 为ABORTED
2) 查看alert_<sid>.log krvxerpt: Errors detected in process 65, role builder. krvxmrs: Leaving by exception: 1341 ORA-01341: LogMiner out-of-memory LOGMINER: session#=42, builder MS01 pid=65 OS id=29684 sid=1018 stopped Streams CAPTURE CP01 for ####### with pid=62, OS id=29652 stopped ORA-01280: Fatal LogMiner Error.
3) 查看跟踪文件中的日志挖掘进程
Spill: can not find enough to spill. amountNeeded: 1993904 Session MaxMem 10485760, CacheSize 129264, MemSize 129264
4) 获得源库流复制参数 select decode(process_type,1,'APPLY',2,'CAPTURE') process_name, name, value from sys.streams$_process_params order by 1,2;
5) 在源库更改流复制的_SGA_SIZE参数
BEGIN
dbms_capture_adm.set_parameter(capture_name => 'CAPTURE1',
parameter => '_SGA_SIZE',
VALUE => '100');
END;
/