asm normal 模式扩容 -CSDN博客

数据库版本

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option

磁盘组目前模式为NORMAL 模式，存在2块磁盘，故障组名称为aa,bb;

DG_NAME     DG_STATE   TYPE       DSK_NO DSK_NAME    PATH                                 MOUNT_S FAILGROUP          STATE
--------------- ---------- ------ ---------- ---------- ------------------------------------------------------------ ------- -------------------- --------
DG1        MOUNTED    NORMAL       0 DG1_0000    /dev/oracleasm/disks/DISK01                     CACHED  AA           NORMAL
DG1        MOUNTED    NORMAL       1 DG1_0001    /dev/oracleasm/disks/DISK02                     CACHED  BB           NORMAL

为磁盘组添加2 块磁盘，每个故障组添加1块磁盘；

SQL> ALTER DISKGROUP dg1 ADD
    FAILGROUP aa disk '/dev/oracleasm/disks/DISK03'  
    FAILGROUP bb disk  '/dev/oracleasm/disks/DISK04'  ;  2    3  

Diskgroup altered.

SQL> select dg.name dg_name, dg.state dg_state, dg.type, d.disk_number dsk_no,d.name dsk_name, d.path, d.mount_status, d.FAILGROUP, d.state
from v$asm_diskgroup dg, v$asm_disk d
where dg.group_number=d.group_number
order by dg_name, dsk_no;   2    3    4  

DG_NAME     DG_STATE   TYPE       DSK_NO DSK_NAME    PATH                                 MOUNT_S FAILGROUP          STATE
--------------- ---------- ------ ---------- ---------- ------------------------------------------------------------ ------- -------------------- --------
DG1        MOUNTED    NORMAL       0 DG1_0000    /dev/oracleasm/disks/DISK01                     CACHED  AA           NORMAL
DG1        MOUNTED    NORMAL       1 DG1_0001    /dev/oracleasm/disks/DISK02                     CACHED  BB           NORMAL
DG1        MOUNTED    NORMAL       2 DG1_0002    /dev/oracleasm/disks/DISK03                     CACHED  AA           NORMAL
DG1        MOUNTED    NORMAL       3 DG1_0003    /dev/oracleasm/disks/DISK04                     CACHED  BB           NORMAL

为每个故障组添加2块磁盘

ALTER DISKGROUP dg1 ADD
    FAILGROUP aa disk '/dev/oracleasm/disks/DISK03' ,'/dev/oracleasm/disks/DISK04'
    FAILGROUP bb disk '/dev/oracleasm/disks/DISK05' ,'/dev/oracleasm/disks/DISK06';


SQL> @a

DG_NAME     DG_STATE   TYPE       DSK_NO DSK_NAME    PATH                                 MOUNT_S FAILGROUP          STATE
--------------- ---------- ------ ---------- ---------- ------------------------------------------------------------ ------- -------------------- --------
DG1        MOUNTED    NORMAL       0 DG1_0000    /dev/oracleasm/disks/DISK01                     CACHED  AA           NORMAL
DG1        MOUNTED    NORMAL       1 DG1_0001    /dev/oracleasm/disks/DISK02                     CACHED  BB           NORMAL


DISK_NUMBER NAME       PATH                  HEADER_STATUS        OS_MB    TOTAL_MB    FREE_MB
----------- ---------- ------------------------------ -------------------- ---------- ---------- ----------
      0           /dev/oracleasm/disks/DISK06    FORMER             2046           0      0
      1           /dev/oracleasm/disks/DISK05    FORMER             2046           0      0
      2           /dev/oracleasm/disks/DISK04    FORMER             2046           0      0
      3           /dev/oracleasm/disks/DISK03    FORMER             2046           0      0
      1 DG1_0001   /dev/oracleasm/disks/DISK02    MEMBER             2046        2046       1252
      0 DG1_0000   /dev/oracleasm/disks/DISK01    MEMBER             2046        2046       1252

6 rows selected.

SQL> 
SQL> 
SQL> 
SQL> ALTER DISKGROUP dg1 ADD
    FAILGROUP aa disk '/dev/oracleasm/disks/DISK03' ,'/dev/oracleasm/disks/DISK04'
    FAILGROUP bb disk '/dev/oracleasm/disks/DISK05' ,'/dev/oracleasm/disks/DISK06';  2    3  

Diskgroup altered.

SQL> @a

DG_NAME     DG_STATE   TYPE       DSK_NO DSK_NAME    PATH                                 MOUNT_S FAILGROUP          STATE
--------------- ---------- ------ ---------- ---------- ------------------------------------------------------------ ------- -------------------- --------
DG1        MOUNTED    NORMAL       0 DG1_0000    /dev/oracleasm/disks/DISK01                     CACHED  AA           NORMAL
DG1        MOUNTED    NORMAL       1 DG1_0001    /dev/oracleasm/disks/DISK02                     CACHED  BB           NORMAL
DG1        MOUNTED    NORMAL       2 DG1_0002    /dev/oracleasm/disks/DISK03                     CACHED  AA           NORMAL
DG1        MOUNTED    NORMAL       3 DG1_0003    /dev/oracleasm/disks/DISK04                     CACHED  AA           NORMAL
DG1        MOUNTED    NORMAL       4 DG1_0004    /dev/oracleasm/disks/DISK05                     CACHED  BB           NORMAL
DG1        MOUNTED    NORMAL       5 DG1_0005    /dev/oracleasm/disks/DISK06                     CACHED  BB           NORMAL

6 rows selected.


DISK_NUMBER NAME       PATH                  HEADER_STATUS        OS_MB    TOTAL_MB    FREE_MB
----------- ---------- ------------------------------ -------------------- ---------- ---------- ----------
      1 DG1_0001   /dev/oracleasm/disks/DISK02    MEMBER             2046        2046       1551
      0 DG1_0000   /dev/oracleasm/disks/DISK01    MEMBER             2046        2046       1550
      5 DG1_0005   /dev/oracleasm/disks/DISK06    MEMBER             2046        2046       1894
      4 DG1_0004   /dev/oracleasm/disks/DISK05    MEMBER             2046        2046       1895
      3 DG1_0003   /dev/oracleasm/disks/DISK04    MEMBER             2046        2046       1895
      2 DG1_0002   /dev/oracleasm/disks/DISK03    MEMBER             2046        2046       1895

6 rows selected.

SQL>