Oracle 10.2 流复制问题（四

版权声明：本文为博主原创文章，未经博主允许不得转载。 https://cloud.tencent.com/developer/article/1433116

系统配置：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;

/