在已创建好的Diskgroup中增加磁盘，可以为磁盘组增加容量；也可以在磁盘组中删除磁盘，减少容量。

$ export ORACLE_SID=+ASM1
$ export PATH=$PATH:/u01/app/12.1.0/grid/bin/
$ export ORACLE_HOME=/u01/app/12.1.0/grid

以sysadm身份登录Oracle
$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 10 17:52:05 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select group_number,name from v$asm_diskgroup;
GROUP_NUMBER NAME
------------                  ------------------------------
           1                     DATA1

创建磁盘组ASMGRP, 冗余设为nornal，至少有两个failgroup
SQL> create diskgroup ASMGRP normal redundancy
FAILGROUP fg1 DISK '/dev/rdsk/c0t600144F094C10BA3000053641E6A00F6d0s0' name disk1
FAILGROUP fg2 DISK '/dev/rdsk/c0t600144F094C10BA3000053641E6B00F7d0s0' name disk2
ATTRIBUTE 'au_size'='8M', 'compatible.asm' = '11.2','compatible.rdbms' = '11.2';
2    3    4
Diskgroup created.

在每个failgroup中增加两个磁盘
SQL> alter diskgroup ASMGRP add
FAILGROUP fg1 DISK '/dev/rdsk/c0t600144F094C10BA3000053641E6300EDd0s0' name disk12
FAILGROUP fg1 DISK '/dev/rdsk/c0t600144F094C10BA3000053641E6500F0d0s0' name disk13
FAILGROUP fg2 DISK '/dev/rdsk/c0t600144F094C10BA3000053641E6400EEd0s0' name disk22
FAILGROUP fg2 DISK '/dev/rdsk/c0t600144F094C10BA3000053641E6600F1d0s0' name disk23
rebalance power 1;
2    3    4    5    6
Diskgroup altered.

查看磁盘组再平衡的进度
SQL> select group_number,operation,state,power,est_minutes from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER EST_MINUTES
------------                  -----        ----         ---------- -----------
           2                     REBAL EST       1           0
           2                     REBAL WAIT       1           0
           2                     REBAL WAIT       1           0

查看failgroup中的成员，确认磁盘增加成功
SQL> select DISK_NUMBER, name, FAILGROUP, FAILGROUP_TYPE from v$asm_disk;
DISK_NUMBER NAME        FAILGROUP       FAILGRO
----------- ------------------------ --------------------- ----------------
          0                                                                   REGULAR
          1                                                                   REGULAR
          2                                                                   REGULAR
          0 DATA1_0000              DATA1_0000      REGULAR
          2 DISK12                         FG1                      REGULAR
          4 DISK22                         FG2                      REGULAR
          3 DISK13                         FG1                      REGULAR
          5 DISK23                         FG2                      REGULAR
          0 DISK11                         FG1                      REGULAR
          1 DISK21                         FG2                      REGULAR

10 rows selected.

在每个failgroup中删除一个磁盘
SQL> alter diskgroup ASMGRP drop DISK disk12,disk22 rebalance power 1;
Diskgroup altered.

查看failgroup中的成员，确认磁盘删除成功
SQL> select DISK_NUMBER, name, FAILGROUP, FAILGROUP_TYPE from v$asm_disk;
DISK_NUMBER NAME        FAILGROUP FAILGRO
----------- ------------------------ ------------------ ------------
          0                                                               REGULAR
          1                                                               REGULAR
          2                                                               REGULAR
          3                                                               REGULAR
          4                                                               REGULAR
          0 DATA1_0000               DATA1_0000   REGULAR
          3 DISK13                         FG1                 REGULAR
          5 DISK23                         FG2                 REGULAR
          0 DISK11                         FG1                 REGULAR
          1 DISK21                         FG2                 REGULAR

10 rows selected.

ITPub博客

在Diskgroup中增加和删除磁盘

最新文章