ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Bug 4369756 - Log apply may dump [krvsmso]

Bug 4369756 - Log apply may dump [krvsmso]

原创 Linux操作系统 作者:lijiebin 时间:2010-12-06 16:26:38 0 删除 编辑

Sat Dec  4 04:05:58 2010

Errors in file /u01/app/oracle/admin/xxaadb/bdump/xxaadb_p012_549.trc:

ORA-07445: exception encountered: core dump [krvsmso()+1379] [SIGSEGV] [Address not mapped to object] [0x000000004] [] []

Sat Dec  4 04:06:32 2010

Errors in file /u01/app/oracle/admin/xxaadb/bdump/xxaadb_lsp0_2327.trc:

ORA-12805: parallel query server died unexpectedly

LOGSTDBY Apply process P020 pid=97 OS id=23901 stopped

LOGSTDBY Apply process P013 pid=50 OS id=23887 stopped

LOGSTDBY Apply process P024 pid=105 OS id=23909 stopped

LOGSTDBY Apply process P026 pid=109 OS id=23913 stopped

LOGSTDBY Apply process P018 pid=90 OS id=23897 stopped

LOGSTDBY Apply process P023 pid=104 OS id=23907 stopped

LOGSTDBY Apply process P021 pid=99 OS id=23903 stopped

LOGSTDBY Apply process P017 pid=81 OS id=23895 stopped

LOGSTDBY Apply process P025 pid=107 OS id=23911 stopped

LOGSTDBY Apply process P019 pid=93 OS id=23899 stopped

Sat Dec  4 04:06:32 2010

TLCR process death detected. Shutting down TLCR

logminer process death detected, exiting logical standby

LOGSTDBY Analyzer process P010 pid=46 OS id=23881 stopped

LOGSTDBY Apply process P011 pid=47 OS id=23883 stopped

LOGSTDBY Apply process P022 pid=100 OS id=23905 stopped

LOGSTDBY Apply process P016 pid=77 OS id=23893 stopped

LOGSTDBY Apply process P015 pid=76 OS id=23891 stopped

LOGSTDBY Apply process P014 pid=51 OS id=23889 stopped

Sat Dec  4 04:20:05 2010

RFS LogMiner: Client enabled and ready for notification

Sat Dec  4 04:20:06 2010

Primary database is in MAXIMUM PERFORMANCE mode

 

 

Cause
The cause of this problem has been identified and verified in an unpublished Bug 4369756. It is caused by a race condition between the LSP2 process as it validates object metadata and the other SQL Apply processes.

 

我的理解

lsp进程和sql apply 进程 同时更新对象表I_OBJ#(object_id=3) 或者tab$(object_id=4)引起的

 

Solution
The condition is cleared with the automatic restart of SQL Apply.  No other action is necessary.

This issue is fixed in Oracle11g Release 1 and the 10.2.0.4 patchset.  Some one-off patches may be available for 10.1.0.5 and up.  Check Metalink for patch availability: Patch 4369756.

 

 

Oracle 说是会自动的restart sql apply,其实有时候apply 根本就停不下来。

解决方法就是打补丁。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8135069/viewspace-681002/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-10

  • 博文量
    145
  • 访问量
    152111