Oracle ASM 磁盘 header_status UNKNOWN 且磁盘组不在mount

Posted by PDSERVICE on May 27, 2016 In

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

ORA-27063: 读取/写入的字节数不正确

oerr ora 27063

27063, 00000, "number of bytes read/written is incorrect"

// *Cause: the number of bytes read/written as returned by aiowait

// does not match the original number, additional information

// indicates both these numbers

// *Action: check errno

ORA-15040: 磁盘组不完整

oerr ora 15040

15040, 00000, "diskgroup is incomplete"

// *Cause: Some of the disks comprising a diskgroup were not present.

// *Action: Check the hardware to ensure that all disks are functional. Also

// check that the setting of the ASM_DISKSTRING initialization

// parameter has not changed. Alternatively, for normal or high

// redundancy diskgroups, use MOUNT FORCE to offline missing disks

// as part of mounting the diskgroup.

ORA-15042: ASM 磁盘 "" 在组号 "" 中缺失

oerr ora 15042

15042, 00000, "ASM disk \"%s\" is missing from group number \"%s\" "

// *Cause: The specified disk, which is a necessary part of a diskgroup,

// could not be found on the system.

// *Action: Check the hardware configuration.

ORA-15080: 与磁盘的同步 I/O 操作失败

oerr ora 15080

15080, 00000, "synchronous I/O operation to a disk failed"

// *Cause: A synchronous I/O operation invoked on a disk has failed.

// *Action: Make sure that all the disks are operational.

适用于：

Oracle Database – Enterprise Edition – 版本 11.2.0.1 及以上

本文信息适用于任何平台。

*** 11-Jun-2014检查相关性***

症状

Tue Jan 01 22:54:20 2013
SQL> alter diskgroup DG_DWH_201209 mount force
NOTE: cache registered group DG_DWH_201209 number=7 incarn=0xcf54c88d
NOTE: cache began mount (first) of group DG_DWH_201209 number=7 incarn=0xcf54c88d
Errors in file /ora11gr2/app/ora11gr2/diag/asm/+asm/+ASM/trace/+ASM_ora_18332.trc:
ORA-27063: number of bytes read/written is incorrect
WARNING: IO Failed. group:0 disk(number.incarnation):31.0×0 disk_path:/dev/asm/disk7028_dwh_0912t3
AU:0 disk_offset(bytes):0 io_size:4096 operation:Read type:asynchronous
result:I/O error process_id:18332
NOTE: Assigning number (7,6) to disk (/dev/asm/disk2683_dwh_0912t2)
NOTE: Assigning number (7,0) to disk (/dev/asm/disk53_dwh_0912t2)
NOTE: Assigning number (7,1) to disk (/dev/asm/disk55_dwh_0912t2)
NOTE: Assigning number (7,2) to disk (/dev/asm/disk56_dwh_0912t2)
NOTE: Assigning number (7,3) to disk (/dev/asm/disk57_dwh_0912t2)
NOTE: Assigning number (7,4) to disk (/dev/asm/disk58_dwh_0912t2)
NOTE: Assigning number (7,5) to disk (/dev/asm/disk59_dwh_0912t2)
NOTE: Assigning number (7,7) to disk (/dev/asm/disk7023_dwh_0912t3)
NOTE: Assigning number (7,8) to disk (/dev/asm/disk7024_dwh_0912t3)
NOTE: Assigning number (7,9) to disk (/dev/asm/disk7025_dwh_0912t3)
NOTE: Assigning number (7,10) to disk (/dev/asm/disk7026_dwh_0912t3)
NOTE: Assigning number (7,11) to disk (/dev/asm/disk7027_dwh_0912t3)
NOTE: Assigning number (7,13) to disk (/dev/asm/disk7029_dwh_0912t3)
NOTE: Assigning number (7,14) to disk (/dev/asm/disk7030_dwh_0912t3)
Tue Jan 01 22:54:35 2013
NOTE: start heartbeating (grp 7)
Tue Jan 01 22:54:35 2013
kfdp_query(DG_DWH_201209): 143
kfdp_queryBg(): 143
NOTE: Assigning number (7,12) to disk ()
kfdp_query(DG_DWH_201209): 144
kfdp_queryBg(): 144
NOTE: cache dismounting (not clean) group 7/0xCF54C88D (DG_DWH_201209)
NOTE: dbwr not being msg’d to dismount
NOTE: lgwr not being msg’d to dismount
NOTE: cache dismounted group 7/0xCF54C88D (DG_DWH_201209)
NOTE: cache ending mount (fail) of group DG_DWH_201209 number=7 incarn=0xcf54c88d
kfdp_dismount(): 145
kfdp_dismountBg(): 145
NOTE: De-assigning number (7,0) from disk (/dev/asm/disk53_dwh_0912t2)
NOTE: De-assigning number (7,1) from disk (/dev/asm/disk55_dwh_0912t2)
NOTE: De-assigning number (7,2) from disk (/dev/asm/disk56_dwh_0912t2)
NOTE: De-assigning number (7,3) from disk (/dev/asm/disk57_dwh_0912t2)
NOTE: De-assigning number (7,4) from disk (/dev/asm/disk58_dwh_0912t2)
NOTE: De-assigning number (7,5) from disk (/dev/asm/disk59_dwh_0912t2)
NOTE: De-assigning number (7,6) from disk (/dev/asm/disk2683_dwh_0912t2)
NOTE: De-assigning number (7,7) from disk (/dev/asm/disk7023_dwh_0912t3)
NOTE: De-assigning number (7,8) from disk (/dev/asm/disk7024_dwh_0912t3)
NOTE: De-assigning number (7,9) from disk (/dev/asm/disk7025_dwh_0912t3)
NOTE: De-assigning number (7,10) from disk (/dev/asm/disk7026_dwh_0912t3)
NOTE: De-assigning number (7,11) from disk (/dev/asm/disk7027_dwh_0912t3)
NOTE: De-assigning number (7,12) from disk ()<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
NOTE: De-assigning number (7,13) from disk (/dev/asm/disk7029_dwh_0912t3)
NOTE: De-assigning number (7,14) from disk (/dev/asm/disk7030_dwh_0912t3)
ERROR: diskgroup DG_DWH_201209 was not mounted
NOTE: cache deleting context for group DG_DWH_201209 7/-816527219
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk “12” is missing from group number “7”
ORA-15080: synchronous I/O operation to a disk failed
ERROR: alter diskgroup DG_DWH_201209 mount force
Tue Jan 01 22:54:41 2013
Errors in file /ora11gr2/app/ora11gr2/diag/asm/+asm/+ASM/trace/+ASM_ora_12110.trc:
ORA-27063: number of bytes read/written is incorrect
WARNING: IO Failed. group:0 disk(number.incarnation):31.0×0 disk_path:/dev/asm/disk7028_dwh_0912t3
AU:0 disk_offset(bytes):0 io_size:4096 operation:Read type:asynchronous
result:I/O error process_id:12110
Tue Jan 01 22:54:41 2013

在asm sqlplus 上v$asm_disk 视图中：

0 31 31 0 CLOSED UNKNOWN ONLINE NORMAL UNKNOWN System 860160 0 0 0 0 /dev/asm/disk7028_dwh_0912t3 31-DEC-2012 22:56:31 31-DEC-2012 22:56:31 0 0 N 1024 REGULAR

原因

在OS级别，Async IOs无法为受影响磁盘组的一个磁盘完成
[27199] mmap(NULL, 3336, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7d7f4000
[27199] open(“/dev/asm/disk7028_dwh_0912t3”, O_RDONLY, 07643) = 17
[27199] fstat(17, 0x7fffc8a0) ………………………. = 0
[27199] ioctl(17, DIOC_DESCRIBE, 0x7fffc870) …………. = 0
[27199] lseek(17, 0, SEEK_SET) ……………………… = 0
[27199] read(17, 0x7fffc910, 1024) ………………….. ERR#22 EINVAL<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
[27199] close(17) …………………………………. = 0
[27199] write(2, “e f i _ l s : “, 8) ……………… = 8
[27199] write(2, “r e a d f r o “, 8) ……………… = 8
[27199] write(2, “m d e v i c e “, 8) ……………… = 8
[27199] write(2, ” f a i l e d “, 7) ……………….. = 7
[27199] write(2, “( e r r n o = “, 8) ……………… = 8
[27199] write(2, ” “, 1) ………………………….. = 1
[27199] write(2, “2 2 ) “, 3) ………………………. = 3
[27199] write(2, “\n”, 1) ………………………….. = 1
[27199] exit(25) ………………………………….. WIFEXITED(25)
[27191] waitpid(-1, WIFEXITED(25), WUNTRACED) ………… = 27199

从以上错误中，似乎open () syscall失败，即OS 级别unix calls.
解决方案
1.请包括系统管理员并在OS级别修正问题。

然后手动mount 磁盘组。
并再次通过ASM 实例(SQL*Plus)验证磁盘状态：

SQL> select name,state from v$asm_diskgroup;

You are here

Oracle ASM 磁盘 header_status UNKNOWN 且磁盘组不在mount