sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle报错ORA-15032 ORA-15063 ASM磁盘头损坏修改笔记

时间:2016-10-26 19:42   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心案例分析:运维DBA反映Oracle ASM报错ORA-15032 ORA-15063分析原因为ASM磁盘头损坏导致,结合MOS官方文档kfed的repair功能来还原,在10.2.0.5以后才会有这个功能。

1,使用kfed查询记录来还原


这个方法可以用于所有的版本

[oracle@asm10g ~]$ kfed read /dev/mapper/asm1 >/tmp/asm1.txt
[oracle@asm10g ~]$ dd if=/dev/zero of=/dev/mapper/asm1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 1.5e-05 seconds, 273 MB/

SQL> alter diskgroup data mount;
alter diskgroup data mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"


[oracle@asm10g ~]$ kfed dev=/dev/mapper/asm1 o=merge te=/tmp/asm1.txt

SQL> alOracleоter diskgroup data mount;

Diskgroup altered.

2,使用kfed的repair功能来还原


在10.2.0.5以后才会有这个功能
[oracle@asm10g ~]$ dd if=/dev/zero of=/dev/mapper/asm1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 1.5e-05 seconds, 273 MB/s

[oracle@asm10g ~]$ kfed read /dev/mapper/asm1
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 0 ; 0x008: TYPE=0x0 NUMB=0x0
kfbh.check: 0 ; 0x00c: 0x00000000
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
SQL> alter diskgroup data dismount;

Diskgroup altered.

SQL> alter diskgroup data mount;
alter diskgroup data mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"


[oracle@asm10g ~]$ kfed repair /dev/mapper/asm1
[oracle@asm10g ~]$ kfed read /dev/mapper/asm1|more
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check: 3670863882 ; 0x00c: 0xdaccf00a
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000

SQL> alter diskgroup data mount;

Diskgroup altered.
本文固定链接: http://www.htz.pw/2014/06/19/asm-%e7%a3%81%e7%9b%98%e5%a4%b4%e6%8d%9f%e5%9d%8f%e7%89%88%e6%9c%ac10-2-0-5%e4%bb%a5%e5%90%8e.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle报错ORA-15032 ORA-15063 ASM磁盘头损坏修改笔记

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1072.html

Oracle研究中心

关键词:

ORA-15032产生原因和解决办法

ORA-15063产生原因和解决办法

使用kfed的repair功能来还原ASM磁盘头