Re: Removing a diskgroup from a corrupt ASM database
Date: Sat, 23 May 2009 16:28:13 -0700 (PDT)
On May 22, 2:53 pm, daniel.oster..._at_visaer.com wrote:
> I had a disk failure so that the databases (ASM and actual database)
> cannot see the disks. Therefore the diskgroup DATA is unmounted and
> cannot be remounted.
> I'm ready to start over from scratch, I dropped the non-ASM database,
> but still have an ASM database that knows about an unmounted
> diskgroup. But I cannot drop it because it is unmounted and I cannot
> mount it because it is corrupt.
> What do I do to free up this ASM instance to create a new diskgroup?
> I'd even drop the entire ASM database but I cannot delete it via
> DBCA. Short of uninstalling Oracle and reinstalling and creating
> everything new, what can I do?
Hey Daniel I received an email failure trying to reply back to the email you sent me. So here's a second attempt here.
John, I've long since tried the commands you suggested. I've read the doc exhaustively. I've searched the web. The posting on the newsgroup was a next step down the line, thank you.
My ( attempted reply ):
As part of DR testing and validating that we can recover from anything ASM related the CREATE DISKGROUP ... FORCE has worked well for us.
It doesn't matter if the diskgroup is can be mounted or fails during a mount attempt ... it destroys anything ASM related on the disks and reinitializes them. This may be an 11g only thing so you might need to upgrade the ASM to 11g before FORCE become s a valid option in ASM create diskgroup. Received on Sat May 23 2009 - 18:28:13 CDT