Simulate I/O errors for ASM diskgroups

Put a SATA disk OFFLINE

# echo offline > /sys/block/sdj/device/state
--> After some time the DG isn't mounted on Instance 1 
[grid@grac41 ~]$  asmcmd lsdg FRA2 -g
Inst_ID  State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
      3  MOUNTED  EXTERN  N         512   4096  1048576     40952    31413                0           31413              0             N  FRA2/
      2  MOUNTED  EXTERN  N         512   4096  1048576     40952    31413                0           31413              0             N  FRA2/

Trying to mount the DG fails as we have EXTERNAL reduncany
SQL> alter diskgroup FRA2 mount;
alter diskgroup FRA2 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "2"

SQL> alter diskgroup FRA2 mount force;
alter diskgroup FRA2 mount force
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "2"

Put SATA disk ONLINE again and mount DG
[root@grac41 ~]# echo running > /sys/block/sdj/device/state
[root@grac41 ~]# cat /sys/block/sdj/device/state
running

SQL>  alter diskgroup FRA2 mount;
Diskgroup altered.

[grid@grac41 ~]$  asmcmd lsdg FRA2 -g
Inst_ID  State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
      2  MOUNTED  EXTERN  N         512   4096  1048576     40952    31413                0           31413              0             N  FRA2/
      3  MOUNTED  EXTERN  N         512   4096  1048576     40952    31413                0           31413              0             N  FRA2/
      1  MOUNTED  EXTERN  N         512   4096  1048576     40952    31413                0           31413              0             N  FRA2/

Leave a Reply

Your email address will not be published. Required fields are marked *