这两天碰到的全是ora-600错误

今天又碰到一个ora-00600错误，应该又是一个由于索引引起的错误，找到相关索引rebuild online，解决：

ORA-00600: internal error code, arguments: [6002], [0], [30], [2], [0], [], [], []
资料如下：

ORA-600 [6002] "Index block check" [ID 47449.1]

Note: For additional ORA-600 related information please read Note:146580.1

PURPOSE:
This article discusses the internal error "ORA-600 [6002]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.

ERROR:
ORA-600 [6002] [a] [b] [c] [d]

VERSIONS:
versions 6.0 to 10.1

DESCRIPTION:

Oracle was trying to insert a key and key data into a b*tree index.

In order to do this, it had to first find the correct leaf block to
do the insert.

Once the correct leaf block is retrieved, Oracle validates the block
by checking the data size and number of columns in the key.

If there is a mismatch then ORA-600 [6002] is reported.

ARGUMENTS:
Arg [a] Number of bytes in keydata
Arg [b] Number of bytes in the index layer of the leaf header
Arg [c] Number of columns in index search key structure
Arg [d] Number of columns in the index layer fo the leaf header

FUNCTIONALITY:
Kernel Data layer Index

IMPACT:
PROCESS FAILURE
Possible INDEX corruption.
No corruption to underlying data.

SUGGESTIONS:

Check for problem indexes associated with any tables involved in
the failing SQL statement.

ANALYZE TABLE VALIDATE STRUCTURE CASCADE;

Drop and recreate any indexes that are reported as being a problem.

If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.

Known issues:



Known Bugs

NB	Bug	Fixed	Description
	6621940	10.2.0.5, 11.2.0.1	Corruption after MOVE of an empty partition with local indexes
	4596807	10.2.0.4, 11.1.0.6	OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes
	4357181	10.1.0.5, 10.2.0.1	OERI[6002] from transported IOT created with COMPATIBLE < 10.0
*	3785200	9.2.0.6, 10.1.0.2	Corruption possible in automatic space managed segments See NOTE:281047.1
*	1475310	8.1.7.1, 9.0.1.0	ALTER INDEX .. REBUILD ONLINE/ MOVE IOT ONLINE can corrupt the index See NOTE:125149.1

[@more@]

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

转载于:http://blog.itpub.net/41451/viewspace-1052721/