ASM add disk ORA-15032 ORA-15075 ORA-15080

问题归档 2019-07-19
24
0 0
摘要:alter diskgroup DATADG_DQ add disk ORA-15075

问题描述

故障日志

SQL> alter diskgroup DATADG_DQ add disk '/dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6';
alter diskgroup DATADG_DQ add disk '/dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15075: disk(s) are not visible cluster-wide
ORA-15080: synchronous I/O operation to a disk failed


专家解答

 一般出现该错误主要是由于磁盘在两个节点不是共享导致,本文档诊断是否一致磁盘

$> ls -lrt /dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6

lrwxrwxrwx 1 root root 67 Apr 14 12:45 /dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6 -> ../../devices/scsi_vhci/ssd@g60060e80100a9f40053021fc00000017:g,raw

$> ls -lrt /devices/scsi_vhci/ssd@g60060e80100a9f40053021fc00000017:g,raw

crw-r----- 1 root sys 118, 278 Apr 25 14:14 /devices/scsi_vhci/ssd@g60060e80100a9f40053021fc00000017:g,raw

权限不正确需要重新赋予权限

 chown oracle:dba /dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6

 echo "This information should be visible from each node to prove that this "c6t60060E80100A9F40053021FC00000017d0s6" disk device is shared among all the RAC nodes" >> fakedata.txt

 chown oracle:dba /dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6dd if=/home/oracle/test/fakedata.txt of=/dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6 bs=4096 count=1 conv=notrunc

使用dd命令在一个节点中写入磁盘数据

 

在另外一个节点中检查文件是否可以看到

od -c /dev/rdsk/c6t60060E80100A9F40053021FC00000017d0s6 | more

 

0000000 = = = = = = = = = = = = = = = =

0000020 = = = = = = \n T u e A p r 2

0000040 6 1 4 : 4 1 : 5 0 E D T 2

0000060 0 1 1 \n T h i s i n f o r m a

0000100 t i o n s h o u l d b e v i s i

0000120 b l e f r o m e a c h n o

0000140 d e t o p r o v e t h a t

0000160 t h i s c 6 t 6 0 0 6 0 E 8

0000200 0 1 0 0 A 9 F 4 0 0 5 3 0 2 1 F

0000220 C 0 0 0 0 0 0 1 7 d 0 s 6 d i

0000240 s k d e v i c e i s s h a

0000260 r e d a m o n g a l l t h

0000300 e R A C n o d e s \n = = = =

0000320 = = = = = = = = = = = = = = = =

0000340 = = \n \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0

0000360 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0

*

3720000

如果内容不是以上则不是共享磁盘,需要检查存储链路。

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
热门文章
近期活动
全部
相关课程
全部