Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
1  
Are you still interested? –  Ste May 28 '13 at 18:37
    
Why can't you drop it now? –  Andrew Brennan Mar 21 at 14:52

1 Answer 1

Check the diskgroup status in both instances. If it is showing mounted in both instances then:

  1. 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.
  2. Drop the diskgroup from the 1st node.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.