标签云
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,679)
- DB2 (22)
- MySQL (73)
- Oracle (1,541)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (563)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- 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)
-
最近发表
- 解决oracle数据文件路径有回车故障
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空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
标签归档:kffmVerify_4
ORA-600 kffmLoad_1 kffmVerify_4
有朋友asm运行一段时间asm实例会报错导致数据库实例异常
Wed Dec 23 08:31:55 2020 Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm1_asmb_6729.trc: ORA-00600: internal error code, arguments: [kffmLoad_1], [4365], [1], [], [], [], [], [] Wed Dec 23 08:31:55 2020 Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm1_asmb_6729.trc: ORA-00600: internal error code, arguments: [kffmLoad_1], [4365], [1], [], [], [], [], [] Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm1_asmb_29743.trc: ORA-00600: internal error code, arguments: [kffmLoad_1], [670], [1], [], [], [], [], [] Wed Dec 23 09:10:22 2020 Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm1_asmb_29743.trc: ORA-00600: internal error code, arguments: [kffmLoad_1], [670], [1], [], [], [], [], [] Wed Dec 23 09:10:22 2020 Wed Dec 23 10:18:33 2020 Errors in file /u01/app/oracle/admin/+ASM/udump/+asm1_ora_25890.trc: ORA-00600: internal error code, arguments: [kffmVerify_4], [0], [0], [887], [1005986561], [1352], [1], [0]
对应的trace文件
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/10.2.0/db System name: Linux Node name: shb01 Release: 2.6.18-348.el5 Version: #1 SMP Wed Nov 28 21:22:00 EST 2012 Machine: x86_64 Instance name: +ASM1 Redo thread mounted by this instance: 0 <none> Oracle process number: 29 Unix process pid: 26337, image: oracle@xff01 (TNS V1-V3) *** ACTION NAME:() 2020-12-22 19:03:41.272 *** MODULE NAME:(sp_ocap@xff01 (TNS V1-V3)) 2020-12-22 19:03:41.272 *** SERVICE NAME:() 2020-12-22 19:03:41.272 *** SESSION ID:(143.1) 2020-12-22 19:03:41.272 *** 2020-12-22 19:03:41.272 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kffmVerify_4], [0], [0], [1657], [1005987045], [152], [1], [0] Current SQL statement for this session: DECLARE fileType varchar2(16); fileName varchar2(1024); blkSz number; fileSz number; hdl number; plksz number; BEGIN fileName := '+DATA4/xifenfei/onlinelog/group_6.1657.1005987045'; BEGIN dbms_diskgroup.getfileattr(fileName,fileType,fileSz, blkSz); dbms_diskgroup.open(fileName,'r',fileType,blkSz,hdl,plkSz,fileSz); EXCEPTION WHEN OTHERS then :rc := SQLCODE; :err_msg := SQLERRM; return; END; :handle := hdl; :bsz := blkSz; :bcnt := fileSz; :rc := 0; END; ----- PL/SQL Call Stack ----- object line object handle number name 0x15ce59360 96 package body SYS.X$DBMS_DISKGROUP 0x15cd88568 12 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst()+31 call ksedst1() 000000000 ? 000000001 ? 7FFFBDFC3450 ? 7FFFBDFC34B0 ? 7FFFBDFC33F0 ? 000000000 ? ksedmp()+610 call ksedst() 000000000 ? 000000001 ? 7FFFBDFC3450 ? 7FFFBDFC34B0 ? 7FFFBDFC33F0 ? 000000000 ? ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ? 7FFFBDFC3450 ? 7FFFBDFC34B0 ? 7FFFBDFC33F0 ? 000000000 ? kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ? 7FFFBDFC3450 ? 7FFFBDFC34B0 ? 7FFFBDFC33F0 ? 000000000 ? kgeasnmierr()+163 call kgerinv() 0068996E0 ? 009AA2670 ? 7FFFBDFC34B0 ? 7FFFBDFC33F0 ? 000000000 ? 000000000 ? kffmVerify()+379 call kgeasnmierr() 0068996E0 ? 009AA2670 ? 7FFFBDFC34B0 ? 7FFFBDFC33F0 ? 000000000 ? 000000000 ? kfioIdentify()+1276 call kffmVerify() 000000000 ? 00000000D ? 000000001 ? 927B814400000004 ? 3BF624E500000679 ? 000000000 ? ksfd_osmopn()+1138 call kfioIdentify() 7FFFBDFC4820 ? 15DB873F4 ? 15DB87556 ? 000000200 ? 7FFF00000003 ? 15DB873C8 ? ksfdopn()+1014 call ksfd_osmopn() 7FFFBDFC4820 ? 00000002D ? 000000200 ? 000000003 ? 2B3800020000 ? 15F3031F0 ? kfpkgDGOpenFile()+2 call ksfdopn() 7FFFBDFC4820 ? 00000002D ? 301 000000200 ? 000000003 ? 000020000 ? 15F3031F0 ? pevm_icd_call_commo call kfpkgDGOpenFile() 2B383F459FA8 ? 00000002D ? n()+1003 2B383F439070 ? 000000003 ? 000020000 ? 15F3031F0 ? pfrinstr_ICAL()+228 call pevm_icd_call_commo 7FFFBDFC5700 ? 000000000 ? n() 000000001 ? 000000001 ? 000000007 ? 7FFF00000000 ? pfrrun_no_tool()+65 call pfrinstr_ICAL() 2B383F459FA8 ? 005DBD8AA ? 2B383F45A010 ? 000000001 ? 000000007 ? 7FFF00000000 ? pfrrun()+906 call pfrrun_no_tool() 2B383F459FA8 ? 005DBD8AA ? 2B383F45A010 ? 000000001 ? 000000007 ? 7FFF00000000 ? plsql_run()+841 call pfrrun() 2B383F459FA8 ? 000000000 ? 2B383F45A010 ? 7FFFBDFC5700 ? 000000007 ? 15CD77BD6 ? peicnt()+298 call plsql_run() 2B383F459FA8 ? 000000001 ? 000000000 ? 7FFFBDFC5700 ? 000000007 ? 900000000 ? kkxexe()+503 call peicnt() 7FFFBDFC5700 ? 2B383F459FA8 ? 2B383F438830 ? 7FFFBDFC5700 ? 2B383F4367D8 ? 900000000 ? opiexe()+4691 call kkxexe() 2B383F4561D8 ? 2B383F459FA8 ? 2B383F438830 ? 15C160BD8 ? 0040D677F ? 900000000 ? kpoal8()+2273 call opiexe() 000000049 ? 000000003 ? 7FFFBDFC6950 ? 000000001 ? 0040D677F ? 900000000 ? opiodr()+984 call kpoal8() 00000005E ? 000000017 ? 7FFFBDFC9830 ? 000000001 ? 000000001 ? 900000000 ? ttcpip()+1012 call opiodr() 00000005E ? 000000017 ? 7FFFBDFC9830 ? 000000000 ? 0059C35D0 ? 900000000 ? opitsk()+1322 call ttcpip() 0068A13B0 ? 7FFFBDFC75A0 ? 7FFFBDFC9830 ? 000000000 ? 7FFFBDFC9328 ? 7FFFBDFC9998 ? opiino()+1026 call opitsk() 000000003 ? 000000000 ? 7FFFBDFC9830 ? 000000001 ? 000000000 ? 4E6111C00000001 ? opiodr()+984 call opiino() 00000003C ? 000000004 ? 7FFFBDFCA9F8 ? 000000001 ? 000000000 ? 4E6111C00000001 ? opidrv()+547 call opiodr() 00000003C ? 000000004 ? 7FFFBDFCA9F8 ? 000000000 ? 0059C3080 ? 4E6111C00000001 ? sou2o()+114 call opidrv() 00000003C ? 000000004 ? 7FFFBDFCA9F8 ? 000000000 ? 0059C3080 ? 4E6111C00000001 ? opimai_real()+163 call sou2o() 7FFFBDFCA9D0 ? 00000003C ? 000000004 ? 7FFFBDFCA9F8 ? 0059C3080 ? 4E6111C00000001 ? main()+116 call opimai_real() 000000002 ? 7FFFBDFCAA60 ? 000000004 ? 7FFFBDFCA9F8 ? 0059C3080 ? 4E6111C00000001 ? __libc_start_main() call main() 000000002 ? 7FFFBDFCAA60 ? +244 000000004 ? 7FFFBDFCA9F8 ? 0059C3080 ? 4E6111C00000001 ? _start()+41 call __libc_start_main() 0007230B8 ? 000000002 ? 7FFFBDFCABB8 ? 000000000 ? 0059C3080 ? 000000002 ? --------------------- Binary Stack Dump ---------------------
结合mos信息ORA-600[KFFMVERIFY_4] OR ORA-600 [kffmLoad_1], [131635] REPORTED ON THE ASMINSTANCE (Doc ID 794103.1)的描述,由于多个进程/现场使用dbms_diskgroup访问不同磁盘组之时可能触发
BUG:6377738 – ASMB ORA-00600 [KFFMVERIFY_4]
BUG:8328467 – ASM CRASHED WITH ORA-600[KFFMVERIFY_4] OR [KFFMVERIFY_4] AND [KFFMLOAD_1]
从而导致asm实例crash,引起数据库异常.结合客户这边的情况,确认他们是使用了多个SharePlex程序同步数据,而且redo放在多个磁盘组中,从而出现该问题.临时解决方案为把所有的redo和归档放一个磁盘组,这样多个SharePlex进程调用dbms_diskgroup访问redo/arch不会触发该bug.