ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle10gRAC crs_stat 工具用法

Oracle10gRAC crs_stat 工具用法

原创 Linux操作系统 作者:paulyibinyi 时间:2008-11-05 21:16:37 0 删除 编辑

Oracle10gRAC提供一个工具crs_stat可以用以查看RAC中各资源状态,该工具主要的常用用法如下:


1.通过-h参数可以得到系统提示

bash-2.05$ crs_stat -h
Usage: crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_member]
crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_member]
crs_stat -p [resource_name [...]] [-q]
crs_stat [-a] application -g
crs_stat [-a] application -r [-c cluster_member]
crs_stat -f [resource_name [...]] [-q] [-c cluster_member]
crs_stat -ls [resource_name [...]] [-q]

2.通过crs_stat -t 查看各种资源的状态

  

datadb1#[/]crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    datadb1    
ora....db1.gsd application    ONLINE    ONLINE    datadb1    
ora....db1.ons application    ONLINE    ONLINE    datadb1    
ora....db1.vip application    ONLINE    ONLINE    datadb1    
ora....B2.lsnr application    ONLINE    ONLINE    datadb2    
ora....db2.gsd application    ONLINE    ONLINE    datadb2    
ora....db2.ons application    ONLINE    ONLINE    datadb2    
ora....db2.vip application    ONLINE    ONLINE    datadb2    
ora.gzdcdb.db  application    ONLINE    ONLINE    datadb1    
ora....c1.inst application    ONLINE    ONLINE    datadb1    
ora....c2.inst application    ONLINE    ONLINE    datadb2    
ora....dcdb.cs application    ONLINE    ONLINE    datadb2    
ora....dc1.srv application    ONLINE    ONLINE    datadb1    
ora....dc2.srv application    ONLINE    ONLINE    datadb2

  

3.通过ls命令查看RAC中各资源

bash-2.05$ crs_stat -ls
Name Owner Primary PrivGrp Permission
-----------------------------------------------------------------
ora....C1.lsnr oracle dba rwxrwxr--
ora....ac1.gsd oracle dba rwxr-xr--
ora....ac1.ons oracle dba rwxr-xr--
ora....ac1.vip root dba rwxr-xr--
ora....C2.lsnr oracle dba rwxrwxr--
ora....ac2.gsd oracle dba rwxr-xr--
ora....ac2.ons oracle dba rwxr-xr--
ora....ac2.vip root dba rwxr-xr--
ora.eygle.db oracle dba rwxrwxr--
ora....ygle.cs oracle dba rwxrwxr--
ora....le1.srv oracle dba rwxrwxr--
ora....le2.srv oracle dba rwxrwxr--
ora....e1.inst oracle dba rwxrwxr--
ora....e2.inst oracle dba rwxrwxr--

3.直接使用crs_stat工具列出所有资源的具体信息
bash-2.05$ crs_stat

NAME=ora.db210-rac1.LISTENER_DB210-RAC1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac1

NAME=ora.db210-rac1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac1

NAME=ora.db210-rac1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac1

NAME=ora.db210-rac1.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac1

NAME=ora.db210-rac2.LISTENER_DB210-RAC2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac2

NAME=ora.db210-rac2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac2

NAME=ora.db210-rac2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac2

NAME=ora.db210-rac2.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac2

NAME=ora.eygle.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac1

NAME=ora.eygle.eygle.cs
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.eygle.eygle.eygle1.srv
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.eygle.eygle.eygle2.srv
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.eygle.eygle1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac1

NAME=ora.eygle.eygle2.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db210-rac2

4.查看具体资源的状态

bash-2.05$ crs_stat -p ora.db210-rac2.vip
NAME=ora.db210-rac2.vip
TYPE=application
ACTION_SCRIPT=/opt/oracle/product/10.2.0/Crs10g/bin/racgwrap
ACTIVE_PLACEMENT=1
AUTO_START=1
CHECK_INTERVAL=60
DESCRIPTION=CRS application for VIP on a node
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=db210-rac2
OPTIONAL_RESOURCES=
PLACEMENT=favored
REQUIRED_RESOURCES=
RESTART_ATTEMPTS=0
SCRIPT_TIMEOUT=60
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=bge0
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=255.255.255.0
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=172.16.19.21

 

 

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

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

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6565572