Subscriber Count

    461

Subscribe to Posts by Email

Pages

Script:- Check the resource dependencies in RAC Cluster

Sometimes You may require to check the dependencies for the resources for example to stop a ASM you will need to find what are the dependent resources in CRS or to change a vip what are the dependent resources associated with it to bring them down and perform your activity like chaning vip etc.

To do that,

 

<div style="overflow:scroll;">
#10g
crs_stat -p | grep -v =$ | perl -nle 'if(/^NAME/){print}elsif(/^REQUIRED_RESOURCES/){print "t$_"}'
#11g
crsctl stat res -p | grep -v =$ | perl -nle 'if(/^NAME/){print}elsif(/DEPENDENCIES/){print "t$_"}'
For example (11g):
$ crsctl stat res -p | grep -v =$ | perl -nle 'if(/^NAME/){print}elsif(/DEPENDENCIES/){print "t$_"}'
NAME=ora.DATA.dg
START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm)
STOP_DEPENDENCIES=hard(intermediate:ora.asm)
NAME=ora.FRA.dg
START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm)
STOP_DEPENDENCIES=hard(intermediate:ora.asm)
</div>

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>