解决此故障我也是第一次碰到,中间也是一头雾水,好在最终解决了问题
1.客户反馈数据库节点1宕机,切无法ping通主机,无法登录,登录主机后查看alert.log报错信息基本上断定网络突然出现问题,从系统层面主机发生重启
2.主机恢复后,启动crs集群,发现数据库没有正常open,手工open操作的时候提示redo磁盘组无法挂载
3.查看集群状态信息,发现redo磁盘组offline状态,登录asm实例手工进行mount操作报错,提示没有权限
ERROR at line 1: ORA-15032: not all alterations performed ORA-15260: permission denied on ASM disk group
4.查看对应的磁盘权限发现是grid:oinstall权限,手工进行赋权grid:asmadmin权限后,再次尝试进行挂载操作,再次报错,
ERROR: diskgroup REDO1 was not mounted ORA-15032: not all alterations performed ORA-15017: diskgroup "REDO1" cannot be mounted ORA-15040: diskgroup is incomplete
5.通过查看+asm_alert日志发现如下报错,提示磁盘冲突
6.查看磁盘信息,发现冲突的磁盘属性都是一样的,
7.查看asm实例的asm_diskstring信息为:/dev/rdisk/
8.针对此类故障,我将冲突的磁盘属性修改后,正常mount
chown bin:sys disk615
chown bin:sys disk615
参考:
标签:查看,一波三折,报错,磁盘,挂载,asm,ORA From: https://www.cnblogs.com/hanglinux/p/17323846.html