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