oracle 11gR2 RAC crsctl 命令的增強

paulyibinyi發表於2010-03-04

       安裝完11gR2 rac後,在11gR2版本中用crsctl status resource -t 命令可以很詳細的看到各個資源組狀態

[grid@p520:/grid/app/grid]$crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGDATA1.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGRECOVER.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGSYSTEM.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.LISTENER.lsnr
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.asm
               ONLINE  ONLINE       p520                     Started            
               ONLINE  ONLINE       p650                     Started            
ora.eons
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.gsd
               OFFLINE OFFLINE      p520                                        
               OFFLINE OFFLINE      p650                                        
ora.net1.network
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.ons
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       p650                                        
ora.oc4j
      1        ONLINE  ONLINE       p650                                        
ora.orcl.db
      1        ONLINE  ONLINE       p520                     Open               
      2        ONLINE  ONLINE       p650                     Open               
ora.p520.vip
      1        ONLINE  ONLINE       p520                                        
ora.p650.vip
      1        ONLINE  ONLINE       p650                                        
ora.scan1.vip
      1        ONLINE  ONLINE       p650                              

可以仔細看 STATE_DETAILS       一欄 如果資料庫節點2 例項關閉的話,會顯示例項關閉

ora.orcl.db
      1        ONLINE  ONLINE       p520                     Open               
      2        ONLINE  OFFLINE                               Instance Shutdown  

如果vip發生漂移的話,會顯示failed over

ora.p650.vip
      1        ONLINE  INTERMEDIATE p520                     FAILED OVER        

從上面我們命令我們可以很詳細的看到各個資源組的狀態,資料庫例項處於什麼狀態,vip是否發生漂移等

 

   

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-628644/,如需轉載,請註明出處,否則將追究法律責任。

相關文章