{ASMディスクグループ}優先読取りの障害グループを設定

 

https://docs.oracle.com/cd/F19136_01/ostmg/mirroring-diskgroup-redundancy.html#GUID-C0EF42F0-4C35-4ACA-AF10-FA98A952B244

select * from v$asm_diskgroup order by group_number;

select group_number,disk_number,name,label,
    HEADER_STATUS,TOTAL_MB,failgroup,path, OS_MB
from v$asm_disk order by group_number,disk_number;

show parameter ASM_PREFERRED_READ_FAILURE_GROUPS

alter system set ASM_PREFERRED_READ_FAILURE_GROUPS='test2.controller1' scope=spfile sid='+ASM1';
alter system set ASM_PREFERRED_READ_FAILURE_GROUPS='test2.controller2' scope=spfile sid='+ASM2';

crsctl stop crs
crsctl start crs -wait

su - grid
export ORACLE_SID=+ASM1
sqlplus / as sysasm
set lines 1000
set pages 5000
show parameter ASM_PREFERRED_READ_FAILURE_GROUPS