-
加我微信(17813235971)
加我QQ(107644445)
标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-01595 ORA-08103 ORA-600 2131 ORA-600 2662 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)
- 操作系统 (103)
- 数据库 (1,762)
- DB2 (22)
- MySQL (76)
- Oracle (1,604)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (166)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (69)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (588)
- Oracle安装升级 (97)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (85)
- PostgreSQL (30)
- pdu工具 (6)
- PostgreSQL恢复 (9)
- SQL Server (32)
- SQL Server恢复 (13)
- TimesTen (7)
- 达梦数据库 (3)
- 达梦恢复 (1)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (39)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (22)
-
最近发表
- 解决一次硬件恢复之后数据文件0kb的故障恢复case
- Error in invoking target ‘libasmclntsh19.ohso libasmperl19.ohso client_sharedlib’问题处理
- ORA-01171: datafile N going offline due to error advancing checkpoint
- linux环境oracle数据库被文件系统勒索加密为.babyk扩展名溯源
- ORA-600 ksvworkmsgalloc: bad reaper
- ORA-600 krccfl_chunk故障处理
- Oracle Recovery Tools恢复案例总结—202505
- ORA-600 kddummy_blkchk 数据库循环重启
- 记录一次asm disk加入到vg通过恢复直接open库的案例
- CHECKDB 发现了 N 个分配错误和 M 个一致性错误
- 达梦数据库dm.ctl文件异常恢复
- Oracle Recovery Tools修复ORA-00742、ORA-600 ktbair2: illegal inheritance故障
- 可能是 tempdb 空间用尽或某个系统表不一致故障处理
- 11.2.0.4库中遇到ORA-600 kcratr_nab_less_than_odr报错
- [MY-013183] [InnoDB] Assertion failure故障处理
- Oracle 19c 202504补丁（RUs+OJVM）-19.27
- Oracle Recovery Tools修复ORA-600 6101/kdxlin:psno out of range故障
- pdu完美支持金仓数据库恢复(KingbaseES)
- 虚拟机故障引起ORA-00310 ORA-00334故障处理
- pg创建gbk字符集库
标签归档：kddummy_blkchk
ORA-600 kddummy_blkchk 数据库循环重启
一个运行在hp平台的10g rac突然异常,之后运行一段时间就自动重启,客户让对其进行分析和解决
Thu May 8 06:23:21 2025 ALTER DATABASE OPEN Picked broadcast on commit scheme to generate SCNs Thu May 8 06:23:21 2025 Thread 1 opened at log sequence 74302 Current log# 1 seq# 74302 mem# 0: /dev/vgdata/rrac_redo01 Successful open of redo thread 1 Thu May 8 06:23:21 2025 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu May 8 06:23:21 2025 SMON: enabling cache recovery Thu May 8 06:23:22 2025 Successfully onlined Undo Tablespace 1. Thu May 8 06:23:22 2025 SMON: enabling tx recovery Thu May 8 06:23:22 2025 Database Characterset is ZHS16CGB231280 Opening with internal Resource Manager plan where NUMA PG = 1, CPUs = 4 replication_dependency_tracking turned off (no async multimaster replication found) Thu May 8 06:23:23 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [118], [333578], [18019], [], [], [], [] Starting background process QMNC QMNC started with pid=22, OS id=15792 Thu May 8 06:23:25 2025 ORACLE Instance orcl1 (pid = 13) - Error 607 encountered while recovering transaction (9, 33) on object 775794. Thu May 8 06:23:25 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [kddummy_blkchk], [118], [333578], [18019], [], [], [], [] Thu May 8 06:23:26 2025 Completed: ALTER DATABASE OPEN Thu May 8 06:23:26 2025 Doing block recovery for file 118 block 333578 Block recovery from logseq 74302, block 22 to scn 46740761996 Thu May 8 06:23:26 2025 Recovery of Online Redo Log: Thread 1 Group 1 Seq 74302 Reading mem 0 Mem# 0: /dev/vgdata/rrac_redo01 Block recovery stopped at EOT rba 74302.33.16 Block recovery completed at rba 74302.33.16, scn 10.3791089036 Thu May 8 06:23:33 2025 Trace dumping is performing id=[cdmp_20250508062324] Thu May 8 06:25:55 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [118], [333578], [18019], [], [], [], [] Thu May 8 06:25:58 2025 ORACLE Instance orcl1 (pid = 13) - Error 607 encountered while recovering transaction (9, 33) on object 775794. Thu May 8 06:27:32 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [118], [333578], [18019], [], [], [], [] Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: Doing block recovery for file 118 block 333578 Block recovery from logseq 74302, block 372 to scn 46740952565 Thu May 8 06:27:41 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [118], [333578], [18019], [], [], [], [] ORACLE Instance orcl1 (pid = 13) - Error 607 encountered while recovering transaction (9, 33) on object 775794. Thu May 8 06:27:43 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [kddummy_blkchk], [118], [333578], [18019], [], [], [], [] Doing block recovery for file 118 block 333578 Block recovery from logseq 74302, block 372 to scn 46740952565 Thu May 8 06:27:45 2025 Recovery of Online Redo Log: Thread 1 Group 1 Seq 74302 Reading mem 0 Mem# 0: /dev/vgdata/rrac_redo01 Block recovery completed at rba 74302.394.16, scn 10.3791279606 Thu May 8 06:27:47 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_smon_15721.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [118], [333578], [18019], [], [], [], [] Thu May 8 06:28:07 2025 Errors in file /users/oracle/admin/orcl/bdump/orcl1_pmon_15690.trc: ORA-00474: SMON process terminated with error Thu May 8 06:28:07 2025 PMON: terminating instance due to error 474
这个数据库重启是由于smon进程异常导致数据库关闭,然后rac自动拉起数据库,从而出现了循环重启启动,smon异常的主要原因是由于“ORACLE Instance orcl1 (pid = 13) – Error 607 encountered while recovering transaction (9, 33) on object 775794.”这个表示有实物要回滚,但是遇到了ORA-600 kddummy_blkchk异常,无法完成回滚从而使得smon进程异常进而使得数据实例crash.对于这个问题处理相对比较简单
1. 通过ORA-600 kddummy_blkchk找出来报错对象
ORA-00600: internal error code, arguments: [kddummy_blkchk], [a], [b], 1 ARGUMENTS: Arg [a] Absolute file number Arg [b] Block number Arg 1 Internal error code returned from kcbchk() which indicates the problem encountered.
2. 屏蔽实物回滚,打开数据库,然后对通过dba_extents 查询出来的对象/或者根据事务报错的object信息查询出来对象进行重建,完成本次恢复任务
关于ORA-00600: internal error code, arguments: [kddummy_blkchk], [a], [b], 相关目前已知bug
| Bug | Fixed | Description |
| 12349316 | 11.2.0.4, 12.1.0.2, 12.2.0.1 | DBMS_SPACE_ADMIN.TABLESPACE_FIX_BITMAPS fails with ORA-600 [kddummy_blkchk] / ORA-600 [kdBlkCheckError] / ORA-607 |
| 17325413 | 11.2.0.3.BP23, 11.2.0.4.2, 11.2.0.4.BP04, 12.1.0.1.3, 12.1.0.2, 12.2.0.1 | Drop column with DEFAULT value and NOT NULL definition ends up with Dropped Column Data still on Disk leading to Corruption |
| 13715932 | 11.2.0.4, 12.1.0.1 | ORA-600 [kddummy_blkchk] [18038] while adding extents to a large datafile |
| 12417369 | 11.2.0.2.5, 11.2.0.2.BP13, 11.2.0.2.GIPSU05, 11.2.0.3, 12.1.0.1 | Block corruption from rollback on compressed table |
| 10324526 | 10.2.0.5.4, 11.1.0.7.8, 11.2.0.2.3, 11.2.0.2.BP06, 11.2.0.3, 12.1.0.1 | ORA-600 [kddummy_blkchk] [6106] / corruption on COMPRESS table in TTS |
| 10113224 | 11.2.0.3, 12.1.0.1 | Index coalesce may generate invalid redo if blocks in the buffer cache are invalid/corrupted |
| 9726702 | 11.2.0.3, 12.1.0.1 | DBMS_SPACE_ADMIN.assm_segment_verify reports HWM related inconsistencies |
| 9724970 | 11.2.0.1.BP08, 11.2.0.2.2, 11.2.0.2.BP02, 11.2.0.3, 12.1.0.1 | Block Corruption with PDML UPDATE. ORA_600 [4511] OERI[kdblkcheckerror] by block check |
| 9711859 | 10.2.0.5.1, 11.1.0.7.6, 11.2.0.2, 12.1.0.1 | ORA-600 [ktsptrn_fix-extmap] / ORA-600 [kdblkcheckerror] during extent allocation caused by bug 8198906 |
| 9581240 | 11.1.0.7.9, 11.2.0.2, 12.1.0.1 | Corruption / ORA-600 [kddummy_blkchk] [6101] / ORA-600 [7999] after RENAME operation during ROLLBACK |
| 9350204 | 11.2.0.3, 12.1.0.1 | Spurious ORA-600 [kddummy_blkchk] .. [6145] during CR operations on tables with ROWDEPENDENCIES |
| 9231605 | 11.1.0.7.4, 11.2.0.1.3, 11.2.0.1.BP02, 11.2.0.2, 12.1.0.1 | Block corruption with missing row on a compressed table after DELETE |
| 9119771 | 11.2.0.2, 12.1.0.1 | OERI [kddummy_blkchk]…[6108] from ‘SHRINK SPACE CASCADE’ |
| 9019113 | 11.2.0.1.BP02, 11.2.0.2, 12.1.0.1 | ORA-600 [17182] ORA-7445 [memcpy] ORA-600 [kdBlkCheckError] for OLTP COMPRESS table in OLTP Compression REDO during RECOVERY |
| 8951812 | 11.2.0.2, 12.1.0.1 | Corrupt index by rebuild online. Possible OERI [kddummy_blkchk] by SMON |
| 8720802 | 10.2.0.5, 11.2.0.1.BP07, 11.2.0.2, 12.1.0.1 | Add check for row piece pointing to itself (db_block_checking,dbv,rman,analyze) |
| 8331063 | 11.2.0.3, 12.1.0.1 | Corrupt Undo. ORA-600 [2015] in Undo Block During Rollback |
| 6523037 | 11.2.0.1.BP07, 11.2.0.2.2, 11.2.0.2.BP01, 11.2.0.3, 12.1.0.1 | Corruption / ORA-600 [kddummy_blkchk] [6110] on update |
| 8277580 | 11.1.0.7.2, 11.2.0.1, 11.2.0.2, 12.1.0.1 | Corruption on compressed tables during Recovery and Quick Multi Delete (QMD). |
| 9964102 | 11.2.0.1 | OERI:2015 / OERI:kddummy_blkchk / undo corruption from supplementat logging with compressed tables |
| 8613137 | 11.1.0.7.2, 11.2.0.1 | ORA-600 updating table with DEFERRED constraints |
| 8360192 | 11.1.0.7.6, 11.2.0.1 | ORA-600 [kdBlkCheckError] [6110] / corruption from insert |
| 8239658 | 10.2.0.5, 11.2.0.1 | Dump / corruption writing row to compressed table |
| 8198906 | 10.2.0.5, 11.2.0.1 | OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents |
| 7715244 | 11.1.0.7.2, 11.2.0.1 | Corruption on compressed tables. Error codes 6103 / 6110 |
| 7662491 | 10.2.0.4.2, 10.2.0.5, 11.1.0.7.4, 11.2.0.1 | Array Update can corrupt a row. Errors OERI[kghstack_free1] or OERI[kddummy_blkchk][6110] |
| 7411865 | 10.2.0.4.2, 10.2.0.5, 11.1.0.7.1, 11.2.0.1 | OERI:13030 / ORA-1407 / block corruption from UPDATE .. RETURNING DML with trigger |
| 7331181 | 11.2.0.1 | ORA-1555 or OERI [kddummy_blkchk] [file#] [block#] [6126] during CR Rollback in query |
| 7293156 | 11.1.0.7, 11.2.0.1 | ORA-600 [2023] by Parallel Transaction Rollback when applying Multi-block undo Head-piece / Tail-piece |
| 7041254 | 11.1.0.7.5, 11.2.0.1 | ORA-19661 during RMAN restore check logical of compressed backup / IOT dummy key |
| 6760697 | 10.2.0.4.3, 10.2.0.5, 11.1.0.7, 11.2.0.1 | DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY does not detect certain segment header block corruption |
| 6647480 | 10.2.0.4.4, 10.2.0.5, 11.1.0.7.3, 11.2.0.1 | Corruption / OERI [kddummy_blkchk] .. [18021] with ASSM |
| 6134368 | 10.2.0.5, 11.2.0.1 | ORA-1407 / block corruption from UPDATE .. RETURNING DML with trigger – SUPERCEDED |
| 6057203 | 10.2.0.4, 11.1.0.7, 11.2.0.1 | Corruption with zero length column (ZLC) / OERI [kcbchg1_6] from Parallel update |
| 6653934 | 10.2.0.4.2, 10.2.0.5, 11.1.0.7 | Dump / block corruption from ONLINE segment shrink with ROWDEPENDENCIES |
| 6674196 | 10.2.0.4, 10.2.0.5, 11.1.0.6 | OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM |
| 5599596 | 10.2.0.4, 11.1.0.6 | Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables |
| 5496041 | 10.2.0.4, 11.1.0.6 | OERI[6006] / index corruption on compressed index |
| 5386204 | 10.2.0.4.1, 10.2.0.5, 11.1.0.6 | Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment |
| 5363584 | 10.2.0.4, 11.1.0.6 | Array insert into table can corrupt redo |
| 4602031 | 10.2.0.2, 11.1.0.6 | Block corruption from UPDATE or MERGE into compressed table |
| 4493447 | 11.1.0.6 | Spurious ORA-600 [kddummy_blkchk] [file#] [block#] [6145] on rollback of array update |
| 4329302 | 11.1.0.6 | OERI [kddummy_blkchk] [file#] [block#] [6145] on rollback of update with logminer |
| 6075487 | 10.2.0.4 | OERI[kddummy_blkchk]..[18020/18026] for DDL on plugged ASSM tablespace with FLASHBACK |
| 4054640 | 10.1.0.5, 10.2.0.1 | Block corruption / OERI [kddummy_blkchk] at physical standby |
| 4000840 | 10.1.0.4, 10.2.0.1, 9.2.0.7 | Update of a row with more than 255 columns can cause block corruption |
| 3772033 | 9.2.0.7, 10.1.0.4, 10.2.0.1 | OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize |
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)
ORA 600 kddummy_blkchk相关bug列表
