ITPub博客

首页 > 数据库 > Oracle > [Oracle] crsctl stat res -t

[Oracle] crsctl stat res -t

原创 Oracle 作者:tolilong 时间:2016-05-25 23:23:48 0 删除 编辑
oracle10g的时候查看resource用 crs_stat -t比较多.
到了oracle11g后查看resource 用 crsctl stat res -t

[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.OCR_VOT.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.ORADATA.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.asm
               ONLINE  ONLINE       xxxxxdb1                 Started             
               ONLINE  ONLINE       xxxxxdb2                                     
ora.eons
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.gsd
               OFFLINE OFFLINE      xxxxxdb1                                     
               OFFLINE OFFLINE      xxxxxdb2                                     
ora.net1.network
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.ons
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       xxxxxdb2                                     
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.scan1.vip
      1        ONLINE  ONLINE       xxxxxdb2                                     
ora.xxxxxdb.db
      1        OFFLINE OFFLINE                                                   
      2        OFFLINE OFFLINE                               Instance Shutdown   
ora.xxxxxdb1.vip
      1        ONLINE  ONLINE       xxxxxdb1                                     
ora.xxxxxdb2.vip
      1        ONLINE  ONLINE       xxxxxdb2                      

其中ora.xxxxxdb.db显示为offline状态,其实用sqlplus 登录两个节点查看instance的状态都为open
这个应该和srvctl config配置有关系。     
      
[root@xxxxxdb2 ~]# srvctl start instance -d xxxxxdb -n xxxxxdb2 -o open      
执行这个命令后xxxxxdb2   的状态为online,并且为open.
      
[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.OCR_VOT.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.ORADATA.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.asm
               ONLINE  ONLINE       xxxxxdb1                 Started             
               ONLINE  ONLINE       xxxxxdb2                                     
ora.eons
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.gsd
               OFFLINE OFFLINE      xxxxxdb1                                     
               OFFLINE OFFLINE      xxxxxdb2                                     
ora.net1.network
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.ons
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       xxxxxdb2                                     
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.scan1.vip
      1        ONLINE  ONLINE       xxxxxdb2                                     
ora.xxxxxdb.db
      1        OFFLINE OFFLINE                                                   
      2        ONLINE  ONLINE       xxxxxdb2                 Open                
ora.xxxxxdb1.vip
      1        ONLINE  ONLINE       xxxxxdb1                                     
ora.xxxxxdb2.vip
      1        ONLINE  ONLINE       xxxxxdb2             



[root@xxxxxdb2 ~]# srvctl start instance -d xxxxxdb -i xxxxxdb1 -o open
执行这个命令后xxxxxdb1   的状态为online,并且为open. 但是查看 xxxxxdb1  的alert log,instance会突然abort,让后重新启动。


[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.OCR_VOT.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.ORADATA.dg
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.asm
               ONLINE  ONLINE       xxxxxdb1                 Started             
               ONLINE  ONLINE       xxxxxdb2                                     
ora.eons
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.gsd
               OFFLINE OFFLINE      xxxxxdb1                                     
               OFFLINE OFFLINE      xxxxxdb2                                     
ora.net1.network
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
ora.ons
               ONLINE  ONLINE       xxxxxdb1                                     
               ONLINE  ONLINE       xxxxxdb2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       xxxxxdb2                                     
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.scan1.vip
      1        ONLINE  ONLINE       xxxxxdb2                                     
ora.xxxxxdb.db
      1        ONLINE  ONLINE       xxxxxdb1                 Open                
      2        ONLINE  ONLINE       xxxxxdb2                 Open                
ora.xxxxxdb1.vip
      1        ONLINE  ONLINE       xxxxxdb1                                     
ora.xxxxxdb2.vip
      1        ONLINE  ONLINE       xxxxxdb2    

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24237320/viewspace-2106995/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-07-13

  • 博文量
    406
  • 访问量
    1208664