ASM学习笔记_磁盘的管理

ASM学习笔记_磁盘的管理

DISKGROUP的所有管理操作,都必须要求DISKGROUP的状态为Mount

1 Create Diskgroup
create diskgroup data external redundancy disk '/dev/raw/raw1','/dev/raw/raw2';

2 ADD Disk
ALTER DISKGROUP DATA add disk '/dev/raw/raw3' rebalance power 3 wait;

3 Drop DiskGroup

When you drop a disk group, ASM dismounts the disk group and removes the disk group name from the ASM_DISKGROUPS initialization parameter if a server parameter file is being used.
Drop的过程是: 先Dismount,再移除信息

Drop 之前, diskgroup必须是Mount状态

drop diskgroup test [excluding |including contents];

例子:
连文件一起删除.default is exluding
SQL> drop diskgroup test including contents;

Diskgroup dropped.

SQL> select a.name, b.name, a.state from v$ASM_diskgroup a , v$asm_disk b where a.group_number = b.group_number;

NAME                           NAME                           STATE
------------------------------ ------------------------------ ----------
TEST                           VOL1                           MOUNTED

为什么删除后状态还是Mount?

4 DROP Disk
ALTER DISKGROUP DATA drop disk XXX  rebalance power 3 wait;

5 REBALANCE
ALTER DISKGROUP DATA REBALANCE POWER 5 WAIT;

6 Monunt and Dismount
Alter Diskgroup data mount
Alter Diskgroup data dismount

Dismount某个DiskGroup的时候,这个DiskGroup Can't contain open file.

RAC环境下ASM 的两个实例之间关系怎么样的?
删除与状态的改变无关

在Node1:
alter diskgroup test dismount;

SQL> select a.name, b.name, a.state from v$ASM_diskgroup a , v$asm_disk b where a.group_number = b.group_number;

NAME                           NAME                           STATE
------------------------------ ------------------------------ -----------
TEST                                                          DISMOUNTED

在Node2:
SQL> select a.name diskgroup, b.name disk, a.state from v$ASM_diskgroup a , v$asm_disk b where a.group_number = b.group_number;

NAME                           NAME                           STATE
------------------------------ ------------------------------ -----------
TEST                           VOL4                           MOUNTED

不受影响.

是不是可以这样理解: 当在某个节点Dismount disk时,只是表明不能通过这个节点来访问disk,但另一个节点仍是可访问磁盘的.

7 UNDROP  在Drop完成之前撤消删除
ALTER DISKGROUP dgroup1 UNDROP DISKS;

8 RESIZE 改变大小:
ALTER DISKGROUP dgroup1 RESIZE DISKS IN FAILGROUP failgrp1 SIZE 100G;

9 Checking Internal Consistency of Disk Group Metadata 检查并修复磁盘组元数据
ALTER DISKGROUP dgroup1 CHECK ALL;

10 VIEW

V$ASM_DISKGROUP(在ASM instance and RDBMS instance 都有, RDBMS中只显示ASM DiskGroup mounted by the local ASM Instance)
This view performs disk discovery every time it is queried.

V$ASM_DISK(在ASM instance and RDBMS instance 都有, RDBMS中只显示ASM Disk mounted by the local ASM Instance)
This view performs disk discovery every time it is queried.

select a.name, b.name, a.state from v$asm_diskgroup a, v$asm_disk b where a.group_number = b.group_number

select name,total_mb, free_mb, state from v$asm_disk;

V$ASM_DISKGROUP_STAT 不做Disk Discovery
V$ASM_DISK_STAT 不做Disk Discovery

V$ASM_FILE

V$ASM_TEMPLATE

V$ASM_ALIAS

V$ASM_OPERATION

V$ASM_CLIENT

11 问题

ASM的所有管理操作到底是什么意思呢?
add,drop, resize, mount, dismount, rebalance

在RAC环境下,在某一个节点添加/删除会对整个数据库的运行有影响不?

 

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

转载于:http://blog.itpub.net/10248702/viewspace-662864/