数据库每天晚上在alter日志中出现ORA-00600错误
dbdao吧
全部回复
仅看楼主
level 2
heyongqin2010 楼主
请教下出现错误的原因及处理办法
环境:
Linux5.2*64+oracle10.2.0.4.0 RAC(2node)
现象:
在数据库alter日志中每天晚上出现下面的错误信息
Tue Aug 4 23:14:36 2015
Errors in file /opt/oracle/admin/db/bdump/db1_m000_5773.trc:
Tue Aug 4 23:14:48 2015
Trace dumping is performing id=[cdmp_20
15080423144
8]
Tue Aug 4 23:14:54 2015
Thread 1 advanced to log sequence 50331 (LGWR switch)
Current log
# 7 seq#
50331 mem# 0: /oracle01/oradata/db/redo07.log
Tue Aug 4 23:15:23 2015
Thread 1 advanced to log sequence 50332 (LGWR switch)
Current log# 8 seq
# 50332 mem#
0: /oracle01/oradata/db/redo08.log
Tue Aug 4 23:15:48 2015
Thread 1 advanced to log sequence 50333 (LGWR switch)
Current log
# 5 seq#
50333 mem# 0: /oracle01/oradata/db/redo05.log
Tue Aug 4 23:16:10 2015
Thread 1 advanced to log sequence 50334 (LGWR switch)
Current log# 6 seq
# 50334 mem#
0: /oracle01/oradata/db/redo06.log
Tue Aug 4 23:16:28 2015
Errors in file /opt/oracle/admin/db/bdump/db1_m000_5773.trc:
ORA-00600: internal error code, arguments: [13011], [3737], [12583882], [65], [12583882], [17], [], []
Tue Aug 4 23:16:31 2015
Trace dumping is performing id=[cdmp_20
15080423163
1]
trace日志见 百度网盘
谢谢!
2015年08月05日 07点08分 1
level 13
oer 8102.2 - obj# 4217, rdba: 0x00c0d527(afn 3, blk# 54567)
kdk key 8102.2:
ORA-00600: internal error code, arguments: [13011], [3737], [12583882], [65], [12583882], [17], [], []
Current SQL statement for this session:
DELETE FROM WRI$_ADV_REC_ACTIONS A WHERE A.TASK_ID = :B1
----- PL/SQL Call Stack -----
odm finding:
ORA-600 [13011] on Delete (Doc ID 456361.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 16-May-2013***
SYMPTOMS
ORA-600[13011] encountered when deleting rows.
Analyze of the table and indexes in question does not fail with errors.
CAUSE
Bug 6112730 - ORA-600 [13011] WHEN DELETING FROM TABLE
closed as a duplicate of
Bug 7007924 - WRONG RESULT FROM BITMAP INDEX
To reproduce the error/bug the following must be seen:
1) We have for both table and index stats gathered
2) Execution plan shows BITMAP CONVERSION
3) Error doesn't reproduce if any one of the indexes are dropped
REPRODUCIBILITY:
9.2.0.8 (64-Bit): No
9.2.0.8 (32-Bit): Yes
10.2.0.1/10.2.0.2: Yes
10.2.0.3 : Yes (but ORA-7445[_intel_fast_memcmp] instead of ORA-600[13011])
SOLUTION
Upgrade to 11.2 where the bug has been fixed
- OR -
For 10gR2, aply patch set 10.2.0.4 or higher
- OR -
Apply Patch 7007924 if available for your platform and Oracle version
- OR -
Use any of next workarounds:
a) Disable statistics on the affected table.
b) use a RULE hint, e.g.
DELETE /*+ RULE */ ........
c) set _b_tree_bitmap_plans=false in init.ora
2015年08月11日 12点08分 2
level 13
oer 8102.2 - obj# 4217, rdba: 0x00c0d527(afn 3, blk# 54567)
kdk key 8102.2:
该错误应当标明 WRI$_ADV_REC_ACTIONS表对应的索引上存在一些corruption ,你可以选择drop 后重建该表的所有索引
2015年08月11日 12点08分 3
level 4
是不是WRI$_ADV_REC_ACTIONS 这个表的位图索引有问题哦。这样的系统表,重建索引也是相同的方法是不是啊?
2015年08月12日 01点08分 4
1