Oracle12c RAC资源状态处理一例

查看集群状态发现有资源状态不正常，处于INTERMEDIATE阶段，还有一个OFFLINE[root@rac1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.TESTDBDATA.dg
               ONLINE  INTERMEDIATE rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.MGMT.dg
               ONLINE  INTERMEDIATE rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.NEWBACKUP.dg
               ONLINE  INTERMEDIATE rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.OCR.dg
               ONLINE  INTERMEDIATE rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.chad
               ONLINE  OFFLINE      rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.net1.network
               ONLINE  ONLINE       rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
ora.ons
               ONLINE  ONLINE       rac1             STABLE
               ONLINE  ONLINE       rac2             STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
不加-unsupported会报这个提示。
[root@rac1 ~]# crsctl check resource ora.NEWBACKUP.dg 
CRS-4995:  The command 'Check  resource' is invalid in crsctl. Use srvctl for this command.

本以为换成另外一个命令可以改变资源状态，结果报资源属性为只读或者是内部属性，不允许修改。[root@rac1 ~]# crsctl modify resource ora.CHEDBDATA.dg -attr 'STATE=ONLINE'  -unsupported
CRS-2547: Update of an internal or read-only attribute 'STATE (READONLY)' for resource 'ora.CHEDBDATA.dg' is not allowed
CRS-4000: Command Modify failed, or completed with errors.

正确命令应该是这样的。
### diskgroup INTERMEDIATE的问题
[root@rac1 ~]# crsctl check resource  ora.TESTDBDATA.dg -unsupported

ora.chad这个资源offline因为chad资源未启动，使用下面的命令启动即可。
### ora.chad offline的问题
[root@rac1 ~]# srvctl start cha