ASM Disgroup Mount

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 09 Feb 2015 14:54:09 +0000
Message-ID: <1183813282.2018840.1423493648706.JavaMail.yahoo_at_mail.yahoo.com>

Getting issue on AIX 11.2.0.3 diskgroup

ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "2" is missing from group number "3"

ERROR: ALTER DISKGROUP DATADG MOUNT /* asm agent *//* 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 TIASanjay

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 09 2015 - 15:54:09 CET