Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why cluster resources shows 3 times (2 online and 1 offline) for 2 node RAC cluster

user12263161Aug 5 2023

We have 2 node RAC cluster 19c DB on KVM. When we run crsctl status resource -t the asm disk groups show 3 time , 1 for each of the nodes and remaining one offline. Not sure what is causing this.

Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE dbs01 STABLE
ONLINE ONLINE dbs02 STABLE
ora.chad
ONLINE ONLINE dbs01 STABLE
ONLINE ONLINE dbs02 STABLE
ora.net1.network
ONLINE ONLINE dbs01 STABLE
ONLINE ONLINE dbs02 STABLE
ora.ons
ONLINE ONLINE dbs01 STABLE
ONLINE ONLINE dbs02 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ARCHDG!.dg(ora.asmgroup)
1 ONLINE ONLINE prddbs01 STABLE
2 ONLINE ONLINE prddbs02 STABLE
3 OFFLINE OFFLINE STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE prddbs01 STABLE
2 ONLINE ONLINE prddbs02 STABLE
3 ONLINE OFFLINE STABLE
ora.CONTROL01DG.dg(ora.asmgroup)
1 ONLINE ONLINE prddbs01 STABLE
2 ONLINE ONLINE prddbs02 STABLE
3 OFFLINE OFFLINE STABLE

The behaviour is same for all other ASM disks as well.

This post has been answered by user12263161 on Aug 5 2023
Jump to Answer
Comments
Post Details
Added on Aug 5 2023
1 comment
1,560 views