数据库版本：12.2.0.1.0
1，asm磁盘组状态显示INTERMEDIATE
ora.DATA.dg 磁盘组资源状态显示INTERMEDIATE。
[grid@caiqidb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.DATA.dg
ONLINE INTERMEDIATE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.chad
ONLINE OFFLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.net1.network
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.ons
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.proxy_advm
OFFLINE OFFLINE caiqidb1 STABLE
OFFLINE OFFLINE caiqidb2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE caiqidb2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE caiqidb2 169.254.98.69 192.95
.12.23,STABLE
ora.asm
1 ONLINE ONLINE caiqidb1 Started,STABLE
2 ONLINE ONLINE caiqidb2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.caiqidb1.vip
1 ONLINE ONLINE caiqidb1 STABLE
ora.caiqidb2.vip
1 ONLINE ONLINE caiqidb2 STABLE
ora.cqdb.db
1 ONLINE ONLINE caiqidb1 Open,HOME=/u01/app/o
racle/product/12.2.0
/dbhome_1,STABLE
2 ONLINE ONLINE caiqidb2 Open,HOME=/u01/app/o
racle/product/12.2.0
/dbhome_1,STABLE
ora.cvu
1 ONLINE ONLINE caiqidb2 STABLE
ora.mgmtdb
1 ONLINE ONLINE caiqidb2 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE caiqidb2 STABLE
ora.scan1.vip
1 ONLINE ONLINE caiqidb2 STABLE
--------------------------------------------------------------------------------2 解决版本，使用如下命令解决
crsctl check resource ora.DATA.dg
[grid@caiqidb1 ~]$ crsctl check resource ora.DATA.dg -unsupported
#查询集群软件状态
[grid@caiqidb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.DATA.dg
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.chad
ONLINE OFFLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.net1.network
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.ons
ONLINE ONLINE caiqidb1 STABLE
ONLINE ONLINE caiqidb2 STABLE
ora.proxy_advm
OFFLINE OFFLINE caiqidb1 STABLE
OFFLINE OFFLINE caiqidb2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE caiqidb2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE caiqidb2 169.254.98.69 192.95
.12.23,STABLE
ora.asm
1 ONLINE ONLINE caiqidb1 Started,STABLE
2 ONLINE ONLINE caiqidb2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.caiqidb1.vip
1 ONLINE ONLINE caiqidb1 STABLE
ora.caiqidb2.vip
1 ONLINE ONLINE caiqidb2 STABLE
ora.cqdb.db
1 ONLINE ONLINE caiqidb1 Open,HOME=/u01/app/o
racle/product/12.2.0
/dbhome_1,STABLE
2 ONLINE ONLINE caiqidb2 Open,HOME=/u01/app/o
racle/product/12.2.0
/dbhome_1,STABLE
ora.cvu
1 ONLINE ONLINE caiqidb2 STABLE
ora.mgmtdb
1 ONLINE ONLINE caiqidb2 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE caiqidb2 STABLE
ora.scan1.vip
1 ONLINE ONLINE caiqidb2 STABLE
--------------------------------------------------------------------------------3 参考文章
https://blog.csdn.net/irewyz/article/details/78746258
https://oracleblog.org/working-case/unsupport-ora-resource-by-crsctl-after-12-1-0-2/
ASM Disk Group Targets Showing INTERMEDIATE State (文档 ID 2337932.1)
