[ORACLE] Method for adding or deleting disk members to an ASM disk, asmdisk

[ORACLE] Method for adding or deleting disk members to an ASM disk, asmdisk
**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************************************** ********************************

Step 1: Disable the database shutdown immediate

Step 2: Check the mounting diskgroup status of the dg.

SQL> show parameter diskgroup

Alter diskgroup dgdata mount;

Step 3: view the path of the disk to be deleted

Select name, total_mb/1024, free_mb/1024, path from v $ asm_disk;

DGDATA_0003 556 1347.5625/dev/raw/raw9

Step 4: view the usage of the disk to be deleted:

Select name, total_mb/1024, free_mb/1024 from v $ asm_disk_stat

DGDATA_0003 1556 1347.5625

Step 5: Check bare device ing, multi-path ing, and memory ing

/Bin/raw/dev/raw/raw9/dev/mapper/oradata4

Multi-path ing

Oradata4 (36005076307ffc3ff0000000000000103) dm-11 IBM, 2107900

Storage ing

Fb_vol_4 0103 1556 FB_P3P3 s7 s8

Step 6: alter diskgroup dgdata drop disk 'dgdata _ 100' rebalance power 5 wait;

Step 7: restrip the monitoring data to the operation view.

Select * from v $ asm_operation

Step 8: confirm the deletion

SQL> select path, group_number, disk_number, mount_status, header_status, mode_status, state from v $ asm_disk;

 

Adding or deleting a disk is similar:

Alter diskgroup dgdata add disk '/dev/raw/raw9 ';

The monitoring data is restriped to the operation view.

Select * from v $ asm_operation

 

In addition

Manually create a disk group dgfra:

Create diskgroup dgfra external redundancy disk '/dev/raw/raw8 ';

**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************************************** ********************************