Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Need help with ASM disk/diskgroup ghost
Hello,
I am hoping for a quick answer to this question, as Oracle would (rightly so) put it as a sev 3 or 4.
Our ASM disks seem to have gotten out of wack (technical term). We have been running with two disk groups for months. We need to add an additional disk to the primary disk group. We had our system administrator add the disk to each node and get it set up for ASM use.
I tried to add the disk via GRID. It showd as "Member", but not a
member of any group.
I chose it and clicked OK and received the error:
Failed to commit: ORA-15032: not all alterations performed ORA-15033:
disk '/dev/raw/ASM7' belongs to diskgroup "EUDATA_01"
This was news to me, as we should not have a disk group EUDATA_01.
I looked in v$asm_diskgroup and found a new disk group. Further more, it is listed as group zero! I thought the numbers were sequential and climbing.
The ASM alert logs don't show anything until the alter to add the disk
to the correct disk group.
At that point, they show my attempts to mount/drop the "new" disk
group.
At this point, I can't drop the disk or disk group. I can't add it where it needs to be.
Questions:
1) How can I get rid of an un-mountable disk group? 2) How do I pry loose the disk I need to apply to DATA_02? 3) Why don't I see anything in the ASM alert logs?
My versions and such:
I am running a 2 node RAC with ASM. Everything from CRS to the
database is 10.2.0.2. Compatibility was set by a different DBA, so I
don't know why it isn't 10202.
The new disk is /dev/raw/ASM7. The bad disk group is EUDATA_01.
Thanks!
V$ASM_DISKGROUP
GRP NAME STATE TYPE TOTAL_MB USABLE_FILE_MB
OFFLINE_DISKS COMPATIBIL Compatibilit
---- --------- ----------- ------ ---------- --------------
------------- ---------- ------------
1 DATA_02 MOUNTED EXTERN 345220 5840 0 10.1.0.0.0 10.1.0.0.0 2 FRA_01 MOUNTED EXTERN 69044 65565 0 10.1.0.0.0 10.1.0.0.0 0 EUDATA_01 DISMOUNTED 0 0 0 0.0.0.0.0 0.0.0.0.0
V$ASM_DISK
GRP DskNum MOUNT_S HeaderStat MODE_ST STATE REDUNDA TOT_MB FREE_MB
NAME FAILGROUP PATH MOUNT_DAT
--- ------ ------- ---------- ------- ------ ------- -------- -------
------------ ------------ ------------- ---------
0 1 CLOSED MEMBER ONLINE NORMAL UNKNOWN 69,044 0 /dev/raw/ASM7 30-MAR-06 1 0 CACHED MEMBER ONLINE NORMAL UNKNOWN 69,044 1,105 DATA_02_0000 DATA_02_0000 /dev/raw/ASM1 17-JAN-06 1 1 CACHED MEMBER ONLINE NORMAL UNKNOWN 69,044 1,150 DATA_02_0001 DATA_02_0001 /dev/raw/ASM2 17-JAN-06 1 2 CACHED MEMBER ONLINE NORMAL UNKNOWN 69,044 1,331 DATA_02_0002 DATA_02_0002 /dev/raw/ASM3 17-JAN-06 1 3 CACHED MEMBER ONLINE NORMAL UNKNOWN 69,044 1,204 DATA_02_0003 DATA_02_0003 /dev/raw/ASM4 17-JAN-06 1 4 CACHED MEMBER ONLINE NORMAL UNKNOWN 69,044 1,050 DATA_02_0004 DATA_02_0004 /dev/raw/ASM5 17-JAN-06 2 1 CACHED MEMBER ONLINE NORMAL UNKNOWN 69,044 65,565FRA_01_0001 FRA_01_0001 /dev/raw/ASM6 28-JUL-05 Received on Tue Oct 09 2007 - 14:32:09 CDT