10.2.0.5逻辑DG同步异常

pywangwei

操作系统：IBM AIX 5.3
数据库版本：10.2.0.5
存在的问题：逻辑备库同步过程中
SELECT * FROM v$logstdby_process;
结果：BUILDER        16243        ORA-16243: paging out 48552 bytes of memory to disk
一直是paging out，日志无法同步
附件是select * from dba_logstdby_events  中的数据

select * from v$logstdby_stats中数据如下：
number of preparers        4
number of appliers        15
maximum SGA for LCR cache        4095
parallel servers in use        22
maximum events recorded        100
preserve commit order        TRUE
transaction consistency        FULL
record skip errors        Y
record skip DDL        Y
record applied DDL        N
record unsupported operations        N
coordinator state        IDLE
transactions ready        1
transactions applied        0
coordinator uptime        2695
realtime logmining        Y
apply delay        0
Log Miner session ID        1
txns delivered to client        3928576
DML txns delivered        3777007
DDL txns delivered        271
CTAS txns delivered        52
Recursive txns delivered        151298
Rolled back txns seen        56404
LCRs delivered to client        32244538
bytes of redo processed        18029799220
bytes paged out        40417072
seconds spent in pageout        1359
bytes checkpointed        0
seconds spent in checkpoint        0
bytes rolled back        42768
seconds spent in rollback        3
seconds system is idle        0

请刘大和各位朋友帮忙分析一下原因，谢谢！

pywangwei

昨天处理操作是：
begin
   dbms_logstdby.skip('ALTER TABLE','CUECM','T_REPORT_REALTIME_ITEM_2');
   dbms_logstdby.skip('DML','CUECM','T_REPORT_REALTIME_ITEM');
end;
结果还是有paging out发生

Maclean Liu(刘相兵

[oracle@mlab2 ~]$ oerr ora 16243
16243, 00000, "paging out %s bytes of memory to disk"
// *Cause:  Builder process is paging out momery to free up space in lcr
//          cache.
// *Action: No action necessary, this informational statement is provided
//          to record the event for diagnostic purposes.


find some solution:


1.  shutdown immediate the logical standby database
2.  startup the logical standby database
3.  increased max_sga for lcr cache
4.  set up a skip procedure for the object we're 99% sure is the object in
question

Maclean Liu(刘相兵

max_sga  增加过了吗？  之前有很大的事务？

pywangwei

Maclean Liu(刘相兵 发表于 2013-11-17 15:10
max_sga  增加过了吗？  之前有很大的事务？

增加过了，从4095调到了10240还是不行，后来用通过跳过事务的方法跳过去好了
http://blog.sina.com.cn/s/blog_61cd89f60102eemt.html  这是我的处理过程
谢谢刘大指点!