联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
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 rollback segment 73 because of 3113 condition FULL status of rollback segment 73 set. Sun Mar 31 14:50:02 2024 FULL status of rollback segment 73 cleared. Sun Mar 31 14:50:41 2024 Restarting dead background process QMN0 QMN0 started with pid=53 Sun Mar 31 14:51:09 2024 Failure to extend rollback segment 73 because of 3113 condition FULL status of rollback segment 73 set. Sun Mar 31 14:51:09 2024 FULL status of rollback segment 73 cleared. Sun Mar 31 14:54:36 2024 Failure to extend rollback segment 73 because of 3113 condition FULL status of rollback segment 73 set. Sun Mar 31 14:54:36 2024 FULL status of rollback segment 73 cleared. Sun Mar 31 14:54:56 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], [], [], [], [], [], []
从上述信息看,由于ora-600 kcbnew_3错误导致70/73号回滚段异常,smon无法正常对其进行扩展,关于ora-600 kcbnew_3报错描述
客户尝试关闭数据库重启,数据库报ora-600 ktsiseginfo1错误，无法正常启动
Sun Mar 31 15:13:03 2024 Shutting down instance: further logons disabled Sun Mar 31 15:15:59 2024 Shutting down instance (immediate) Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition Sun Mar 31 15:15:59 2024 FULL status of rollback segment 73 set. Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition FULL status of rollback segment 73 set. Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition Sun Mar 31 15:15:59 2024 FULL status of rollback segment 73 cleared. Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition Sun Mar 31 15:15:59 2024 FULL status of rollback segment 73 set. Sun Mar 31 15:15:59 2024 Failure to extend rollback segment 73 because of 1089 condition Sun Mar 31 15:15:59 2024 FULL status of rollback segment 73 cleared. Sun Mar 31 15:15:59 2024 FULL status of rollback segment 73 cleared. Sun Mar 31 15:15:59 2024 License high water mark = 161 Sun Mar 31 15:21:04 2024 Active call for process 2878 user 'oracle' program 'oracle@ttperp (TNS V1-V3)' SHUTDOWN: waiting for active calls to complete. Sun Mar 31 15:21:07 2024 Failure to extend rollback segment 73 because of 1089 condition FULL status of rollback segment 73 set. Sun Mar 31 15:21:07 2024 SMON: FULL status of rollback segment 73 cleared. Sun Mar 31 15:21:08 2024 ALTER DATABASE CLOSE NORMAL SMON: disabling tx recovery SMON: disabling cache recovery Sun Mar 31 15:21:16 2024 Shutting down archive processes Archiving is disabled Sun Mar 31 15:21:16 2024 ARCH shutting down Sun Mar 31 15:21:16 2024 ARCH shutting down Sun Mar 31 15:21:16 2024 ARC1: Archival stopped Sun Mar 31 15:21:16 2024 ARC0: Archival stopped Sun Mar 31 15:21:17 2024 Thread 1 closed at log sequence 313828 Successful close of redo thread 1. Sun Mar 31 15:21:18 2024 Completed: ALTER DATABASE CLOSE NORMAL Sun Mar 31 15:21:18 2024 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sun Mar 31 15:23:10 2024 Starting ORACLE instance (normal) Sun Mar 31 15:23:10 2024 Running with 1 strand for Non-Enterprise Edition Sun Mar 31 15:23:10 2024 WARNING: EINVAL creating segment of size 0x0000000065400000 fix shm parameters in /etc/system or equivalent LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Running with 1 strand for Non-Enterprise Edition LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 1000 timed_statistics = TRUE shared_pool_size = 218103808 sga_max_size = 1679366944 large_pool_size = 67108864 java_pool_size = 33554432 control_files = /u2/oradb/oradata/xifenfei/control01.ctl db_block_size = 8192 db_cache_size = 838860800 compatible = 9.2.0.0.0 log_archive_start = TRUE log_archive_dest = /u6/archive_u6 log_archive_format = %s_%t.dbf db_file_multiblock_read_count= 16 fast_start_mttr_target = 0 undo_management = AUTO undo_tablespace = UNDOTBS7 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = xifenfei utl_file_dir = /u1/usr/oracle/utl job_queue_processes = 10 hash_join_enabled = TRUE background_dump_dest = /u2/oradb/admin/xifenfei/bdump user_dump_dest = /u2/oradb/admin/xifenfei/udump core_dump_dest = /u2/oradb/admin/xifenfei/cdump sort_area_size = 104857600 db_name = xifenfei open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 209715200 aq_tm_processes = 1 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 CJQ0 started with pid=8 QMN0 started with pid=9 Sun Mar 31 15:23:11 2024 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=10 ARC0: Archival started ARC1 started with pid=11 Sun Mar 31 15:23:11 2024 ARCH: STARTING ARCH PROCESSES COMPLETE Oracle Data Guard is not available in this edition of Oracle. Sun Mar 31 15:23:11 2024 ARC1: Archival started Sun Mar 31 15:23:11 2024 ARC1: Thread not mounted Sun Mar 31 15:23:11 2024 ARC0: Thread not mounted Sun Mar 31 15:23:11 2024 ALTER DATABASE MOUNT Sun Mar 31 15:23:15 2024 Successful mount of redo thread 1, with mount id 2392685535. Sun Mar 31 15:23:15 2024 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sun Mar 31 15:23:15 2024 ALTER DATABASE OPEN Sun Mar 31 15:23:15 2024 LGWR: Primary database is in CLUSTER CONSISTENT mode Thread 1 opened at log sequence 313828 Current log# 5 seq# 313828 mem# 0: /u3/oracle/xifenfei/redolog/redo05a.log Current log# 5 seq# 313828 mem# 1: /u4/oracle/xifenfei/redolog/redo05b.log Successful open of redo thread 1. Sun Mar 31 15:23:17 2024 SMON: enabling cache recovery Sun Mar 31 15:23:17 2024 Undo Segment 69 Onlined Undo Segment 70 Onlined Undo Segment 71 Onlined Undo Segment 72 Onlined Sun Mar 31 15:23:21 2024 Errors in file /u2/oradb/admin/xifenfei/udump/xifenfei_ora_4384.trc: ORA-00600: 内部错误代码，参数: [ktsiseginfo1], [20], [65], [73], [], [], [], [] Sun Mar 31 15:23:22 2024 Errors in file /u2/oradb/admin/xifenfei/udump/xifenfei_ora_4384.trc: ORA-00600: 内部错误代码，参数: [ktsiseginfo1], [20], [65], [73], [], [], [], [] Error 600 happened during db open, shutting down database USER: terminating instance due to error 600 Instance terminated by USER, pid = 4384 ORA-1092 signalled during: ALTER DATABASE OPEN...
启动的时候由于回滚段异常导致该问题,临时解决问题可以通过规避掉异常回滚段open库,但是这个问题的本质是由于seg$和undo$中记录不匹配导致,建议进一步通过hcheck进行检查分析,并进行后续处理,参考mos相关描述:
