标签云
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故障处理
标签归档:ORA 600 kddummy_blkchk
ORA-600 kddummy_blkchk导致数据库无法open
数据库启动报ORA-600 kddummy_blkchk
Sun Sep 9 21:45:28 2018 SMON: enabling tx recovery Sun Sep 9 21:45:28 2018 Database Characterset is ZHS16GBK Opening with internal Resource Manager plan where NUMA PG = 1, CPUs = 24 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=35, OS id=53346452 Sun Sep 9 21:45:28 2018 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_39714888.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], [] Sun Sep 9 21:45:28 2018 Completed: ALTER DATABASE OPEN Sun Sep 9 21:45:28 2018 db_recovery_file_dest_size of 89900 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Sun Sep 9 21:45:29 2018 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_39714888.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], [] Sun Sep 9 21:45:32 2018 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_39714888.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], [] Sun Sep 9 21:46:20 2018 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_pmon_11403488.trc: ORA-00474: SMON process terminated with error Sun Sep 9 21:46:20 2018 PMON: terminating instance due to error 474 Instance terminated by PMON, pid = 11403488
kddummy_blkchk错误mos记录
Format: ORA-600 [kddummy_blkchk] [a] [b] 1 VERSIONS: versions 9.2 to 10.2 DESCRIPTION: --what condition caused the error to be reported ARGUMENTS: Arg [a] Absolute file number Arg [b] Bock number Arg 1 Internal error code returned from kcbchk() which indicates the problem encountered.
trace文件信息
Block after image: buffer tsn: 14 rdba: 0x98400006 (609/6) scn: 0x0007.9e675f6d seq: 0x01 flg: 0x04 tail: 0x5f6d1e01 frmt: 0x02 chkval: 0x61ae type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of corrupt header 3 = CHKVAL Dump of memory from 0x070000043F034000 to 0x070000043F034014 *** 2018-09-09 21:45:28.531 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], [] ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst+001c bl ksedst1 90000000032FBDC ? 000000000 ? ksedmp+0290 bl ksedst 104A2CDD0 ? ksfdmp+0018 bl 03F26B04 kgerinv+00dc bl _ptrgl kseinpre+0040 bl kgerinv 110123BE0 ? 000000001 ? 104BD0420 ? 07FFFFFFF ? 000000000 ? ksesin+0048 bl kseinpre 104BD0420 ? 07FFFFFFF ? 000000000 ? kco_blkchk+0798 bl ksesin 104BD0888 ? 300000003 ? 000000000 ? 000000261 ? 000000000 ? 000000006 ? 000000000 ? 000004662 ? kcoapl+0d24 bl kco_blkchk 000000000 ? 70000046D293500 ? FFFFFFFFFFF9BA0 ? 1101954D0 ? FFFFFFFFFFF9AC0 ? kcbapl+0174 bl kcoapl FFFFFFFFFFFAFD0 ? 70000043F034000 ? 1104C2884 ? EDEADBEEF ? 200000000000 ? 110000790 ? 000000000 ? kcrfw_redo_gen+2988 bl kcbapl FFFFFFFFFFFA040 ? 70000046D293500 ? 100FAF764 ? 700000010008000 ? 000000000 ? kcbchg1_main+25d4 bl kcrfw_redo_gen 000000000 ? 000000000 ? 000000000 ? 000000001 ? 000000000 ? 000000001 ? 000000000 ? 000000002 ? kcbchg1+038c bl kcbchg1_main 000000000 ? 000000000 ? 000000018 ? 000000000 ? 000000000 ? 000000228 ? ktbchgro+0380 bl kcbchg1 062886020 ? 1601C0F50 ? FFFFFFFFFFFAE80 ? FFFFFFFFFFFAEB8 ? 000000000 ? 000000000 ? ktfbbset+01e0 bl ktbchgro 000000000 ? 100000001 ? FFFFFFFFFFFB110 ? FFFFFFFFFFFAFD0 ? 000000000 ? 000000000 ? 000000000 ? 000000001 ? ktfbfset+039c bl ktfbbset 000000000 ? 000000000 ? 000000000 ? 000000000 ? 700000010018078 ? 000000000 ? 110000790 ? ktfbfundo+0208 bl ktfbfset 00000000B ? 00000000B ? ktfbhget+0760 bl ktfbfundo FFFFFFFFFFFBFF8 ? 200000000 ? ktfbffpre+00d0 bl ktfbhget FFFFFFFFFFFBFF8 ? 200000002 ? 1100000000 ? 2033FBE8014 ? kteopdelete+12dc bl ktfbffpre FFFFFFFFFFFC678 ? 204BCDD80 ? 1CE04BCEEE8 ? 0FFFFEFFF ? ktsxfastdele+0124 bl kteopdelete 700000010018078 ? 700000010008000 ? 1104772A8 ? 700000464E35278 ? 700000464E35278 ? 000000000 ? FFFFFFFFFFFBDA0 ? kteopshrink+0308 bl _ptrgl ktssdrbm_segment+0a bl kteopshrink E0000000E ? FFFFFFFFFFFC608 ? b0 000000001 ? 000000001 ? 110477768 ? 000000002 ? 1100EA4E0 ? ktssdro_segment+06d bl ktssdrbm_segment FFFFFFFFFFFCFC8 ? c FFFFFFFFFFFD090 ? 100000010 ? 000000000 ? ktssdt_segs+03f4 bl ktssdro_segment 70000046D28EA18 ? 6FFFFD3A0 ? 0FFFFD320 ? ktmmon+135c bl ktssdt_segs 000000000 ? 7FFFFFFF7FFFFFFF ? 7FFFFFFF7FFFFFFF ? 000000000 ? 000000000 ? 000000000 ? 7FFFFFFC7FFFFFFC ? 05B9523F8 ? ktmSmonMain+0030 bl ktmmon 110000790 ? ksbrdp+04b4 bl _ptrgl opirip+03fc bl 03F26C94 opidrv+0458 bl opirip 11029F970 ? 4102A12B0 ? FFFFFFFFFFFF6B0 ? sou2o+0090 bl opidrv 3202D99A1C ? 4A004A628 ? FFFFFFFFFFFF6B0 ? opimai_real+0150 bl 01F93134 main+0098 bl opimai_real 4500000000000000 ? 800200140000400 ? __start+0070 bl main 000000000 ? 000000000 ? --------------------- Binary Stack Dump ---------------------
错误比较明显由于file 609 block 6异常,导致smon无法进行回滚,从使得数据库open之后,立马crash.这个问题可以通过使用bbed修复坏块解决,也可以通过设置合适的参数和事件,禁止smon的一些操作来规避
bbed修复block之后dbv检查
oracle@p740a:/tmp]$ dbv file=/u01/app/oracle/oradata/orcl/xifenfei38.dbf DBVERIFY: Release 10.2.0.4.0 - Production on Sun Sep 16 11:01:54 2018 Copyright (c) 1982, 2007, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/orcl/xifenfei38.dbf DBVERIFY - Verification complete Total Pages Examined : 1856000 Total Pages Processed (Data) : 1142647 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 710956 Total Pages Failing (Index): 0 Total Pages Processed (Other): 2277 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 120 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 2658994127 (7.2658994127)