天天看點

RAC維護基本指令

[[email protected] ~]$ olsnodes -i  /*顯示每個節點的vip
juliaz2    juliaz2-vip
juliaz3    juliaz3-vip
[[email protected] ~]$ olsnodes -n /*顯示每個節點在rac中的編号
juliaz2    1
juliaz3    2
[[email protected] ~]$ olsnodes -s /*顯示每個節點狀态
juliaz2    Active
juliaz3    Active
[[email protected] ~]$ olsnodes -l -p /*顯示local節點的私有ip位址
juliaz2    192.168.1.22
[[email protected] ~]$ olsnodes -c   /*rac cluster的名字
juliaz-cluster

           

檢視ORC叢集中的節點及狀态,這個指令位于grid infrastrcture 軟體安裝目錄下的bin子目錄,root帳号或者軟體安裝者都可以執行這個指令。

clusterware中的相關服務啟動起來之後,vip 和scan将自動産生,并且綁定在每個公共網卡上。

clusterware中的服務的程序

crs  /crsd   /*基于OCR對叢集中的資源進行管理。

css /ocssd / cssdagent  /*控制叢集中每個節點的成員資格 ,ocssdagent啟動和關閉ocssd程序,并監視這個程序的狀态,當ocssd程序停止運作時,csssdagent負責關閉整個節點

ctss/ctssd   /*負責不同節點之間的時間同步

evm/evmd  /*當crs服務服務産生事件時,負責對事件進行處理

ohas /ohasd /*負責啟動clusterware中的程序,這個程序以root使用者,随系統啟動而啟動的。

clusterware 提供了一系列指令,這些指令都位于grid infrastrucure軟體安裝目錄bin子目錄中,用root或軟體安裝者都可以執行。

crs_stat一個即将被淘汰的指令:

[[email protected] ~]$ crs_stat
NAME=ggatevip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.DG1.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.SYSDB.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.eons
TYPE=ora.eons.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.gsd
TYPE=ora.gsd.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.juliaz2.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.juliaz2.LISTENER_JULIAZ2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.juliaz2.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.juliaz2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.juliaz2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.juliaz3.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on juliaz3

NAME=ora.juliaz3.LISTENER_JULIAZ3.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on juliaz3

NAME=ora.juliaz3.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.juliaz3.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on juliaz3

NAME=ora.juliaz3.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on juliaz3

NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.oc4j
TYPE=ora.oc4j.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.orcl.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.registry.acfs
TYPE=ora.registry.acfs.type
TARGET=ONLINE
STATE=ONLINE on juliaz2

NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on juliaz2
           

指令對比

[[email protected] ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ggatevip       application    ONLINE    ONLINE    juliaz2     
ora.DATA.dg    ora....up.type ONLINE    ONLINE    juliaz2     
ora.DG1.dg     ora....up.type ONLINE    ONLINE    juliaz2     
ora....ER.lsnr ora....er.type ONLINE    ONLINE    juliaz2     
ora....N1.lsnr ora....er.type ONLINE    ONLINE    juliaz2     
ora.SYSDB.dg   ora....up.type ONLINE    ONLINE    juliaz2     
ora.asm        ora.asm.type   ONLINE    ONLINE    juliaz2     
ora.eons       ora.eons.type  ONLINE    ONLINE    juliaz2     
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....SM1.asm application    ONLINE    ONLINE    juliaz2     
ora....Z2.lsnr application    ONLINE    ONLINE    juliaz2     
ora....az2.gsd application    OFFLINE   OFFLINE               
ora....az2.ons application    ONLINE    ONLINE    juliaz2     
ora....az2.vip ora....t1.type ONLINE    ONLINE    juliaz2     
ora....SM2.asm application    ONLINE    ONLINE    juliaz3     
ora....Z3.lsnr application    ONLINE    ONLINE    juliaz3     
ora....az3.gsd application    OFFLINE   OFFLINE               
ora....az3.ons application    ONLINE    ONLINE    juliaz3     
ora....az3.vip ora....t1.type ONLINE    ONLINE    juliaz3     
ora....network ora....rk.type ONLINE    ONLINE    juliaz2     
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   ONLINE    ONLINE    juliaz2     
ora.orcl.db    ora....se.type ONLINE    ONLINE    juliaz2     
ora....ry.acfs ora....fs.type ONLINE    ONLINE    juliaz2     
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    juliaz2     
[[email protected] ~]$ crsctl stat resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
ora.DG1.dg
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
ora.LISTENER.lsnr
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
ora.SYSDB.dg
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
ora.asm
               ONLINE  ONLINE       juliaz2                  Started             
               ONLINE  ONLINE       juliaz3                  Started             
ora.eons
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
ora.gsd
               OFFLINE OFFLINE      juliaz2                                      
               OFFLINE OFFLINE      juliaz3                                      
ora.net1.network
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
ora.ons
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
ora.registry.acfs
               ONLINE  ONLINE       juliaz2                                      
               ONLINE  ONLINE       juliaz3                                      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ggatevip
      1        ONLINE  ONLINE       juliaz2                                      
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       juliaz2                                      
ora.juliaz2.vip
      1        ONLINE  ONLINE       juliaz2                                      
ora.juliaz3.vip
      1        ONLINE  ONLINE       juliaz3                                      
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.orcl.db
      1        ONLINE  ONLINE       juliaz2                  Open                
      2        ONLINE  ONLINE       juliaz3                  Open                
ora.scan1.vip
      1        ONLINE  ONLINE       juliaz2                                      
[[email protected] ~]$ 
           
[[email protected] ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[[email protected] ~]$ 
           

crsctl stop crs  /*該指令隻能stop該節點的cluster。需要在每個節點都執行這個指令,才能全部停下來。

crsctl stop crs [-f]
    Stop OHAS on this server
where
    -f              Force option

  crsctl stop cluster [[-all]|[-n <server>[...]]] [-f]
    Stop CRS stack
where
    Default         Stop local server
    -all            Stop all servers
    -n              Stop named servers
    server [...]    One or more blank-separated server names
    -f              Force option

           

管理voting檔案

http://blog.csdn.net/juliaputao/article/details/8683131

管理ocr檔案

RAC