CRS Resource Introduction In Oracle 19c RAC-20220125

導讀：簡述Oracle 19c RAC CRS資源與作用。

1.環境與db版本

環境：oracle 19c rac on three nodes for redhat8.3
db版本：19.9（已應用19.9RU）
SQL> select * from v$version;
BANNER
----------------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY                                                                             CON_ID
---------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

2.CRS資源檢視與資源簡述 

[grid@rac1:/home/grid]$crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
# local listeners資源，從11gr2開始，listener.ora檔案會自動生成，不需要手動修改
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
               ONLINE  ONLINE       rac3                     STABLE
ora.chad
# 12.2新增守護程式，ora.chad是Cluster Health Advisor簡稱CHA，屬於Autonomous Health Framework(自治健康框架)
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
               ONLINE  ONLINE       rac3                     STABLE
ora.net1.network
# 網路資源，管理叢集的public ip，scanvip，vip，listener等資源都依賴於ora.net1.network
# VIP資源依賴於ora.net1.network資源，當ora.net1.network資源發生問題時，可能會造成vip的failover或listener offline
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
               ONLINE  ONLINE       rac3                     STABLE
ora.ons
# 參考：Doc ID 759895.1
# ora.ons是Oracle Notification Service daemon的守護程式，它是nodespps的一部分。
# 透過ons/evmd/racgimon叢集守護程式來完成把FAN/RLB事件通知給application subscribers and the local listeners
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
               ONLINE  ONLINE       rac3                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ARCH.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  ONLINE       rac3                     STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
# 12.1新增flex asm，選擇flex asm需配置oracle asm network，所有節點啟動時自動開啟ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)監聽資源
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  ONLINE       rac3                     STABLE
ora.DATA.dg(ora.asmgroup)
# asm磁碟組資源
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  ONLINE       rac3                     STABLE
ora.LISTENER_SCAN1.lsnr
# 參考：Doc ID 887522.1
# ora.LISTENER_SCAN1.lsnr監聽scan ip，並被配置在remote_listener
# ora.LISTENER_SCAN1.lsnr數量決定於scan name解析的ip，最多3個
      1        ONLINE  ONLINE       rac3                     STABLE
ora.OCR.dg(ora.asmgroup)
# asm磁碟組資源
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  ONLINE       rac3                     STABLE
ora.asm(ora.asmgroup)
# flex asm，asm例項資源
      1        ONLINE  ONLINE       rac1                     Started,STABLE
      2        ONLINE  ONLINE       rac2                     Started,STABLE
      3        ONLINE  ONLINE       rac3                     Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
# flex asm，所有節點啟動時自動開啟ora.asmnet1.asmnetwork資源（此網路資源可於私有網路共享），為所有節點asm 監聽資源提供服務
      1        ONLINE  ONLINE       rac1                     STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  ONLINE       rac3                     STABLE
ora.cvu
# 參考：Doc ID 1524235.1
# 11.2.0.2 gi引入的新資源，目的是定期呼叫cvu資源進行叢集健康檢查
      1        ONLINE  ONLINE       rac3                     STABLE
ora.qosmserver
# Memory Guard依賴ora.qosmserver資源實現高可用
# Memory Guard作用透過防止節點因記憶體不足受到壓力時被驅逐，持續監控並確保叢集節點的可用性。
      1        ONLINE  ONLINE       rac3                     STABLE
ora.rac1.vip
# 節點對應的VIP資源，ora.rac1.vip是ora.LISTENER.lsnr依賴的資源
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.rac3.vip
      1        ONLINE  ONLINE       rac3                     STABLE
ora.racdb.db
      1        ONLINE  ONLINE       rac1                     Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
      2        ONLINE  ONLINE       rac2                     Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
      3        ONLINE  ONLINE       rac3                     Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
ora.scan1.vip
# 參考：Doc ID 887522.1
# scan1.vip是LISTENER_SCAN1.lsnr依賴的資源
# scan1.vip數量決定於scan name解析的ip，最多3個
      1        ONLINE  ONLINE       rac3                     STABLE
--------------------------------------------------------------------------------

3.文獻參考

https://blogs.oracle.com/database4cn/post/11gr2-gi