ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 11gR2 RAC crsctl 命令的增强

oracle 11gR2 RAC crsctl 命令的增强

原创 Linux操作系统 作者:paulyibinyi 时间:2010-03-04 22:01:56 0 删除 编辑

       安装完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博客 ” ,链接:https://blog.itpub.net/7199859/viewspace-628644/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    907
  • 访问量
    6894410