在帮客户解决了
《数据库打开之后ORA-00600 [4194]报错的处理》:http://space.itpub.net/23135684/viewspace-758997
《ORA-27050 ORA-27077问题的处理》:http://space.itpub.net/23135684/viewspace-758998错误之后,运行一段时间出现了大量的ora-00600 [ktspgetmyb-1]的报错。
客户数据库是Oracle RAC Database 10.2.0.3 for Linux x86_64bit, 经过网上的搜索找到了最接近问题原因的文章:
Subject: Bug 6086497 - OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
Doc ID: 6086497.8 Type: PATCH
Modified Date : 24-SEP-2008 Status: PUBLISHED
Bug 6086497 OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
This note gives a brief overview of bug 6086497.
The content was last updated on: 21-MAY-2008
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11.2
Versions confirmed as being affected 9.2.0.8
10.2.0.3
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in 11.2 (Future Release)
10.2.0.4 (Server Patch Set)
11.1.0.7 (Server Patch Set)
Symptoms: Related To:
Internal Error May Occur (ORA-600)
Corruption
ORA-600 [ktspgetmyb-1]
Truncate
ASSM Space Management (Bitmap Managed Segments)
Description
It is possible for ASSM segments to become corrupt,
especially following an interupt (Ctrl-C) operation.
This fix replaces the fix for bug 3279497 addressing both that
problem and issues introduced by that fix.
Note: This fix is superceded by the fix in bug 6844739
从上面的描述可以看出,在10.2.0.3版本的数据库上存在bug会导致该错误的产生,在10.2.0.4版本的数据库已经修改了该bug。解决方法:客户自己将表重建,将旧表的数据导入新表,问题得到解决。
因此,解决这个问题有两个办法,1).重建表,导入旧数据。2).升级数据库版本。
参考文章:《ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KTSPGETMYB-1],ORACLE的超级连环大BUG》:http://zhang41082.itpub.net/post/7167/479347
--end--