solaris 10_oracle asm_diskgroup_failgroup_相關

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.