I have created long time back one ASM RAC setup and I created one diskgroup with some name say xyz
. I think that instance is gone but the diskgroup was not dropped exclusively using command:
drop diskgroup xyz including contents;
Now that I have created a new setup and want to re utilize these disks, I am getting below error:
CREATE DISKGROUP XYZ EXTERNAL REDUNDANCY DISK ...
ORA-15003: diskgroup "xyz" already mounted in another lock name space
How can this diskgroup be removed? Any help is appreciated.
-
1Are you still interested?Ste– Ste2013年05月28日 18:37:57 +00:00Commented May 28, 2013 at 18:37
-
Why can't you drop it now?Andrew Brennan– Andrew Brennan2014年03月21日 14:52:54 +00:00Commented Mar 21, 2014 at 14:52
1 Answer 1
Check the diskgroup
status in both instances. If it is showing mounted in both instances then:
dismount
the diskgroup in all the instance except one. For instance, if you have a 3 node RAC setup, then dismount the diskgroup in nodes 2 and 3.Drop
the diskgroup from the 1st node.