11g check the status of daemons and resource in standby rac

最新推荐文章于 2019-07-02 11:45:14 发布

xinxiangsui2008

最新推荐文章于 2019-07-02 11:45:14 发布

阅读量920

点赞数

分类专栏： ORACLE RAC CRS 文章标签： 11g crs_stat daemons oracle rac resource Resource

本文链接：https://blog.csdn.net/xinxiangsui2008/article/details/8269766

版权

ORACLE RAC CRS 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

11g R2 crsctl路径:root用户下, $ORACLE_HOME/bin/crsctl

#. /home/grid/.profile

$ crsctl stat res -t     --crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
ora.INDEXDG.dg
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
ora.LISTENER.lsnr
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
ora.OCRDG.dg
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
ora.RECOVERYDG.dg
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
ora.asm
               ONLINE ONLINE       proddb1                  Started
               ONLINE ONLINE       proddb2                  Started
ora.gsd
               OFFLINE OFFLINE      proddb1
               OFFLINE OFFLINE      proddb2
ora.net1.network
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
ora.ons
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
ora.registry.acfs
               ONLINE ONLINE       proddb1
               ONLINE ONLINE       proddb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE ONLINE       proddb1
ora.cvu
      1        ONLINE ONLINE       proddb1
ora.oc4j
      1        ONLINE ONLINE       proddb1
ora.prddb.db
      1        ONLINE ONLINE       proddb1                  Open,Readonly
      2        ONLINE ONLINE       proddb2                  Open,Readonly
ora.prddb.expqr.svc
      1        ONLINE ONLINE       proddb1
ora.prddb.ord.svc
      1        ONLINE ONLINE       proddb2
ora.prddb.rpt.svc
      1        ONLINE ONLINE       proddb1
ora.proddb1.vip
      1        ONLINE ONLINE       proddb1
ora.proddb2.vip
      1        ONLINE ONLINE       proddb2
ora.scan1.vip
      1        ONLINE ONLINE       proddb1

$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE ONLINE       proddb2                  Started
ora.cluster_interconnect.haip
      1        ONLINE OFFLINE
ora.crf
      1        ONLINE ONLINE       proddb2
ora.crsd
      1        ONLINE ONLINE       proddb2
ora.cssd
      1        ONLINE ONLINE       proddb2
ora.cssdmonitor
      1        ONLINE ONLINE       proddb2
ora.ctssd
      1        ONLINE ONLINE       proddb2                  OBSERVER
ora.diskmon
      1        OFFLINE OFFLINE
ora.drivers.acfs
      1        ONLINE ONLINE       proddb2
ora.evmd
      1        ONLINE ONLINE       proddb2
ora.gipcd
      1        ONLINE ONLINE       proddb2
ora.gpnpd
      1        ONLINE ONLINE       proddb2
ora.mdnsd
      1        ONLINE ONLINE       proddb2

注意：在以上进程中，ora.diskmon及ora.crf进程的STATE可以为OFFLINE，不影响CRS。

$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATADG.dg ora....up.type ONLINE    ONLINE    proddb1
ora.INDEXDG.dg ora....up.type ONLINE    ONLINE    proddb1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    proddb1
ora....N1.lsnr ora....er.type ONLINE    ONLINE    proddb1
ora.OCRDG.dg   ora....up.type ONLINE    ONLINE    proddb1
ora....RYDG.dg ora....up.type ONLINE    ONLINE    proddb1
ora.asm        ora.asm.type   ONLINE    ONLINE    proddb1
ora.cvu        ora.cvu.type   ONLINE    ONLINE    proddb1
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora....network ora....rk.type ONLINE    ONLINE    proddb1
ora.oc4j       ora.oc4j.type ONLINE    ONLINE    proddb1
ora.ons        ora.ons.type   ONLINE    ONLINE    proddb1
ora.prddb.db   ora....se.type ONLINE    ONLINE    proddb1
ora....pqr.svc ora....ce.type ONLINE    ONLINE    proddb1
ora....ord.svc ora....ce.type ONLINE    ONLINE    proddb2
ora....rpt.svc ora....ce.type ONLINE    ONLINE    proddb1
ora....SM1.asm application    ONLINE    ONLINE    proddb1
ora....B1.lsnr application    ONLINE    ONLINE    proddb1
ora....db1.gsd application    OFFLINE   OFFLINE
ora....db1.ons application    ONLINE    ONLINE    proddb1
ora....db1.vip ora....t1.type ONLINE    ONLINE    proddb1
ora....SM2.asm application    ONLINE    ONLINE    proddb2
ora....B2.lsnr application    ONLINE    ONLINE    proddb2
ora....db2.gsd application    OFFLINE   OFFLINE
ora....db2.ons application    ONLINE    ONLINE    proddb2
ora....db2.vip ora....t1.type ONLINE    ONLINE    proddb2
ora....ry.acfs ora....fs.type ONLINE    ONLINE    proddb1
ora.scan1.vip ora....ip.type ONLINE    ONLINE    proddb1

综上来看，crs_stat与crsctl stat res -t命令查看的资源是一样的,看的都是Oracle集群注册表(OCR)中定义的资源,而这些资源包括Oracle Notification Service(ONS),theGlobal Services Daemon (GSD),and the Virtual IP (VIP),另外还包括databases, instances, listeners, services, and applications的一些资源，即SRVCTL可管理的资源;

crsctl stat res -t -init查看的是Oracle Clusterware守护进程,而这些守护进程包括Cluster Synchronization Service(CSS), Cluster-Ready Service(CRS), and the Event Manager(EVM)。

以上综合参考文章Tools for Installing, Configuring, and Managing Oracle RAC。