Oracle ASM -- 4: 管理ASM DiskGroup

1. Adding disks
添加的时候可以使用v$asm_disk的path:
alter diskgroup dg_data add disk 'ORCL:DISK10' REBALANCE POWER 5 WAIT;


2. Dropping Disks
删除磁盘时会有一个rebalance操作,把所有数据从待删除磁盘移动到其它磁盘上去.

首先从v$asm_disk里获取lable,然后删除
ALTER DISKGROUP dgroup1 DROP DISK disk5;


3. Resizing Disks

alter diskgroup dg_data resize all size 400m;
alter diskgroup dg_data resize disk 'DISK5' size 395m;

4. Manaing Capacity in Disk Groups

V$ASM_DISKGROUP
REQUIRED_MIRROR_FREE_MB:

Normal Redundancy: the size of the largest failure group
High Redundancy: the total size of the largest two failure group
USABLE_FILE_MB:
TOTAL_MB:
FREE_MB:


FREE_MB - REQUIRED_MIRROR_FREE_MB = 2(or 3) * USABLE_FILE_MB

5. Failure Group

For Normal Redundancy, two copies of one extent are in different failure groups. As a
result, the failure of all disks in a failure group won't result in data loss.

6. ASM Fast Mirror Resync
transient failure
DISK_REPAIR_TIME: default to 3.6h, can be changed :
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '4.5h';

7. compatible.asm and compatible.rdbm

8. mount ,unmount ,check

ALTER DISKGROUP ALL DISMOUNT;
ALTER DISKGROUP dgroup1 MOUNT;
ALTER DISKGROUP disk_group_name MOUNT FORCE;

ALTER DISKGROUP dgroup1 CHECK ALL;

DROP DISKGROUP dgroup1;

9. Views

V$ASM_ALIAS
V$ASM_ATTRIBUTE
V$ASM_CLIENT
V$ASM_DISK
V$ASM_DISK_IOSTAT
V$ASM_DISK_STAT
V$ASM_DISKGROUP
V$ASM_DISKGROUP_STAT
V$ASM_FILE
V$ASM_OPERATION
V$ASM_TEMPLATE

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/100682/viewspace-1024894/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/100682/viewspace-1024894/