asm 状态INTERMEDIATE

  1. 云栖社区>
  2. 博客>
  3. 正文

asm 状态INTERMEDIATE

snowofsummer 2018-09-07 20:46:48 浏览1105
展开阅读全文

数据库版本: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)

网友评论

登录后评论
0/500
评论
snowofsummer
+ 关注