http://www.cndba.cn/dave/article/138http://www.cndba.cn/dave/article/138

在High 冗余的ASM 磁盘组中，http://www.cndba.cn/dave/article/138

[grid@cndba.cn ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB   Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  HIGH    Y         512   4096  1048576  18874368  17438674          4194304         4414790              5             N  DATA/
MOUNTED  NORMAL  N         512   4096  1048576     30720     21574            10240            5667              0             Y  OCR/
[grid@cndba.cn ~]$

 http://www.cndba.cn/dave/article/138

如果挂掉2个failgroup，在单独添加一个failgroup的时候会报如下错误：http://www.cndba.cn/dave/article/138

SQL> alter diskgroup DATA add
FAILGROUP FG2 DISK '/dev/mapper/node3_disk1' force
FAILGROUP FG2 DISK '/dev/mapper/node3_disk2' force
FAILGROUP FG2 DISK '/dev/mapper/node3_disk3' force;  2    3    4  
alter diskgroup DATA add
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15291: ASM could not add disk "DATA_0003" to disk group "DATA"
SQL> select group_number,MODE_STATUS,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;
GROUP_NUMBER MODE_ST DISK_NUMBER   TOTAL_MB NAME               FAILGROUP       PATH
------------ ------- ----------- ---------- ------------------------------ --------------- ------------------------------
       0 ONLINE           4      0                           /dev/mapper/node3_disk2
       0 ONLINE           3      0                           /dev/mapper/node3_disk3
       0 ONLINE           2      0                           /dev/mapper/node2_disk3
       0 ONLINE           0      0                           /dev/mapper/node2_disk1
       0 ONLINE           1      0                           /dev/mapper/node3_disk1
       0 ONLINE           5      0                           /dev/mapper/node2_disk2
       1 OFFLINE           0    2097152 _DROPPED_0000_DATA           FG3
       1 OFFLINE           1    2097152 _DROPPED_0001_DATA           FG3
       1 OFFLINE           2    2097152 _DROPPED_0002_DATA           FG3
       1 OFFLINE           9      0 _DROPPED_0009_DATA           FG2
       1 ONLINE           8    2097152 DATA_0008               FG1           /dev/mapper/node1_disk3
GROUP_NUMBER MODE_ST DISK_NUMBER   TOTAL_MB NAME               FAILGROUP       PATH
------------ ------- ----------- ---------- ------------------------------ --------------- ------------------------------
       1 OFFLINE          10      0 _DROPPED_0010_DATA           FG2
       1 ONLINE           7    2097152 DATA_0007               FG1           /dev/mapper/node1_disk2
       1 ONLINE           6    2097152 DATA_0006               FG1           /dev/mapper/node1_disk1
       2 ONLINE           0      10240 OCR_0000               OCR_0000       /dev/mapper/node1_ocr
       2 ONLINE           1      10240 OCR_0001               OCR_0001       /dev/mapper/node3_ocr
       2 ONLINE           3      10240 OCR_0003               OCR_0003       /dev/mapper/node2_ocr
17 rows selected.

http://www.cndba.cn/dave/article/138

该错误的解决方法就是同时添加2个failgroup，不能每次添加一个：

SQL> alter diskgroup DATA add
FAILGROUP FG3 DISK '/dev/mapper/node3_disk1' force
FAILGROUP FG3 DISK '/dev/mapper/node3_disk2' force
FAILGROUP FG3 DISK '/dev/mapper/node3_disk3' force
FAILGROUP FG2 DISK '/dev/mapper/node2_disk1' 
FAILGROUP FG2 DISK '/dev/mapper/node2_disk2' 
FAILGROUP FG2 DISK '/dev/mapper/node2_disk3';  2    3    4    5    6    7  
Diskgroup altered.
SQL> select group_number,MODE_STATUS,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;
GROUP_NUMBER MODE_ST DISK_NUMBER   TOTAL_MB NAME               FAILGROUP       PATH
------------ ------- ----------- ---------- ------------------------------ --------------- ------------------------------
       1 OFFLINE          10      0 _DROPPED_0010_DATA           FG2
       1 ONLINE           7    2097152 DATA_0007               FG1           /dev/mapper/node1_disk2
       1 OFFLINE           2    2097152 _DROPPED_0002_DATA           FG3
       1 OFFLINE           9      0 _DROPPED_0009_DATA           FG2
       1 OFFLINE           0    2097152 _DROPPED_0000_DATA           FG3
       1 ONLINE          13    2097152 DATA_0013               FG2           /dev/mapper/node2_disk3
       1 ONLINE           6    2097152 DATA_0006               FG1           /dev/mapper/node1_disk1
       1 ONLINE          12    2097152 DATA_0012               FG2           /dev/mapper/node2_disk2
       1 ONLINE           8    2097152 DATA_0008               FG1           /dev/mapper/node1_disk3
       1 OFFLINE           1    2097152 _DROPPED_0001_DATA           FG3
       1 ONLINE           4    2097152 DATA_0004               FG3           /dev/mapper/node3_disk2
GROUP_NUMBER MODE_ST DISK_NUMBER   TOTAL_MB NAME               FAILGROUP       PATH
------------ ------- ----------- ---------- ------------------------------ --------------- ------------------------------
       1 ONLINE           5    2097152 DATA_0005               FG3           /dev/mapper/node3_disk3
       1 ONLINE           3    2097152 DATA_0003               FG3           /dev/mapper/node3_disk1
       1 ONLINE          11    2097152 DATA_0011               FG2           /dev/mapper/node2_disk1
       2 ONLINE           0      10240 OCR_0000               OCR_0000       /dev/mapper/node1_ocr
       2 ONLINE           1      10240 OCR_0001               OCR_0001       /dev/mapper/node3_ocr
       2 ONLINE           3      10240 OCR_0003               OCR_0003       /dev/mapper/node2_ocr

http://www.cndba.cn/dave/article/138

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 故障处理