webstorm汉化包 extjs6.5 collections paypal dtel语言 angular material drupal7 Avalon vue架构 android实战项目 less官网 float占几个字节 matlab图像识别 oracle添加索引 jquery获取兄弟节点 js控制台打印 oracle存储过程返回值 python循环 python日期转时间戳 python搭建环境 eclipse安装python python返回值 java学习基础 java的输入 java得到当前时间 java线程停止 嵌入式开发教程 h5模板 ip隐藏 linux操作系统原理 亚索刀光特效包 主板芯片组天梯图 js转int pdf拆分工具 din字体下载 魔兽地图七个人 小工具 HTML5从入门到精通 一羽月土米水日古余打一成语 正当防卫4存档
当前位置: 首页 > 学习教程  > 编程语言

asm kfrHtAdd01错误恢复

2020/12/28 19:22:17 文章标签:

由于存储掉电,报ORA-15096: lost disk write detected错误,无法mount磁盘组. Sun Dec 20 16:56:51 2020 SQL> alter diskgroup data mount NOTE: cache registered group DATA number1 incarn0x0c1a7a4e NOTE: cache began mount (first) of group DATA number1 incarn0x0c1…

由于存储掉电,报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磁盘组,尝试启动库进行数据库恢复.


本文链接: http://www.dtmao.cc/news_show_550219.shtml

附件下载

上一篇:spring cloud vs k8s

下一篇:Servlet数据共享

相关教程

    暂无相关的数据...

共有条评论 网友评论

验证码: 看不清楚?