"ORACLE" ASM disk Group and delete disk member method

************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************

The first step is to close the library shutdown Immediate

The second step is to look at the DG Mount DiskGroup case

Sql> Show Parameter DiskGroup

Alter DiskGroup Dgdata Mount;

Third, see the path to the disk you want to delete

Select Name,total_mb/1024,free_mb/1024,path from V$asm_disk;

dgdata_0003 556 1347.5625/dev/raw/raw9

Fourth, check the usage of disk that needs to be deleted:

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

dgdata_0003 1556 1347.5625

Fifth step , view bare device mappings, multipath mappings, Memory mappings

/bin/raw/dev/raw/raw9/dev/mapper/oradata4

Multi-Path mapping

ORADATA4 (36005076307ffc3ff0000000000000103) dm-11 ibm,2107900

Storage mapping situation

Fb_vol_4 0103 1556 fb_p3p3 S7 S8

Sixth step,alter diskgroup dgdata drop disk ' dgdata_0003 ' rebalance Power 5 wait;

Seventh step, the monitoring data re-stripe operation view.

SELECT * FROM V$asm_operation

Eighth step, confirm that it has been deleted

Sql>select path,group_number,disk_number,mount_status,header_status,mode_status,state from V$asm_disk;

Add disk and delete similar:

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

monitoring data re-striped Operation view.

SELECT * FROM V$asm_operation

Other than that

To create a disk group manually Dgfra:

Create DiskGroup Dgfra External redundancy disk '/dev/raw/raw8 ';

************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************

"ORACLE" ASM disk Group and delete disk member method