ASM磁盘显式offline操作与repair_time测试

ASM磁盘显式offline操作与repair_time测试

1、创建磁盘组repair

SQL> CREATE DISKGROUP repair NORMAL REDUNDANCY  FAILGROUP fg2 DISK '/dev/asm_1g_4' SIZE 1024M  FAILGROUP fg1 DISK '/dev/asm_1g_3' SIZE 1024M  ATTRIBUTE 'compatible.asm'='11.2.0.0.0','compatible.rdbms'='11.2.0.0.0','au_size'='4M'; 

2、修改repair磁盘组的repair_time为1min

alter diskgroup REPAIR set attribute 'disk_repair_time' = '1.0m'; 

3、查看磁盘组状态

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE,REPAIR_TIMER from v$asm_disk order by path;

MOUNT_S HEADER_STATU MODE_ST STATE    NAME            FAILGROUP       PATH          REPAIR_TIMER
------- ------------ ------- -------- --------------- --------------- --------------------------
CACHED  MEMBER       ONLINE  NORMAL   REPAIR_0002     FG1             /dev/asm_1g_3            0
CACHED  MEMBER       ONLINE  NORMAL   REPAIR_0001     FG2             /dev/asm_1g_4            0
CACHED  MEMBER       ONLINE  NORMAL   REPAIR_0000     FG3             /dev/asm_1g_5            0
CLOSED  FORMER       ONLINE  NORMAL                                   /dev/asmdisk1            0
CACHED  MEMBER       ONLINE  NORMAL   DATA_0000       DATA_0000       /dev/asmdisk2            0
CACHED  MEMBER       ONLINE  NORMAL   ARCH_0000       ARCH_0000       /dev/asmdisk3            0

4、显式对失败组fg1离线

ALTER DISKGROUP repair offline disks in failgroup fg1

5、查看状态

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE,REPAIR_TIMER from v$asm_disk order by path;

MOUNT_S HEADER_STATU MODE_ST STATE    NAME            FAILGROUP       PATH           REPAIR_TIMER
------- ------------ ------- -------- --------------- --------------- -------------- ------------
CACHED  MEMBER       ONLINE  NORMAL   REPAIR_0001     FG2             /dev/asm_1g_4   0
CACHED  MEMBER       ONLINE  NORMAL   REPAIR_0000     FG3             /dev/asm_1g_5   0
CACHED  MEMBER       ONLINE  NORMAL   DATA_0000       DATA_0000       /dev/asmdisk2   0
CACHED  MEMBER       ONLINE  NORMAL   ARCH_0000       ARCH_0000       /dev/asmdisk3   0
MISSING UNKNOWN      OFFLINE NORMAL   REPAIR_0002     FG1                            60 
——>离线后会显示被删除disk的时间

6、告警日志中离线磁盘后，asm盘会在1min左右删除
删除磁盘的同事，还会rebalance

2019-07-04 17:49:19.260000 +08:00
SQL> ALTER DISKGROUP repair offline disks in failgroup fg1 
NOTE: DRTimer CD Create:  for disk group 6 disks:
 2

SQL> alter diskgroup REPAIR drop disk REPAIR_0002 force /* ASM SERVER */ 
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=6
GMON updating for reconfiguration, group 6 at 64 for pid 30, osid 8037
NOTE: cache closing disk 2 of grp 6: (not open) REPAIR_0002
NOTE: group REPAIR: updated PST location: disk 0000 (PST copy 0)
NOTE: group REPAIR: updated PST location: disk 0001 (PST copy 1)
NOTE: group 6 PST updated.
NOTE: membership refresh pending for group 6/0xbd494134 (REPAIR)
2019-07-04 17:52:36.847000 +08:00
GMON querying group 6 at 65 for pid 18, osid 2291
NOTE: cache closing disk 2 of grp 6: (not open) _DROPPED_0002_REPAIR
SUCCESS: refreshed membership for 6/0xbd494134 (REPAIR)
SUCCESS: alter diskgroup REPAIR drop disk REPAIR_0002 force /* ASM SERVER */
SUCCESS: PST-initiated drop disk in group 6(3175694644))
2019-07-04 17:52:39.872000 +08:00
NOTE: Attempting voting file refresh on diskgroup REPAIR
NOTE: Refresh completed on diskgroup REPAIR. No voting file found.
NOTE: starting rebalance of group 6/0xbd494134 (REPAIR) at power 1
Starting background process ARB0
ARB0 started with pid=36, OS id=8134 
NOTE: assigning ARB0 to group 6/0xbd494134 (REPAIR) with 1 parallel I/O
cellip.ora not found.
NOTE: F1X0 copy 2 relocating from 2:2 to 1:2 for diskgroup 6 (REPAIR)
NOTE: F1X0 copy 3 relocating from 1:2 to 65534:4294967294 for diskgroup 6 (REPAIR)
2019-07-04 17:52:41.989000 +08:00
NOTE: Rebalance has restored redundancy for any existing control file or redo log in disk group REPAIR
NOTE: stopping process ARB0
2019-07-04 17:52:43.470000 +08:00
SUCCESS: rebalance completed for group 6/0xbd494134 (REPAIR)
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=6
2019-07-04 17:52:46.510000 +08:00
GMON updating for reconfiguration, group 6 at 66 for pid 36, osid 8136
NOTE: cache closing disk 2 of grp 6: (not open) _DROPPED_0002_REPAIR
NOTE: group REPAIR: updated PST location: disk 0000 (PST copy 0)
NOTE: group REPAIR: updated PST location: disk 0001 (PST copy 1)
NOTE: group 6 PST updated.
SUCCESS: grp 6 disk _DROPPED_0002_REPAIR going offline 
GMON updating for reconfiguration, group 6 at 67 for pid 36, osid 8136
NOTE: cache closing disk 2 of grp 6: (not open) _DROPPED_0002_REPAIR
NOTE: group REPAIR: updated PST location: disk 0000 (PST copy 0)
NOTE: group REPAIR: updated PST location: disk 0001 (PST copy 1)
NOTE: group 6 PST updated.
NOTE: membership refresh pending for group 6/0xbd494134 (REPAIR)
2019-07-04 17:52:49.501000 +08:00
GMON querying group 6 at 68 for pid 18, osid 2291
GMON querying group 6 at 69 for pid 18, osid 2291
NOTE: Disk _DROPPED_0002_REPAIR in mode 0x0 marked for de-assignment
SUCCESS: refreshed membership for 6/0xbd494134 (REPAIR)
2019-07-04 17:52:52.520000 +08:00
NOTE: Attempting voting file refresh on diskgroup REPAIR
NOTE: Refresh completed on diskgroup REPAIR. No voting file found.

总结：
只有在人为离线asm磁盘之后，asm才会将磁盘在repair_time时间，删除asm盘