About Me.

My self Adinarayana working as Implementation Application DBA with advanced technologies like RAC/PCP,OID/SSO,DMZ,Exadata and Fusion Middleware i.e Demantra,Application Server,SOA,FMW,BPEL and UPK. Created this blog to share the useful information related to DBA and Application DBA Your comments and suggestions are most welcome. Disclaimer: Please note all the views and opinions expressed in this site are my own. It's not recommend to use the fixes/suggestions provided in this site directly in production instance, please test them before implementing.

Tuesday, July 23, 2013

crs_stat commands in Oracle RAC

CRS_STAT:     -- deprecated in Oracle Clusterware 11g release 2
crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_node]
crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_node]
crs_stat -p [resource_name [...]] [-q]
crs_stat [-a] resource_name -g
crs_stat [-a] resource_name -r [-c cluster_node]
crs_stat -f [resource_name [...]] [-q] [-c cluster_node]
crs_stat -ls resource_name

crs_stat or crs_stat -u or crs_stat -l
crs_stat -t -- tabular format
crs_stat -v -- verbose
crs_stat -p -- more details
AUTO_START = 0 restore
  = 1 always restart
  = 2 never restart
RESTART_ATTEMPTS = n -- How many times Clusterware should attempt to start the resource?

crs_stat -ls
crs_stat -t/v/p resource_name or crs_stat -t/v/p|grep keyword -- will show the entries with that keyword
crs_stat -p lnx02
crs_stat -v | grep eg6245

crs_stat -p resource_name > filename.cap -- generate resource profile file

This crs_stat command was replaced with crsctl command (options).

No comments:

Post a Comment