诗檀软件专业数据库修复团队
适用于:
Oracle Database – 企业版- 版本10.2.0.1 到 12.1.0.1 [版本10.2到12.1]
本文档的信息适用于任何平台。
症状
1) 因为接下来的错误，不能安装ASM 磁盘组:
SQL> alter diskgroup bccrecovery mount;
alter diskgroup bccrecovery mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "2"
2) ASM 报告块损坏:
Wed Apr 09 01:26:05 2014
NOTE: SMON starting instance recovery for group BCCRECOVERY domain 2 (mounted)
NOTE: F1X0 found on disk 0 au 2 fcn 0.469914
NOTE: SMON skipping disk 1 - no header
NOTE: starting recovery of thread=2 ckpt=2.10251 group=2 (BCCRECOVERY)
WARNING: ASM recovery read a corrupted ACD block 21004
NOTE: a corrupted block was dumped to the trace file
ORA-15196: invalid ASM block header [kfr.c:8098] [endian_kfbh] [3] [21004] [0 != 1]
ERROR: ASM recovery failed to read ACD block 21004
NOTE: cache initiating offline of disk 1 group BCCRECOVERY
NOTE: process _smon_+asm1 (26726) initiating offline of disk 1.3915939526 (BCCRECOVERY_0001) with mask 0x7e in group 2
原因
1) “/dev/emcpowerl” (BCCRECOVERY_0001)磁盘被OS卷重叠, 它显示了有关 “LVM2 001” 逻辑卷的OS 元数据(所有的ASM 元数据被清除):
[ebernal@dbaasm new2]$ kfed read BCCRECOVERY_0001_emcpowerl.dump | head -25
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: blk=0
kfbh.block.obj: 0 ; 0x008: file=0
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
2ABD671E9400 00000000 00000000 00000000 00000000 [................]
Repeat 31 times
2ABD671E9600 4542414C 454E4F4C 00000001 00000000 [LABELONE........]
2ABD671E9610 E4E1DDB1 00000020 324D564C 31303020 [.... ...LVM2 001] 2ABD671E9620 50365A77 71327874 34303156 4B4E6136 [wZ6Ptx2qV1046aNK]
2ABD671E9630 35395159 5147634C 487A5A38 63575A37 [YQ95LcGQ8ZzH7ZWc]
2ABD671E9640 00000000 00000019 00030000 00000000 [................]
2ABD671E9650 00000000 00000000 00000000 00000000 [................]
2ABD671E9660 00000000 00000000 00001000 00000000 [................]
2ABD671E9670 0002F000 00000000 00000000 00000000 [................]
2ABD671E9680 00000000 00000000 00000000 00000000 [................]
Repeat 215 times
KFED-00322: Invalid content encountered during block traversal: [kfbtTraverseBlock][Invalid OSM block type][][0]
2)““/dev/emcpowerl”磁盘用于创建下一条逻辑OS卷，当它已经指定到 ASM 磁盘组时。
3) 这种重叠损坏了"/dev/emcpowerl" (BCCRECOVERY_0001)磁盘。
解决方法
需要重建 BCCRECOVERY磁盘组，因为BCCRECOVERY 磁盘组，从备份复原的数据库文件被OS重叠, 换句话说，损坏发生在Oracle之外,自从OS卷在“/dev/emcpowerl”磁盘中重叠，它就不能修复。