标签云
asm恢复 bbed bootstrap$ dul kcbzib_kcrsds_1 kccpb_sanity_check_2 kcratr_nab_less_than_odr MySQL恢复 obet ORA-00312 ORA-00704 ORA-00742 ORA-01110 ORA-01200 ORA-01555 ORA-01578 ORA-01595 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-600 kcratr_nab_less_than_odr 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 比特币加密文章分类
- MongoDB (1)
- MongoDB恢复 (1)
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (112)
- 数据库 (1,884)
- DB2 (22)
- MySQL (82)
- Oracle (1,709)
- Data Guard (53)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (168)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (73)
- Oracle Bug (8)
- Oracle RAC (56)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (29)
- Oracle备份恢复 (662)
- Oracle安装升级 (108)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (91)
- PostgreSQL (37)
- pdu工具 (7)
- PostgreSQL恢复 (13)
- SQL Server (34)
- SQL Server恢复 (14)
- TimesTen (7)
- 达梦数据库 (5)
- 达梦恢复 (3)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (51)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (34)
- MongoDB (1)
-
最近发表
- 记录19c ASM磁盘掉线触发ORA-59048故障处理
- aix平台Oracle数据库由于断电无法启动故障处理
- 断电引起ORA-600 3005故障处理
- 记录一次云存储资源到期之后引起的数据库恢复
- Firebird 损坏数据库数据抢救工具—firebirdext
- Oracle 19c 202610补丁(RUs+OJVM)-19.33
- 由于con$.con#值达到极限,触发数据库增加约束报ORA-600 12807错误
- MongoDB 离线提取工具—mongoext
- .bres勒索病毒加密数据库dmp文件可恢复
- ORA-600 krsm_mrp_rebuild_lf_list.lno_mismatch
- 记录一次0丢失的ORA-00354: 损坏重做日志块标头故障恢复
- 不当数据库恢复操作导致一个月数据丢失
- obet快速修复oracle 位图损坏块
- 不太常见的10.2.0.1的oracle redo损坏恢复
- obet forcecopy功能抢救硬件故障中的数据文件
- kcratr_nab_less_than_odr和system坏块故障处理
- 通过obet 恢复system坏块,打开数据库
- obet dbv功能完整说明
- 分享一例运行在aix上的sap系统数据库恢复过程
- OBET-Oracle Block Editor Tool使用说明
标签归档:kcbzib_kcrsds_1 patch_scn
ORA-600 krsm_mrp_rebuild_lf_list.lno_mismatch
客户由于断电,导致一个19c数据库无法正常启动,接手时候报错为:ORA-600 krsm_mrp_rebuild_lf_list.lno_mismatch
2026-09-15T06:36:24.908317-07:00 ALTER DATABASE OPEN RESETLOGS 2026-09-15T06:36:24.912251-07:00 RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 22297188690 time NET (PID:36760): Unable to create archive log file '/u19/dbs/arch1_1_1243990641.dbf' 2026-09-15T06:36:24.919696-07:00 Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_36760.trc: ORA-19504: failed to create file "/u19/dbs/arch1_1_1243990641.dbf" ORA-27038: created file already exists Additional information: 1 NET (PID:36760): Error 19504 Creating archive log file to '/u19/app/dbs/arch1_1_1243990641.dbf' NET (PID:36760): Archiving not possible: error count exceeded Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_36760.trc (incident=119876): ORA-00600: internal error code, arguments: [krsm_mrp_rebuild_lf_list.lno_mismatch], [3], [1], [1], [0], [] Incident details in: /u19/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_119876/orcl_ora_36760_i119876.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. NET (PID:36760): Archive all ORLs failed, error=600 ORA-600 signalled during: ALTER DATABASE OPEN RESETLOGS...
通过alert日志大概回溯现场人员的恢复过程,最初数据库断电重启之后报ORA-00742错误
2026-09-14T20:52:37.294285-07:00 ALTER DATABASE OPEN Ping without log force is disabled: instance mounted in exclusive mode. 2026-09-14T20:52:37.313266-07:00 Beginning crash recovery of 1 threads Thread 1: Recovery starting at checkpoint rba (logseq 63111 block 286483), scn 0 2026-09-14T20:52:37.370330-07:00 Started redo scan 2026-09-14T20:52:37.419944-07:00 Aborting crash recovery due to error 742 2026-09-14T20:52:37.420039-07:00 Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_68055.trc: ORA-00742: Log read detects lost write in thread 1 sequence 63111 block 326157 ORA-00312: online log 3 thread 1: '/u19/app/oracle/oradata/ORCL/redo03.log' 2026-09-14T20:52:37.420977-07:00 Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_68055.trc: ORA-00742: Log read detects lost write in thread 1 sequence 63111 block 326157 ORA-00312: online log 3 thread 1: '/u19/app/oracle/oradata/ORCL/redo03.log' ORA-742 signalled during: ALTER DATABASE OPEN...
现场人员加上隐含参数强制拉库,然后数据库报ORA-600 kcbzib_kcrsds_1错误
2026-09-14T21:35:21.425310-07:00 ALTER DATABASE OPEN RESETLOGS 2026-09-14T21:35:21.429136-07:00 RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 22297188666 time Resetting resetlogs activation ID 1680209845 (0x6425f7b5) 2026-09-14T21:35:34.017515-07:00 Setting recovery target incarnation to 3 2026-09-14T21:35:34.028360-07:00 Ping without log force is disabled: instance mounted in exclusive mode. Endian type of dictionary set to little 2026-09-14T21:35:34.043771-07:00 Assigning activation ID 1771732361 (0x699a7d89) 2026-09-14T21:35:34.125473-07:00 TT00 (PID:47466): Gap Manager starting 2026-09-14T21:35:34.127554-07:00 Redo log for group 1, sequence 1 is not located on DAX storage Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /u19/app/oracle/oradata/ORCL/redo01.log Successful open of redo thread 1 2026-09-14T21:35:34.165332-07:00 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set stopping change tracking 2026-09-14T21:35:35.507453-07:00 ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], , [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. SYSTEM DUMP REDO DBA MIN 4 128 DBA MAX 4 128 SCN MIN 1; 2026-09-14T21:35:37.154962-07:00 ***************************************************************** An internal routine has requested a dump of selected redo. This usually happens following a specific internal error, when analysis of the redo logs will help Oracle Support with the diagnosis. It is recommended that you retain all the redo logs generated (by all the instances) during the past 12 hours, in case additional redo dumps are required to help with the diagnosis. ***************************************************************** Undo initialization recovery: err:600 start: 3433752 end: 3435865 diff: 2113 ms (2.1 seconds) 2026-09-14T21:35:37.475752-07:00 Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_46217.trc: ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], , [], [], [], [], [] 2026-09-14T21:35:37.475831-07:00 Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_46217.trc: ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], , [], [], [], [], [] Error 600 happened during db open, shutting down database Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_46217.trc (incident=48128): ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], , [], [], [], [], []
现场人员重建控制文件,然后启动库报ORA-600 krsm_mrp_rebuild_lf_list.lno_mismatch
2026-09-15T04:26:41.297637-07:00
Successful mount of redo thread 1, with mount id 1771762176
Completed: CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 16
LOGFILE
GROUP 1 '/u19/app/oracle/oradata/ORCL_NEW/redo01.log' SIZE 200M,
GROUP 2 '/u19/app/oracle/oradata/ORCL_NEW/redo02.log' SIZE 200M
DATAFILE
'/u19/app/oracle/oradata/ORCL_NEW/system01.dbf',
'/u19/app/oracle/oradata/ORCL_NEW/sysaux01.dbf',
'/u19/app/oracle/oradata/ORCL_NEW/undotbs01.dbf',
…………
2026-09-15T04:26:52.121793-07:00
ALTER DATABASE OPEN RESETLOGS
2026-09-15T04:26:52.126848-07:00
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 22297188686 time
NET (PID:27130): Unable to create archive log file '/u19/dbs/arch1_1_1243990641.dbf'
2026-09-15T04:26:52.233538-07:00
Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_27130.trc:
ORA-19504: failed to create file "/u19/dbs/arch1_1_1243990641.dbf"
ORA-27038: created file already exists
Additional information: 1
NET (PID:27130): Error 19504 Creating archive log file to '/u19/dbs/arch1_1_1243990641.dbf'
NET (PID:27130): Archiving not possible: error count exceeded
Errors in file /u19/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_27130.trc (incident=102102):
ORA-00600: internal error code, arguments: [krsm_mrp_rebuild_lf_list.lno_mismatch], [2], [1], [1], [0], []
Incident details in: /u19/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_102102/orcl_ora_27130_i102102.trc
接手故障开始处理,尝试open库,重现ORA-600 krsm_mrp_rebuild_lf_list.lno_mismatch错误
SQL> recover database using backup controlfile;
ORA-00279: change 22297188689 generated at 09/15/2026 00:57:22 needed for thread 1
ORA-00289: suggestion : /u19/dbs/arch/1_1_1243990641.dbf
ORA-00280: change 22297188689 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u19/app/oracle/oradata/ORCL/redo01.log
Log applied.
Media recovery complete.
SQL>
SQL>
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [krsm_mrp_rebuild_lf_list.lno_mismatch], [3], [1], [1], [0]
分析alert日志,是由于归档无法被正常创建导致该问题,对/u19/dbs/arch/进行创建并授权之后,再次尝试打开数据库,数据库报ORA-600 kcbzib_kcrsds_1错误
SQL> startup nomount pfile='/tmp/pfile'; ORACLE instance started. Total System Global Area 6442448984 bytes Fixed Size 8910936 bytes Variable Size 3858759680 bytes Database Buffers 2566914048 bytes Redo Buffers 7864320 bytes SQL> alter database mount; Database altered. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [] Process ID: 42259 Session ID: 1 Serial number: 19675
使用obet的patch scn功能修改scn之后(obet patch_scn使用说明),顺利打开库


obet forcecopy功能抢救硬件故障中的数据文件
客户raid5发现有盘离线,并且其他盘有坏道,进行了多次换盘操作替换了大部分有坏道磁盘,但是部分文件访问依旧会报io错误

直接cp文件报
cp: error reading 'datafile': Input/output error
数据库层面操作报
ORA-01115: IO error reading block from file %s (block # %s) ORA-27072: File I/O error Linux-x86_64 Error: 5: Input/output error Additional information: 4 Additional information: 21571487880
对于这样的情况,使用obet的forcecopy功能直接强制拷贝文件,可以最大限度求救数据obet forcecopy

把所有损坏文件拷贝出来之后传输到其他机器上,检查所有文件坏块情况

运气不错,整体坏块非常少,而且没有涉及数据库字典文件,然后尝试恢复

虽然recover database成功,但是不幸open 库报ORA-600 kcbzib_kcrsds_1错误
SQL> ALTER DATABASE OPEN ; ALTER DATABASE OPEN * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [] Process ID: 15786 Session ID: 3054 Serial number: 46983
顺利打开数据库,并导出数据
ORA-00756 ORA-10567故障处理
数据库异常断电之后,recover 报ORA-00756 ORA-10567等错
SQL> recover database; ORA-00756: 恢复操作检测到数据块写入丢失 ORA-10567: Redo is inconsistent with data block (file# 1,block# 113855,file offset is 932700160 bytes) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 67
alert日志报大量block逻辑错误
2024-07-16T13:16:31.050599+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.050599+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr01_43460.trc: ORA-10562: Error occurred while applying redo to data block (file# 3, block# 107952) ORA-10564: tablespace SYSAUX ORA-01110: 数据文件 3: 'H:\BAIDUNETDISK\XIFENFEI\SYSAUX01.DBF' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 8689 ORA-00600: 内部错误代码, 参数: [ktbair2: illegal inheritance], , [], [], [], [] 2024-07-16T13:16:31.088497+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.088497+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr0e_10596.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 755) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 64 ORA-00600: 内部错误代码, 参数: [kdolkr-2], [2], [155], [26], , [] 2024-07-16T13:16:31.106449+08:00 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2024-07-16T13:16:31.130385+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.130385+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr0i_40632.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 110095) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 40 ORA-00600: 内部错误代码, 参数: [kdxdBlkCheckError], [1], [4304399], [6401], , [] 2024-07-16T13:16:31.157313+08:00 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2024-07-16T13:16:31.181249+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.182247+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr09_15592.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 5490) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 822 ORA-00600: 内部错误代码, 参数: [kdxdBlkCheckError], [1], [4199794], [6401], , [] 2024-07-16T13:16:31.242087+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.242087+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr05_28908.trc: ORA-10562: Error occurred while applying redo to data block (file# 3, block# 3935) ORA-10564: tablespace SYSAUX ORA-01110: 数据文件 3: 'H:\BAIDUNETDISK\XIFENFEI\SYSAUX01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 8694 ORA-00600: 内部错误代码, 参数: [6102], [27], [2], , [], [] 2024-07-16T13:16:31.265025+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.266023+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr0d_24400.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 51243) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 8 ORA-00600: 内部错误代码, 参数: [ktbair2: illegal inheritance], , [], [], [], [] 2024-07-16T13:16:31.272007+08:00 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2024-07-16T13:16:31.293948+08:00 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2024-07-16T13:16:31.294946+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.294946+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr02_24168.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 114402) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 64 ORA-00600: 内部错误代码, 参数: [kdbBlkCheckError], [1], [4308706], [6124], , [] 2024-07-16T13:16:31.307911+08:00 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2024-07-16T13:16:31.315890+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.316916+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr0h_37312.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 116359) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 64 ORA-00600: 内部错误代码, 参数: [kdbBlkCheckError], [1], [4310663], [6124], , [] 2024-07-16T13:16:31.329881+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.329881+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr0g_38356.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 115210) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 64 ORA-00600: 内部错误代码, 参数: [kdbBlkCheckError], [1], [4309514], [6124], , [] 2024-07-16T13:16:49.657116+08:00 Corrupt block relative dba: 0x01000c1d (file 4, block 3101) Fractured block found during in-flux buffer recovery Data in bad block: type: 2 format: 2 rdba: 0x01000c1d last change scn: 0x0000.0000.00ddfe50 seq: 0x1 flg: 0x04 spare3: 0x0 consistency value in tail: 0xcaae0205 check value in block header: 0x2ebc computed block checksum: 0xee94 Reread (file 4, block 3101) found same corrupt data (no logical check) 2024-07-16T13:16:49.893484+08:00 Errors in file C:\APP\XFF\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr00_23116.trc: ORA-00283: 恢复会话因错误而取消 ORA-00448: 后台进程正常结束
dbv检查system文件报有坏块
C:\Users\XFF>dbv file=H:\BaiduNetdisk\XIFENFEI\system01.dbf DBVERIFY: Release 19.0.0.0.0 - Production on 星期二 7月 16 13:17:32 2024 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. DBVERIFY - 开始验证: FILE = H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF 页 11290 流入 - 很可能是介质损坏 Corrupt block relative dba: 0x00402c1a (file 1, block 11290) Fractured block found during dbv: Data in bad block: type: 6 format: 2 rdba: 0x00402c1a last change scn: 0x0000.0000.00dec9ca seq: 0x1 flg: 0x06 spare3: 0x0 consistency value in tail: 0x56e00601 check value in block header: 0xaf3c computed block checksum: 0xdc2d 页 50842 流入 - 很可能是介质损坏 Corrupt block relative dba: 0x0040c69a (file 1, block 50842) Fractured block found during dbv: Data in bad block: type: 6 format: 2 rdba: 0x0040c69a last change scn: 0x0000.0000.00de200e seq: 0x1 flg: 0x06 spare3: 0x0 consistency value in tail: 0x799a0601 check value in block header: 0x68ef computed block checksum: 0x5994 页 113852 流入 - 很可能是介质损坏 Corrupt block relative dba: 0x0041bcbc (file 1, block 113852) Fractured block found during dbv: Data in bad block: type: 6 format: 2 rdba: 0x0041bcbc last change scn: 0x0000.0000.00df78b9 seq: 0x1 flg: 0x06 spare3: 0x0 consistency value in tail: 0x1f1c0601 check value in block header: 0xf5fc computed block checksum: 0x46af DBVERIFY - 验证完成 检查的页总数: 119040 处理的页总数 (数据): 82822 失败的页总数 (数据): 0 处理的页总数 (索引): 14268 失败的页总数 (索引): 0 处理的页总数 (其他): 4570 处理的总页数 (段) : 1 失败的总页数 (段) : 0 空的页总数: 17377 标记为损坏的总页数: 3 流入的页总数: 3 加密的总页数 : 0 最高块 SCN : 14645988 (0.14645988)
由于无法直接应用日志打开库,尝试屏蔽一致性,强制打开库,报ORA-600 kcbzib_kcrsds_1错误
SQL> startup mount pfile='d:/pfile.txt';
ORACLE 例程已经启动。
Total System Global Area 5167381760 bytes
Fixed Size 9039104 bytes
Variable Size 989855744 bytes
Database Buffers 4160749568 bytes
Redo Buffers 7737344 bytes
数据库装载完毕。
SQL>
SQL>
SQL>
SQL> recover database until cancel;
ORA-00279: 更改 14599839 (在 生成) 对于线程 1 是必需的
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 将出现如下错误
ORA-01194: 文件 1 需要更多的恢复来保持一致性
ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF'
ORA-01112: 未启动介质恢复
SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [],
进程 ID: 23392
会话 ID: 618 序列号: 30029
使用Patch_SCN工具修改scn(修改oracle scn小工具(patch scn)),然后打开库,报ORA-600 6711

SQL> alter database open; alter database open * 第 1 行出现错误: ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [6711], [4310861], [1], [4309052], [0], 进程 ID: 40100 会话 ID: 618 序列号: 10845
这个故障最近刚刚处理过一次,见:数据库启动报ORA-600 6711故障分析处理,open数据库之后,尝试导出数据,报各种错误
ORA-600 6711报错
C:\Users\XFF>exp "'/ as sysdba'" owner=XIFENFEI file=e:/XIFENFEI.dmp log=e:/XIFENFEI.log Export: Release 19.0.0.0.0 - Production on 星期二 7月 16 13:33:11 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. 连接到: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集 即将导出指定的用户... . 正在导出 pre-schema 过程对象和操作 EXP-00008: 遇到 ORACLE 错误 600 ORA-00600: 内部错误代码, 参数: [6711], [4310861], [1], [4309052], [0], EXP-00083: 调用 SYS.DBMS_AW_EXP.schema_info_exp 时出现前一问题 . 正在导出用户 XIFENFEI 的外部函数库名 . 导出 PUBLIC 类型同义词 . 正在导出专用类型同义词 EXP-00008: 遇到 ORACLE 错误 1578 ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 11290) ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' EXP-00000: 导出终止失败 C:\Users\XFF>sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on 星期二 7月 16 13:33:23 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. 连接到: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> select object_name,object_type from dba_objects where object_id=64; OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE ----------------------- C_OBJ#_INTCOL# CLUSTER
ORA-01578报错
C:\Users\XFF>exp "'/ as sysdba'" owner=XIFENFEI file=e:/XIFENFEI.dmp log=e:/XIFENFEI.log
Export: Release 19.0.0.0.0 - Production on 星期二 7月 16 13:34:07 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即将导出指定的用户...
. 正在导出 pre-schema 过程对象和操作
. 正在导出用户 XIFENFEI 的外部函数库名
. 导出 PUBLIC 类型同义词
. 正在导出专用类型同义词
EXP-00008: 遇到 ORACLE 错误 1578
ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 11290)
ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF'
EXP-00000: 导出终止失败
C:\Users\XFF>sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 星期二 7月 16 13:34:21 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
连接到:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, A.PARTITION_NAME
2 FROM DBA_EXTENTS A
3 WHERE FILE_ID = &FILE_ID
4 AND &BLOCK_ID BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
输入 file_id 的值: 1
原值 3: WHERE FILE_ID = &FILE_ID
新值 3: WHERE FILE_ID = 1
输入 block_id 的值: 11290
原值 4: AND &BLOCK_ID BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1
新值 4: AND 11290 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1
OWNER
--------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE TABLESPACE_NAME
------------------ ------------------------------
PARTITION_NAME
--------------------------------------------------------------------------------
SYS
I_OBJ2
INDEX SYSTEM
SQL> create table t1 as select * from dba_objects;
create table t1 as select * from dba_objects
*
第 1 行出现错误:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 50842)
ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF'
SQL> SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, A.PARTITION_NAME
2 FROM DBA_EXTENTS A
3 WHERE FILE_ID = &FILE_ID
4 AND &BLOCK_ID BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
输入 file_id 的值: 1
原值 3: WHERE FILE_ID = &FILE_ID
新值 3: WHERE FILE_ID = 1
输入 block_id 的值: 50842
原值 4: AND &BLOCK_ID BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1
新值 4: AND 50842 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1
OWNER
--------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE TABLESPACE_NAME
------------------ ------------------------------
PARTITION_NAME
--------------------------------------------------------------------------------
SYS
I_COL3
INDEX SYSTEM
通过上述分析,确认还有I_OBJ2和I_COL3这两个核心index异常,参考:bootstrap$核心index(I_OBJ1,I_USER1,I_FILE#_BLOCK#,I_IND1,I_TS#,I_CDEF1等)异常恢复—ORA-00701错误解决 进行处理,数据库可以正常导出
连接到: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集 即将导出指定的用户... . 正在导出 pre-schema 过程对象和操作 . 正在导出用户 XIFENFEI 的外部函数库名 . 导出 PUBLIC 类型同义词 . 正在导出专用类型同义词 . 正在导出用户 XIFENFEI 的对象类型定义 即将导出 XIFENFEI 的对象... . 正在导出数据库链接 . 正在导出序号 . 正在导出簇定义 . 即将导出 XIFENFEI 的表通过常规路径... . . 正在导出表 标准诊断明细 ..... 导出了 50213 行 ………… . . 正在导出表 诊断旁支分类 导出了 1 行 . 正在导出同义词 . 正在导出视图 . 正在导出存储过程 . 正在导出运算符 . 正在导出引用完整性约束条件 . 正在导出触发器 . 正在导出索引类型 . 正在导出位图, 功能性索引和可扩展索引 . 正在导出后期表活动 . 正在导出实体化视图 . 正在导出快照日志 . 正在导出作业队列 . 正在导出刷新组和子组 . 正在导出维 . 正在导出 post-schema 过程对象和操作 . 正在导出统计信息 成功终止导出, 没有出现警告。


加我微信(17813235971)
加我QQ(107644445)

