Re: ASM Disgroup Mount

From: Mladen Gogala <>
Date: Mon, 09 Feb 2015 14:56:17 -0500
Message-ID: <>

On 02/09/2015 09:54 AM, Sanjay Mishra (Redacted sender for DMARC) wrote:
> Getting issue on AIX diskgroup
> ORA-15032: not all alterations performed
> ORA-15040: diskgroup is incomplete
> ORA-15042: ASM disk "2" is missing from group number "3"
> Checked Disk_number 2 is corresponding to /dev/rhdisk23 and also
> v$asm_disk is showing it with Header_status MEMBER.
> Issue started when someone by mistake added wrong OCR disk into the
> DATADG and cause the crash. Wrong disk was removed at that time along
> with one more disk 2 but after date OCR was restored from backup, it
> look like Oracle might be reading Disk from some OCR metadata or
> somewhere and looking for Disk 2.
> As this is 30Tb Diskgroup and so want to bring the Diskgroup up with
> removing any disk and then recover the database instead of restoing
> 30T which will take days.
> Permission on the Disks are correct on all nodes along with Owner.
> Environment also has 6 more diskgroup and all of them are up and has
> corresponding database running.
> So need to know as what other steps that can be done to bring
> diskgroup up with even removing this affected diskgroup. Is this
> information about the disk are stored in any other place like OCR and
> as OCR is restore where disk 2 was removed earlier before the restored
> OCR back is issue
> Sanjay

Hopefully, you have a standby database? Running 30 TB database without a standby would be irresponsible. If so, fail over to standby, that's why it's there, restore the database and recover it. This is where SAN snapshots can be very handy indeed.

Mladen Gogala
Oracle DBA

Received on Mon Feb 09 2015 - 20:56:17 CET

Original text of this message