Oracle Database Restart Configuration Output
By: Date: April 25, 2020 Categories: Enterprise Computing,Oracle

Not easy to find but the replacement for crs_stat in Oracle 18c/19c is crsctl stat. Apparently this was available as early as 12c when crs_stat was first deprecated.

[oracle@ol7-19c bin]$ crsctl stat res

NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on ol7-19c
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on ol7-19c
…
[oracle@ol7-19c bin]$ crsctl stat res -t

Name Target State Server State details
Local Resources
ora.DATA.dg
ONLINE ONLINE ol7-19c STABLE
ora.LISTENER.lsnr
ONLINE ONLINE ol7-19c STABLE

Here is sample output from a RAC configuration:

oracle@rac01:~$ crsctl stat res
NAME=ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
TYPE=ora.asm_listener.type
TARGET=ONLINE         , ONLINE         , OFFLINE
STATE=ONLINE on rac01, ONLINE on rac02, OFFLINE

NAME=ora.DATA.dg(ora.asmgroup)
TYPE=ora.diskgroup.type
TARGET=ONLINE         , ONLINE         , OFFLINE
STATE=ONLINE on rac01, ONLINE on rac02, OFFLINE

NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE         , ONLINE
STATE=ONLINE on rac01, ONLINE on rac02

NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on rac02

NAME=ora.LISTENER_SCAN2.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on rac01

NAME=ora.LISTENER_SCAN3.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on rac01

NAME=ora.asm(ora.asmgroup)
TYPE=ora.asm.type
TARGET=ONLINE         , ONLINE         , OFFLINE
STATE=ONLINE on rac01, ONLINE on rac02, OFFLINE

NAME=ora.asmnet1.asmnetwork(ora.asmgroup)
TYPE=ora.asm_network.type
TARGET=ONLINE         , ONLINE         , OFFLINE
STATE=ONLINE on rac01, ONLINE on rac02, OFFLINE

NAME=ora.cvu
TYPE=ora.cvu.type
TARGET=ONLINE
STATE=ONLINE on rac01

NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE         , ONLINE
STATE=ONLINE on rac01, ONLINE on rac02

NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE         , ONLINE
STATE=ONLINE on rac01, ONLINE on rac02

NAME=ora.orcl.db
TYPE=ora.database.type
TARGET=ONLINE         , ONLINE
STATE=ONLINE on rac01, ONLINE on rac02

NAME=ora.qosmserver
TYPE=ora.qosmserver.type
TARGET=ONLINE
STATE=ONLINE on rac01

NAME=ora.rac01.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac01

NAME=ora.rac02.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac02

NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac02

NAME=ora.scan2.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac01

NAME=ora.scan3.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac01