标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,666)
- DB2 (22)
- MySQL (73)
- Oracle (1,528)
- Data Guard (51)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (65)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (559)
- Oracle安装升级 (90)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (77)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
- 数据库启动报ORA-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
- 如何修改集群的公网信息(包括 VIP) (Doc ID 1674442.1)
- 如何在 oracle 集群环境下修改私网信息 (Doc ID 2103317.1)
- ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug
- ORA-600 krhpfh_03-1210故障处理
标签归档:ktsiseginfo1
ORA-600 ktsiseginfo1故障
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相关描述: