高手们,帮助看看,如何解决ora-600问题

[复制链接]
查看11 | 回复9 | 2013-7-18 13:55:12 | 显示全部楼层 |阅读模式
Wed May6 08:26:03 2009
Thread 1 advanced to log sequence 9881 (LGWR switch)
Current log# 2 seq# 9881 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9881 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 08:38:40 2009
Thread 1 advanced to log sequence 9882 (LGWR switch)
Current log# 1 seq# 9882 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9882 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 08:48:00 2009
Thread 1 advanced to log sequence 9883 (LGWR switch)
Current log# 2 seq# 9883 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9883 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 08:51:41 2009
Thread 1 cannot allocate new log, sequence 9884
Checkpoint not complete
Current log# 2 seq# 9883 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9883 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 08:51:41 2009
Thread 1 advanced to log sequence 9884 (LGWR switch)
Current log# 1 seq# 9884 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9884 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:00:27 2009
Trace dumping is performing id=[cdmp_20090506090028]
Wed May6 09:00:33 2009
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl1_m000_21672.trc:
ORA-00600: internal error code, arguments: [kole_t2u], [34], [], [], [], [], [], []
Wed May6 09:00:56 2009
Trace dumping is performing id=[cdmp_20090506090042]
Wed May6 09:01:11 2009
Trace dumping is performing id=[cdmp_20090506090042]
Wed May6 09:01:44 2009
Thread 1 advanced to log sequence 9885 (LGWR switch)
Current log# 2 seq# 9885 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9885 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 09:09:50 2009
Thread 1 advanced to log sequence 9886 (LGWR switch)
Current log# 1 seq# 9886 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9886 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:14:34 2009
Thread 1 cannot allocate new log, sequence 9887
Checkpoint not complete
Current log# 1 seq# 9886 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9886 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:14:34 2009
Thread 1 advanced to log sequence 9887 (LGWR switch)
Current log# 2 seq# 9887 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9887 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 09:18:59 2009
Thread 1 advanced to log sequence 9888 (LGWR switch)
Current log# 1 seq# 9888 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9888 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:27:58 2009
Thread 1 advanced to log sequence 9889 (LGWR switch)
Current log# 2 seq# 9889 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9889 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 09:34:17 2009
Thread 1 advanced to log sequence 9890 (LGWR switch)
Current log# 1 seq# 9890 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9890 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:39:28 2009
Thread 1 advanced to log sequence 9891 (LGWR switch)
Current log# 2 seq# 9891 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9891 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 09:43:38 2009
Thread 1 cannot allocate new log, sequence 9892
Checkpoint not complete
Current log# 2 seq# 9891 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9891 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 09:43:39 2009
Thread 1 advanced to log sequence 9892 (LGWR switch)
Current log# 1 seq# 9892 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9892 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:47:07 2009
Thread 1 cannot allocate new log, sequence 9893
Checkpoint not complete
Current log# 1 seq# 9892 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9892 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:47:09 2009
Thread 1 advanced to log sequence 9893 (LGWR switch)
Current log# 2 seq# 9893 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9893 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 09:50:58 2009
Thread 1 cannot allocate new log, sequence 9894
Checkpoint not complete
Current log# 2 seq# 9893 mem# 0: +DATA/orcl/onlinelog/group_2.264.652386007
Current log# 2 seq# 9893 mem# 1: +DATA/orcl/onlinelog/group_2.265.652386007
Wed May6 09:50:59 2009
Thread 1 advanced to log sequence 9894 (LGWR switch)
Current log# 1 seq# 9894 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9894 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:54:20 2009
Thread 1 cannot allocate new log, sequence 9895
Checkpoint not complete
Current log# 1 seq# 9894 mem# 0: +DATA/orcl/onlinelog/group_1.262.652386005
Current log# 1 seq# 9894 mem# 1: +DATA/orcl/onlinelog/group_1.263.652386005
Wed May6 09:54:21 2009
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
参考metalink 553528.1
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
原帖由 howard_zhang 于 2009-5-6 11:59 发表
参考metalink 553528.1

回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
问题1:日志切换太频繁,可以考虑增加REDO 组 或者 增大日志大小
问题2:应该是BUG 5970258
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
就是bug
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
是bug, 我们的数据库也出现过一次
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
这么说,没有法子解决了吗?大牛们!
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
原帖由 howard_zhang 于 2009-5-6 12:04 发表
问题1:日志切换太频繁,可以考虑增加REDO 组 或者 增大日志大小
问题2:应该是BUG 5970258

这个不是办法吗
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
是bug就打patch啊。
回复

使用道具 举报

千问 | 2013-7-18 13:55:12 | 显示全部楼层
原帖由 五“宅”一生 于 2009-5-6 21:04 发表
是bug就打patch啊。

请问这个该打什么补丁啊,有具体步骤吗
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行