学无止境
分类: Oracle
2013-12-06 14:33:07
配置ASM失败组,至少要有2个的裸设备,最好2个裸设备分别在不同存储磁盘上
可以用dbca,创建ASM磁盘组时配置,也可以之后在asm实例中配置。
如果要创建冗余,使用failure group,需要至少选2个裸设备
在ASM实例中查看:
select GROUP_NUMBER,DISK_NUMBER,INCARNATION,MOUNT_STATUS,HEADER_STATUS,STATE,REDUNDANCY,TOTAL_MB,FREE_MB,NAME,FAILGROUP from v$asm_disk;
GROUP_NUMBER DISK_NUMBER INCARNATION MOUNT_S HEADER_STATU STATE REDUNDA TOTAL_MB FREE_MB NAME FAILGROUP
------------ ----------- ----------- ------- ------------ -------- ------- ---------- ---------- --------------- ---------------
0 0 0 CLOSED FOREIGN NORMAL UNKNOWN 290 0
0 2 0 CLOSED FOREIGN NORMAL UNKNOWN 290 0
0 4 0 CLOSED CANDIDATE NORMAL UNKNOWN 5114 0
1 1 2526591960 CACHED MEMBER NORMAL UNKNOWN 7601 7508 DATA_0001 FG1
1 0 2526591961 CACHED MEMBER NORMAL UNKNOWN 4094 4001 DATA_0000 FG2