SQL> create diskgroup dg8 normal redundancy --构建一个二向镜像磁盘组(就是两个failgroup)
2 failgroup fg1 disk ---failgroup可以不加,系统会自动生成一个名字
3 '/dev/rdsk/c0d1s5' name fg1_d1 ---磁盘的名字
4 failgroup fg2 disk
5 '/dev/rdsk/c0d1s6' name fg2_d2;
Diskgroup created.
SQL> select group_number,name from v$asm_diskgroup;
GROUP_NUMBER NAME
------------ ------------------------------
1 DATA
2 ARCH
3 DG8
SQL> select name,path,failgroup from v$asm_disk where group_number=3;
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
FG1_D1
/dev/rdsk/c0d1s5
FG1
FG2_D2
/dev/rdsk/c0d1s6
FG2
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
SQL> drop diskgroup dg8 including contents;
Diskgroup dropped.
SQL> create diskgroup dg8 normal redundancy --不加failgroup和nama构建磁盘组,同样成功
2 disk '/dev/rdsk/c0d1s5'
3 disk '/dev/rdsk/c0d1s6';
Diskgroup created.
SQL> select group_number from v$asm_diskgroup where name='DG8';
GROUP_NUMBER
------------
3
SQL> select name,path,failgroup from v$asm_disk where group_number=3;---查看不加failgroup和name的磁盘组
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
DG8_0000
/dev/rdsk/c0d1s5
DG8_0000
DG8_0001
/dev/rdsk/c0d1s6
DG8_0001
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
SQL> alter diskgroup dg8 drop disks in failgroup dg8_0000; ---删除磁盘组中一个failgroup的disk
Diskgroup altered.
SQL> select path,name,mount_status from v$asm_disk;
PATH
--------------------------------------------------------------------------------
NAME MOUNT_S
------------------------------ -------
/dev/rdsk/c0d1s0
CLOSED
/dev/rdsk/c0d1s7
CLOSED
/dev/rdsk/c0d1s3
CLOSED
PATH
--------------------------------------------------------------------------------
NAME MOUNT_S
------------------------------ -------
/dev/rdsk/c1d1s0
CLOSED
/dev/rdsk/c1d1s1
CLOSED
/dev/rdsk/c0d1s1
DATA_0000 CACHED
PATH
--------------------------------------------------------------------------------
NAME MOUNT_S
------------------------------ -------
/dev/rdsk/c0d1s4
ARCH_0000 CACHED
/dev/rdsk/c0d1s5
DG8_0000 CACHED
/dev/rdsk/c0d1s6
DG8_0001 CACHED
9 rows selected.
SQL> alter diskgroup dg8 add failgroup fg3 disk '/dev/rdsk/c0d1s3';---为磁盘组添加failgroup
Diskgroup altered.
SQL> select name,path,failgroup from v$asm_disk where group_number=3;
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
DG8_0002
/dev/rdsk/c0d1s3
FG3
DG8_0001
/dev/rdsk/c0d1s6
DG8_0001
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
SQL> alter diskgroup dg8 resize disks in failgroup fg3 size 20m; --对磁盘组中一个failgroup重定义大小
Diskgroup altered.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-620563/
,如需转载,请注明出处,否则将追究法律责任。