A bug found
来源:互联网 发布:mac系统安装win7 编辑:程序博客网 时间:2024/05/18 04:51
Got an error from alert log:
Tue Mar 8 04:54:18 2011
Errors in file /global/oracle1/centDB/admin/centDB/udump/centdb_ora_8749.trc:
ORA-07445: exception encountered: core dump [_memcmp()+88] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
SQL> SELECT NAME, VALUE
2 FROM V$SYSSTAT
3 WHERE NAME = 'redo buffer allocation retries';
NAME VALUE
---------------------------------------------------------------- ----------
redo buffer allocation retries 387582
SQL> SELECT a.name,b.value
2 FROM v$statname a,v$sysstat b
3 WHERE a.statistic# = b.statistic#
AND a.name like '%redo%'; 4
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 42621021
redo synch time 42146939
redo blocks read for recovery 0
redo entries 229665272
redo size 3.7509E+11
redo buffer allocation retries 387582
redo wastage 5160641384
redo writer latching time 1297
redo writes 27577242
redo blocks written 762220497
redo write time 50104443
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 8977
redo log space wait time 273809
redo log switch interrupts 0
redo ordering marks 19457235
redo subscn max counts 0
16 rows selected.
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
log file parallel write 6,467 109 17 73.5 System I/O
log file sync 6,411 75 12 50.5 Commit
db file parallel write 1,301 70 53 47.0 System I/O
CPU time 49 33.3
log buffer space 54 40 750 27.4 Configurat
But the database is not busy during the timeframe:
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 38796 08-Mar-11 04:00:06 38 1.2
End Snap: 38797 08-Mar-11 05:00:08 38 1.3
Elapsed: 60.02 (mins)
DB Time: 2.47 (mins)
So I doubt it is a bug:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Solaris: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Searched it from MOS and found Bug 4591936
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3
This problem can occur on any platform.
Symptoms
Trace files are getting generated with following errors logged in trace files:
*** 2006-06-13 22:24:29.826
*** SERVICE NAME:() 2006-06-13 22:24:29.825
*** SESSION ID:(166.1) 2006-06-13 22:24:29.825
Maximum redo generation record size = 132096 bytes
Maximum redo generation change vector size = 98708 bytes
*** 2006-06-13 22:24:57.649
Media recovery not enabled or manual archival only 0x10000
Media recovery not enabled or manual archival only 0x10000
Media recovery not enabled or manual archival only 0x10000
Media recovery not enabled or manual archival only 0x10000
Cause
Bug 4591936
Abstract: KCCSGA_UPDATE_CKPT,KCCDEBUG_LEVEL,MEDIA RECOVERY MESSAGES ARE LOGGED AT STARTUP
Fixed In Ver: 11.0
Solution
These messages were added for debugging purpose and can be ignored.
Delete these files manually or use some job to clean up diskspace.
A one-off patch is available on top of 10.2.0.3 for following platforms
- HP-UX Itanium
- Solaris 64 Bit
Bug is fixed in 10.2.0.4, 11.1.0.6 and higher versions.
To download:
1. Go to metalink.oracle.com
2. On top left hand side under Quick Find from the drop down list choose "Patch Number" and provide the patch number as 4591936 in the box below it. Click go.
3. In the following page, choose your platform and download the patch. ( This will list all the plaforms for which patch is available )
Please follow the readme.txt for instruction on how to apply the patch.
Please note that these one-off patches are not regression tested and hence you are advised to apply the same on a test server before applying it on a production box.
References
BUG:4591936 - KCCSGA_UPDATE_CKPT,KCCDEBUG_LEVEL,MEDIA RECOVERY MESSAGES ARE LOGGED AT STARTUP
- A bug found
- I found a bug with CCParticleSystem.m
- found new bug
- a bug in virtualbox
- A Bug's Life
- a bug--do...while()
- A Bug's Life
- A Bug's Life
- A Bug's Life
- A Bug's Life
- A Bug's Life
- A Bug's Life
- A bug‘s life
- A Bug's Life
- A Bug's Life
- A Bug's Life
- BUG-getContainingNode(): node module not found
- A Bug's LifeA Bug's Life
- 漳浦:求真务实 开创漳浦县小学教(科)研工作的新局面
- 关系数据库不具有可扩展性(SQL Databases Don't Scale)
- 虚拟服务器负载均衡实现方法
- vs2010调试 visualizer debugger
- 任务计划怎么不自动运行
- A bug found
- 概念问题自解释
- Create trigger
- WebLogic服务器环境下打开附件(.rar/.zip/.doc/.xls)出错的解决方法
- 唐骏:职业经理人永远是老二
- MySQL 备份和恢复策略三、使用mysqldump备份数据库
- MySQL数据库管理常用命令
- 喜欢黑暗的程序员
- Silverlight 学习笔记——MVVM模式实现主从数据显示