标签云
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,655)
- DB2 (22)
- MySQL (71)
- Oracle (1,519)
- Data Guard (51)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (158)
- 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备份恢复 (553)
- Oracle安装升级 (90)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (76)
- 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)
-
最近发表
- 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故障处理
- 19c库启动报ORA-600 kcbzib_kcrsds_1
- DBMS_SESSION.set_context提示ORA-01031问题解决
- redo写丢失导致ORA-600 kcrf_resilver_log_1故障
- 硬件故障导致ORA-01242 ORA-01122等错误
- 200T 数据库非归档无备份恢复
- 利用flashback快速恢复failover 的备库
- [comingback2022@cock.li].eking和[tsai.shen@mailfence.com].faust扩展名勒索病毒数据库可以完美恢复
- opatch auto 出现unable to get oracle owner for 错误
- Oracle 23ai 表和视图的列最多支持到4096个
- 断电引起redo和数据文件不一致故障恢复
- ORA-03113: 通信通道的文件结尾
标签归档:kfrHtAdd01
ORA-00600 kfrHtAdd01
由于存储掉电,报ORA-15096: lost disk write detected错误,无法mount磁盘组.
Sun Dec 20 16:56:51 2020 SQL> alter diskgroup data mount NOTE: cache registered group DATA number=1 incarn=0x0c1a7a4e NOTE: cache began mount (first) of group DATA number=1 incarn=0x0c1a7a4e NOTE: Assigning number (1,2) to disk (/dev/mapper/multipath12) NOTE: Assigning number (1,5) to disk (/dev/mapper/multipath15) NOTE: Assigning number (1,3) to disk (/dev/mapper/multipath13) NOTE: Assigning number (1,7) to disk (/dev/mapper/multipath17) NOTE: Assigning number (1,1) to disk (/dev/mapper/multipath11) NOTE: Assigning number (1,6) to disk (/dev/mapper/multipath16) NOTE: Assigning number (1,0) to disk (/dev/mapper/multipath10) NOTE: Assigning number (1,4) to disk (/dev/mapper/multipath14) Sun Dec 20 16:56:57 2020 NOTE: GMON heartbeating for grp 1 GMON querying group 1 at 19 for pid 32, osid 130347 NOTE: cache opening disk 0 of grp 1: DATA_0000 path:/dev/mapper/multipath10 NOTE: F1X0 found on disk 0 au 2 fcn 0.14159360 NOTE: cache opening disk 1 of grp 1: DATA_0001 path:/dev/mapper/multipath11 NOTE: F1X0 found on disk 1 au 2 fcn 0.14159360 NOTE: cache opening disk 2 of grp 1: DATA_0002 path:/dev/mapper/multipath12 NOTE: F1X0 found on disk 2 au 2 fcn 0.14159360 NOTE: cache opening disk 3 of grp 1: DATA_0003 path:/dev/mapper/multipath13 NOTE: cache opening disk 4 of grp 1: DATA_0004 path:/dev/mapper/multipath14 NOTE: cache opening disk 5 of grp 1: DATA_0005 path:/dev/mapper/multipath15 NOTE: cache opening disk 6 of grp 1: DATA_0006 path:/dev/mapper/multipath16 NOTE: cache opening disk 7 of grp 1: DATA_0007 path:/dev/mapper/multipath17 NOTE: cache mounting (first) normal redundancy group 1/0x0C1A7A4E (DATA) Sun Dec 20 16:56:57 2020 * allocate domain 1, invalid = TRUE Sun Dec 20 16:56:58 2020 NOTE: attached to recovery domain 1 NOTE: starting recovery of thread=1 ckpt=233.4189 group=1 (DATA) NOTE: starting recovery of thread=2 ckpt=542.6409 group=1 (DATA) lost disk write detected during recovery (apply) NOTE: recovery (pass 2) of diskgroup 1 (DATA) caught error ORA-15096 Errors in file /grid/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_130347.trc: ORA-15096: lost disk write detected Abort recovery for domain 1 NOTE: crash recovery signalled OER-15096 ERROR: ORA-15096 signalled during mount of diskgroup DATA NOTE: cache dismounting (clean) group 1/0x0C1A7A4E (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 130347, image: oracle@db1.rac.com (TNS V1-V3) NOTE: lgwr not being msg'd to dismount
通过一系列修复之后报错如下
Sun Dec 20 20:12:35 2020 NOTE: GMON heartbeating for grp 1 GMON querying group 1 at 23 for pid 26, osid 67538 Sun Dec 20 20:12:35 2020 NOTE: cache opening disk 0 of grp 1: DATA_0000 path:/dev/mapper/multipath10 NOTE: F1X0 found on disk 0 au 2 fcn 0.14159360 NOTE: cache opening disk 1 of grp 1: DATA_0001 path:/dev/mapper/multipath11 NOTE: F1X0 found on disk 1 au 2 fcn 0.14159360 NOTE: cache opening disk 2 of grp 1: DATA_0002 path:/dev/mapper/multipath12 NOTE: F1X0 found on disk 2 au 2 fcn 0.14159360 NOTE: cache opening disk 3 of grp 1: DATA_0003 path:/dev/mapper/multipath13 NOTE: cache opening disk 4 of grp 1: DATA_0004 path:/dev/mapper/multipath14 NOTE: cache opening disk 5 of grp 1: DATA_0005 path:/dev/mapper/multipath15 NOTE: cache opening disk 6 of grp 1: DATA_0006 path:/dev/mapper/multipath16 NOTE: cache opening disk 7 of grp 1: DATA_0007 path:/dev/mapper/multipath17 NOTE: cache mounting (first) normal redundancy group 1/0x64848829 (DATA) Sun Dec 20 20:12:36 2020 * allocate domain 1, invalid = TRUE Sun Dec 20 20:12:36 2020 NOTE: attached to recovery domain 1 NOTE: Fallback recovery: thread 2 read 10751 blocks oldest redo found in ABA 540.6429 NOTE: Fallback recovery: thread 1 read 10751 blocks oldest redo found in ABA 232.4218 Errors in file /grid/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_67538.trc (incident=1692689): ORA-00600: internal error code, arguments: [kfrHtAdd01], [2147483651], [1025], [0], [38660545], [0], [38687990], [1], [2], [6429], [], [] Incident details in: /grid/app/grid/diag/asm/+asm/+ASM1/incident/incdir_1692689/+ASM1_ora_67538_i1692689.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Sun Dec 20 20:12:39 2020 Sweep [inc][1692689]: completed Sweep [inc2][1692689]: completed Errors in file /grid/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_67538.trc: ORA-00600: internal error code, arguments: [kfrHtAdd01], [2147483651], [1025], [0], [38660545], [0], [38687990], [1], [2], [6429], [], [] NOTE: crash recovery signalled OER-600 ERROR: ORA-600 signalled during mount of diskgroup DATA NOTE: cache dismounting (clean) group 1/0x64848829 (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 67538, image: oracle@db1.rac.com (TNS V1-V3) NOTE: lgwr not being msg'd to dismount freeing rdom 1 NOTE: detached from domain 1 NOTE: cache dismounted group 1/0x64848829 (DATA) NOTE: cache ending mount (fail) of group DATA number=1 incarn=0x64848829 NOTE: cache deleting context for group DATA 1/0x64848829 GMON dismounting group 1 at 24 for pid 26, osid 67538 NOTE: Disk DATA_0000 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0001 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0002 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0003 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0004 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0005 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0006 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0007 in mode 0x7f marked for de-assignment ERROR: diskgroup DATA was not mounted ORA-00600: internal error code, arguments: [kfrHtAdd01], [2147483651], [1025], [0], [38660545], [0], [38687990], [1], [2], [6429], [], [] ERROR: alter diskgroup data mount
分析trace文件
*** 2020-12-20 20:11:54.956 kfdp_query(DATA): 19 ----- Abridged Call Stack Trace ----- ksedsts()+465<-kfdp_query()+530<-kfdPstSyncPriv()+585<-kfgFinalizeMount()+1630<-kfgscFinalize()+1433< -kfgForEachKfgsc()+285<-kfgsoFinalize()+135<-kfgFinalize()+398<-kfxdrvMount()+5558<-kfxdrvEntry() +2207<-opiexe()+20624<-opiosq0()+3932<-kpooprx()+274<-kpoal8()+842<-opiodr()+917<-ttcpip() +2183<-opitsk()+1710<-opiino()+969<-opiodr()+917<-opidrv()+570<-sou2o() +103<-opimai_real()+133<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253 ----- End of Abridged Call Stack Trace ----- 2020-12-20 20:11:55.393106 : Start recovery for domain=1, valid=0, flags=0x4 NOTE: starting recovery of thread=1 ckpt=233.4189 group=1 (DATA) NOTE: starting recovery of thread=2 ckpt=542.6409 group=1 (DATA) lost disk write detected during recovery (apply): last written kfcn: 0.38747593 aba=233.4208 thd=1 kfcn_kfrbcd=0.38747593 flags_kfrbcd=0x001c aba=542.6410 thd=2 CE: (0x0x66edc798) group=1 (DATA) fn=4 blk=1 hashFlags=0x0000 lid=0x0002 lruFlags=0x0000 bastCount=1 mirror=0 flags_kfcpba=0x38 copies=3 blockIndex=1 AUindex=0 AUcount=0 loctr fcn=0.0 copy #0: disk=6 au=35 flags=01 copy #1: disk=0 au=34 flags=01 copy #2: disk=4 au=52 flags=01 BH: (0x0x66e10d00) bnum=33 type=COD_RBO state=rcv chgSt=not modifying pageIn=rcvRead flags=0x00000000 pinmode=excl lockmode=null bf=0x66020000 kfbh_kfcbh.fcn_kfbh = 0.38747538 lowAba=0.0 highAba=0.0 modTime=0 last kfcbInitSlot return code=null chgCount=0 cpkt lnk is null ralFlags=0x00000000 PINS: (kfcbps) pin=91 get by kfr.c line 7879 mode=excl fn=4 blk=1 status=pinned flags=0x88000000 flags2=0x00000000 class=0 type=INVALID stateWanted=rcvRead bastCount=1 waitStatus=0x00000000 relocCount=0 scanBastCount=0 scanBxid=0 scanSkipCode=0 last released by kfc.c 21183 NOTE: recovery (pass 2) of diskgroup 1 (DATA) caught error ORA-15096 last new 0.0 kfrPass2: dump of current log buffer for error 15096 follows ======================= OSM metadata block dump: kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 8 ; 0x002: KFBTYP_CHNGDIR kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 17162 ; 0x004: blk=17162 kfbh.block.obj: 3 ; 0x008: file=3 kfbh.check: 4226524538 ; 0x00c: 0xfbeba57a kfbh.fcn.base: 38747431 ; 0x010: 0x024f3d27 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kfracdb.aba.seq: 542 ; 0x000: 0x0000021e kfracdb.aba.blk: 6409 ; 0x004: 0x00001909 kfracdb.ents: 1 ; 0x008: 0x0001 kfracdb.ub2spare: 0 ; 0x00a: 0x0000 kfracdb.lge[0].valid: 1 ; 0x00c: V=1 B=0 M=0 kfracdb.lge[0].chgCount: 1 ; 0x00d: 0x01 kfracdb.lge[0].len: 68 ; 0x00e: 0x0044 kfracdb.lge[0].kfcn.base: 38747432 ; 0x010: 0x024f3d28 kfracdb.lge[0].kfcn.wrap: 0 ; 0x014: 0x00000000 kfracdb.lge[0].bcd[0].kfbl.blk: 1292 ; 0x018: blk=1292 kfracdb.lge[0].bcd[0].kfbl.obj: 1 ; 0x01c: file=1 kfracdb.lge[0].bcd[0].kfcn.base:38743102 ; 0x020: 0x024f2c3e kfracdb.lge[0].bcd[0].kfcn.wrap: 0 ; 0x024: 0x00000000 kfracdb.lge[0].bcd[0].oplen: 8 ; 0x028: 0x0008 kfracdb.lge[0].bcd[0].blkIndex: 12 ; 0x02a: 0x000c kfracdb.lge[0].bcd[0].flags: 28 ; 0x02c: F=0 N=0 F=1 L=1 V=1 A=0 C=0 kfracdb.lge[0].bcd[0].opcode: 135 ; 0x02e: 0x0087 kfracdb.lge[0].bcd[0].kfbtyp: 4 ; 0x030: KFBTYP_FILEDIR kfracdb.lge[0].bcd[0].redund: 19 ; 0x031: SCHE=0x1 NUMB=0x3 kfracdb.lge[0].bcd[0].pad: 63903 ; 0x032: 0xf99f kfracdb.lge[0].bcd[0].KFFFD_COMMIT.modts.hi:33108586 ; 0x034: HOUR=0xa DAYS=0x13 MNTH=0xc YEAR=0x7e4 kfracdb.lge[0].bcd[0].KFFFD_COMMIT.modts.lo:0 ; 0x038: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0 kfracdb.lge[0].bcd[0].au[0]: 292415 ; 0x03c: 0x0004763f kfracdb.lge[0].bcd[0].au[1]: 292452 ; 0x040: 0x00047664 kfracdb.lge[0].bcd[0].au[2]: 292474 ; 0x044: 0x0004767a kfracdb.lge[0].bcd[0].disks[0]: 2 ; 0x048: 0x0002 kfracdb.lge[0].bcd[0].disks[1]: 1 ; 0x04a: 0x0001 kfracdb.lge[0].bcd[0].disks[2]: 0 ; 0x04c: 0x0000
彻底屏蔽asm的实例恢复,mount磁盘组,尝试启动库进行数据库恢复.如果如果此类asm无法mount问题,无法自行解决请联系我们
电话/微信:17813235971 Q Q:107644445 E-Mail:dba@xifenfei.com