We have ASM installed and are using EMC San for storage. We had a hardware panic and 3 (these were part of the failover group) of the 6 disks available went offline but reappeared as blank group name:
Code:
PATH NAME STATE
------------------------------ ------------------------------ --------
/dev/raw/raw6 NORMAL
/dev/raw/raw5 NORMAL
/dev/raw/raw4 NORMAL
DGGROUP_0005 FORCING
DGGROUP_0004 FORCING
DGGROUP_0003 FORCING
/dev/raw/raw3 DGGROUP_0002 NORMAL
/dev/raw/raw2 DGGROUP_0001 NORMAL
/dev/raw/raw1 DGGROUP_0000 NORMAL
As can from above, raw6,5,4 now appear with no name but are online, the blanks are all offline. I did a alter diskgroup check all and this did not throw up any errors. Now how do i get the raw6,5,4 to be part of a failover group?
Code:
SQL> select failgroup, name from v$asm_disk;
FAILGROUP NAME
------------------------------ ------------------------------
DGGROUP_0005
DGGROUP_0004
DGGROUP_0003
PRIMARY DGGROUP_0002
PRIMARY DGGROUP_0001
PRIMARY DGGROUP_0000
Also does this mean the even though these disks are not part of the failure group, normal redundancy is still availabe as all 6 are still online? Any help will be greatly appreciated
Thanks for that. My SA did mention that the disks have 'multiple' paths, not sure if thats of any relevance. What happens if the device id is different?
Right, but in terms of Oracle ASM does this mean that we dont have redundacy. It looks as if 6 disks are online as per the output above which leads me to believe the redundancy is there albiet in an unconvential manner?
Thanks for that, I got not get ASMLib to work. ASM could not discover the disks available for some reason, hence that is why i went down the raw device route. But the ouput of device names do you mean config of the /etc/sysconfig/rawdevices file?
In /etc/sysconfig/rawdevices, I bound the devices as follows:
SQL> select HEADER_STATUS,MODE_STATUS,STATE,LABEL from v$asm_disk;
HEADER_STATU MODE_ST STATE LABEL
------------ ------- -------- -------------------------------
MEMBER ONLINE NORMAL
MEMBER ONLINE NORMAL
MEMBER ONLINE NORMAL
CANDIDATE OFFLINE FORCING
CANDIDATE OFFLINE FORCING
CANDIDATE OFFLINE FORCING
MEMBER ONLINE NORMAL
MEMBER ONLINE NORMAL
MEMBER ONLINE NORMAL
9 rows selected
Bookmarks