So we see that :
a) The Cluster consists of two nodes node1 and node2
b) There are 4 ASM DiskGroups DATA, DATA1, DATA2 and FRA
c) GSD is offline as expected -- it is required only for 9i Databases
d) There is a database racdb and a service new_svc (see my previous post)

So we see that :
a) There are 2 votedisk copies (yes, two -- not the recommended three !)
b) Both are on filesystem
How do I happen to have 2 votedisk copies ? I actually had 3 but removed one. DON'T TRY THIS ON YOUR PRODUCTION CLUSTER. I am adding the third one back now :

4 comments:

Anonymous
said...

Hi Hemanth, nice to see ur your blog as always, how do you manage time to blog besides your busy schedule? Meantime I have a question, our IT support guy pulled the cables from our SAN storage of live database (non RAC), i shutdown the server and brought it up just to realize that datafiles gone to recover mode. Then I ran alter database recover database; from RMAN, is it right step or should have just brought the datafile online? though the database is OK now.

hi hemanth, nice to see u blog besides ur busy schedule, how do u manage ur time? I have a question, when my support guy pulled the cables of SAN storage of live database(non RAC), I had to restart the server just to realize many datafiles gone to recover mode. In panic I simply run alter database recover from RMAN. is this the right step or I should have just brought the datafiles online. please suggest.

Hi Hemanth, nice to see ur blog as always, here is a question, when my IT support guy accidentally pulled the cables of SAN storage of live database(non RAC), i had to restart the server to realize that many of datafiles are in recovery mode. I ran 'alter database recover from RMAN and started the server. all is OK now, is it OK to do so, or is there any better way. I should have run recover datafile instead of recover database (or) should have tried command just to bring the datafile online without recovery. pls suggest me.