Oracle10gRAC crs_stat 工具用法

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

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

[indent]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]
[/indent]
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中各资源
[indent]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--[/indent]
3.直接使用crs_stat工具列出所有资源的具体信息
bash-2.05$ crs_stat
[indent]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
[/indent]
4.查看具体资源的状态
[indent]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
[/indent]