本帖最后由 新手719447 于 2020-7-20 16:29 编辑
Oracle:11.2.0.4
Linux:RHEL6.8
2节点:rac1、rac2
主机名:ze02db01、ze02db02
故障复盘:
在节点2-ze02db02,停掉实例rac2
/u01/app/11.2.0/grid/bin/srvctl stop instance -d orcl
/u01/app/11.2.0/grid/bin/srvctl start instance -d orcl
此时,在节点1-ze02db01 ,查看数据库CRS状态不正常
ora.orcl.db
1 ONLINE ONLINE ze02db01 Open
2 ONLINE ONLINE ze02db02 starting ...
然后,我将在节点2-ze02db02
$ sqlplus / as sysdba
>startup
查看数据库CRS状态不正常,尝试在节点1 对节点2,进行重启
/u01/app/11.2.0/grid/bin/srvctl stop instance -d orcl
此时:RAC不能对外提供服务
这个时候,进入SQLPLUS将实例关闭 $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 20 16:13:46 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Auto某公司 Storage Management, OLAP, Data Mining and Real Application Testing options
SYS@orcl2> shutdown immediate
RAC的资源在节点1,可以正常提供服务 最终发现: 系统multipath -ll多路径软件不能读取共享磁盘 service multipathd restart start_udev
多路径正常,重启节点2的crs、instance、nodeapp、listener 。RAC crs状态仍然不正常。出现lock问题 最终,通过重启节点2服务器, RAC正常 |