Oracle ASM failgroup confused....
646155Sep 18 2010 — edited Sep 19 2010hello,
iam pretty much confused with the fail groups here. see i have three 4 disks configured for asM
/dev/sdc1
/dev/sdd1
/dev/sde1
/dev/sdf1
i create a asm diskgroup using two disks with normal redundancy as follows:
create diskgroup asdf nomal redundancy
failgroup fail1 DISK
'/dev/sdc1' name disk01
failgroup fail2 DISK
'/dev/sdd1' name disk02
attribute 'au_size'='4M','compatible.asm'='11.1','compatible.rdbms'='11.1';
sorry for not including this statement before...
alter diskgroup asdf add disk '/dev/sdd1';
after creating the diskgroup the views the shows the information as
select name,group_number,total_mb from V$ASM_DISKGROUP;
NAME GROUP_NUMBER TOTAL_MB
------------------------------ ------------ ----------
ASDF 1 12276
select group_number,disk_number from v$asm_disk;
GROUP_NUMBER DISK_NUMBER
------------ -----------
0 3
0 4
1 0
1 1
1 2
can any one please explain what is going on here... what is the group with group number 0
and as far as the oracle documentation is considered if we dont specify the failgroup during the datagroup creation time then each disk we specify in the CREATE DISKGROUP STATEMENT will be assigned one fail group.. if it is this case then how are the data being distributed and is the existing data in the diskgroup evenly distributed amoung all the disks in the diskgroup...
help please....
Edited by: vishnusivathej on Sep 18, 2010 7:35 PM