ora-00600 [ktspgetmyb-1]問題的處理

尛樣兒發表於2013-04-22

        在幫客戶解決了
《資料庫開啟之後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--




來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-759043/,如需轉載,請註明出處,否則將追究法律責任。

相關文章