0 积分	0 好友	4 主题

发消息

[备份恢复] 10.2.0.4逻辑standby异常，buffer 溢出

1^#

发表于 2013-8-7 12:56:25 | 查看: 2091| 回复: 0

主库：10.2.0.4.0
逻辑备库：10.2.0.4.0
OS：Linux Yy085 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST 2007 x86_64 x86_64 x86_64 GNU/Linux
目前逻辑备库无法start apply 进程，从日志上可以看出，报ora-00604等错误。
我试着加大 execute dbms_logstdby.apply_set('MAX_SGA',1000); 原本为500M，加大到1000,2000,4000 都没有任何的效果，报错信息依然如此。
目前主库的归档日志正常传递到逻辑备库，只是不应用日志。
查询相关视图，结果如下：

sys@CMSLOGIC> select sid,type,status_code,status from v$logstdby_process;

no rows selected

sys@CMSLOGIC> select * from (select * from dba_logstdby_events order by 1 desc ) where rownum<5;

EVENT_TIME       EVENT_TIMESTAMP                                                          CURRENT_SCN COMMIT_SCN    XIDUSN    XIDSLT    XIDSQN
------------------- --------------------------------------------------------------------------- ----------- ---------- ---------- ---------- ----------
EVENT                                                                         STATUS_CODE
-------------------------------------------------------------------------------- -----------
STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2013-08-07 10:51:03 07-AUG-13 10.51.03.209257 AM
                                                                                    16111
ORA-16111: log mining and apply setting up

2013-08-07 10:51:03 07-AUG-13 10.51.02.979566 AM
                                                                                    16222
ORA-16222: automatic Logical Standby retry of last action

2013-08-07 10:50:16 07-AUG-13 10.50.15.706722 AM
                                                                                    16111
ORA-16111: log mining and apply setting up

2013-08-07 10:34:15 07-AUG-13 10.34.14.717896 AM
                                                                                    16222
ORA-16222: automatic Logical Standby retry of last action

sys@CMSLOGIC> select * from v$Logstdby_progress;

APPLIED_SCN APPLIED_TIME       RESTART_SCN RESTART_TIME       LATEST_SCN LATEST_TIME       MINING_SCN MINING_TIME
----------- ------------------- ----------- ------------------- ---------- ------------------- ---------- -------------------
2.3537E+11 2013-08-05 18:49:44  2.3537E+11 2013-08-05 18:27:14 2.3680E+11 2013-08-07 12:53:40

刘大，请帮忙看一下吧，万分感谢！