ORA-600 ktsiseginfo1故障---惜分飞

本文详细记录了一次Oracle9i数据库在运行过程中遇到ORACLE-600kcbnew_3错误的事件,涉及回滚段操作和SMON功能,以及重启尝试中的新错误。解决方案建议通过hcheck检查和修复潜在的seg$和undo$问题。

oracle 9i的库在运行途中突然报ORA-600 kcbnew_3错误

Sun Mar 31 14:25:11 2024

Undo Segment 69 Onlined

Sun Mar 31 14:25:11 2024

Created Undo Segment _SYSSMU69$

Sun Mar 31 14:25:11 2024

Created Undo Segment _SYSSMU70$

Undo Segment 70 Onlined

Sun Mar 31 14:28:41 2024

Starting control autobackup

Control autobackup written to SBT_TAPE device

    comment 'API Version 2.0,MMS Version 1.2.0.0',

    media 'A90063L4'

    handle 'c-1757743655-20240331-01'

Sun Mar 31 14:31:07 2024

Starting control autobackup

Control autobackup written to SBT_TAPE device

    comment 'API Version 2.0,MMS Version 1.2.0.0',

    media 'A90063L4'

    handle 'c-1757743655-20240331-02'

Sun Mar 31 14:34:31 2024

SMON offlining US=70

Sun Mar 31 14:34:31 2024

Created Undo Segment _SYSSMU73$

Undo Segment 73 Onlined

Sun Mar 31 14:34:31 2024

Created Undo Segment _SYSSMU74$

Undo Segment 74 Onlined

Sun Mar 31 14:34:31 2024

Created Undo Segment _SYSSMU81$

Undo Segment 81 Onlined

Sun Mar 31 14:37:36 2024

Errors in file /u2/oradb/admin/xifenfei/udump/xifenfei_ora_3741.trc:

ORA-00600: 内部错误代码,参数: [kcbnew_3], [156], [], [], [], [], [], []

Sun Mar 31 14:39:22 2024

Errors in file /u2/oradb/admin/xifenfei/bdump/xifenfei_smon_6890.trc:

ORA-01595: error freeing extent (6) of rollback segment (70))

ORA-00600: internal error code, arguments: [kcbnew_3], [156], [], [], [], [], [], []

Sun Mar 31 14:45:05 2024

Errors in file /u2/oradb/admin/xifenfei/udump/xifenfei_ora_4046.trc:

ORA-00600: 内部错误代码,参数: [kcbnew_3], [156], [], [], [], [], [], []

Sun Mar 31 14:47:47 2024

Failure to extend rollback segment 73 because of 3113 condition

FULL status of rollback segment 73 set.

Sun Mar 31 14:47:47 2024

FULL status of rollback segment 73 cleared.

Sun Mar 31 14:48:03 2024

Errors in file /u2/oradb/admin/xifenfei/udump/xifenfei_ora_4074.trc:

ORA-00600: 内部错误代码,参数: [kcbnew_3], [156], [], [], [], [], [], []

Sun Mar 31 14:48:35 2024

Errors in file /u2/oradb/admin/xifenfei/bdump/xifenfei_qmn0_4044.trc:

ORA-00600: internal error code, arguments: [kcbnew_3], [156], [], [], [], [], [], []

Sun Mar 31 14:50:01 2024

Failure to extend ro

评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值