asm 添加一个磁盘

whiterain

10g asm里面  normal的dg 有两个磁盘，有一个磁盘在一个存储上，另外在另外一个存储上，一个存储掉电了。一个哥们，在dg里面删除了这个这个磁盘了。现在想添加进去。应该怎么添加呢

whiterain

SQL> select group_number,disk_number,total_mb,free_mb,name,failgroup from v$asm_disk order by group_number,disk_number,failgroup;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB    FREE_MB NAME
------------ ----------- ---------- ---------- ------------------------------
FAILGROUP
------------------------------
           1           0          0          0 DATA_0000
DATA_0000

           1           1    1710985          0 DATA_0001



SQL>

SQL> select group_number,name,type from v$asm_diskgroup;

GROUP_NUMBER NAME                           TYPE
------------ ------------------------------ ------
           1 DATA                           NORMAL

Maclean Liu(刘相兵

你可以使用dd 将asm disk的header清理干净 ，然后直接 alter diskgroup  xxx add failgroup xxx disk xxxx  


After the disk is repaired, it is no longer part of any disk group, but ASM still recognizes that the disk had been a member of a disk group. You must use the FORCE flag to include the disk in a new disk group. In addition, the disk must be addressable, and the original disk group must not be mounted. Otherwise, the operation fails.


也可以 使用FORCE 选项直接添加回去

alter diskgroup  xxx add failgroup xxx disk xxxx    force

whiterain

好的，已经加进去了，谢谢了。

whiterain

disk missing和offline，有啥区别？

Maclean Liu(刘相兵

v$asm_disk的状态信息 解释

MODE_STATUS        VARCHAR2(7)        Global status about which kinds of I/O requests are allowed to the disk:
ONLINE - Disk is online and operating normally. Reads and writes are attempted when the disk is mounted. Reads are attempted as part of disk discovery.
OFFLINE - Disk is offline and access to data is not permitted. Reads and writes are not attempted. An offline disk remains logically part of its disk group.
STATE        VARCHAR2(8)        Global state of the disk with respect to the disk group:
UNKNOWN - Automatic Storage Management disk state is not known (typically the disk is not mounted)
NORMAL - Disk is online and operating normally
ADDING - Disk is being added to a disk group, and is pending validation by all instances that have the disk group mounted
DROPPING - Disk has been manually taken offline and space allocation or data access for the disk halts. Rebalancing will commence to relocate data off the disks to other disks in the disk group. Upon completion of the rebalance, the disk is expelled from the group.
HUNG - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped
FORCING - Disk is being removed from the disk group without attempting to offload its data. The data will be recovered from redundant copies, where possible.
DROPPED - Disk has been fully expelled from the disk grou