如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
适用于：
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;
Comment