以下3个盘是我需要加进去的盘，用来exchange原来的盘。

[oracle@rac1 ~]$ kfod disk=all

--------------------------------------------------------------------------------

Disk Size Path User Group

================================================================================

1: 6142 Mb /dev/asm-acfs01 oracle dba

2: 6142 Mb /dev/asm-acfs02 oracle dba

3: 1019 Mb /dev/asm-data01 oracle dba

4: 1019 Mb /dev/asm-data02 oracle dba

5: 1019 Mb /dev/asm-data03 oracle dba

6: 1019 Mb /dev/asm-data04 oracle dba

7: 1019 Mb /dev/asm-data05 oracle dba

8: 698 Mb /dev/asm-ex_ocrvot_01 oracle dba <==

9: 698 Mb /dev/asm-ex_ocrvot_02 oracle dba <==

10: 698 Mb /dev/asm-ex_ocrvot_03 oracle dba <==

11: 1019 Mb /dev/asm-fra01 oracle dba

12: 1019 Mb /dev/asm-fra02 oracle dba

13: 1019 Mb /dev/asm-fra03 oracle dba

14: 1019 Mb /dev/asm-fra04 oracle dba

15: 611 Mb /dev/asm-ocrvot1 oracle dba

16: 611 Mb /dev/asm-ocrvot2 oracle dba

17: 611 Mb /dev/asm-ocrvot3 oracle dba

--------------------------------------------------------------------------------

ORACLE_SID ORACLE_HOME

================================================================================

+ASM1 /u01/app/11.2.0.3/grid

[oracle@rac1 ~]$ [oracle@rac1 ~]$

SQL> select name,group_number,type,state from v$asm_diskgroup order by 2;

NAME GROUP_NUMBER TYPE STATE

------------------------------ ------------ ------ -----------

ACFS 1 EXTERN MOUNTED

DATA 2 EXTERN MOUNTED

FRA 3 EXTERN MOUNTED

OCRVOT 4 NORMAL MOUNTED

SQL>

SQL>

SQL> select name,state,REDUNDANCY,path,GROUP_NUMBER from v$asm_disk order by GROUP_NUMBER,name;

NAME STATE REDUNDA PATH GROUP_NUMBER

------------------------------ -------- ------- ---------------------------------------- ------------

NORMAL UNKNOWN /dev/asm-ex_ocrvot_02 0

NORMAL UNKNOWN /dev/asm-ex_ocrvot_01 0

NORMAL UNKNOWN /dev/asm-ex_ocrvot_03 0

NORMAL UNKNOWN /dev/asm-data05 0

ACFS_0000 NORMAL UNKNOWN /dev/asm-acfs01 1

ACFS_0001 NORMAL UNKNOWN /dev/asm-acfs02 1

DATA_0000 NORMAL UNKNOWN /dev/asm-data01 2

DATA_0001 NORMAL UNKNOWN /dev/asm-data02 2

DATA_0002 NORMAL UNKNOWN /dev/asm-data03 2

DATA_0003 NORMAL UNKNOWN /dev/asm-data04 2

FRA_0000 NORMAL UNKNOWN /dev/asm-fra01 3

FRA_0001 NORMAL UNKNOWN /dev/asm-fra02 3

FRA_0002 NORMAL UNKNOWN /dev/asm-fra03 3

FRA_0003 NORMAL UNKNOWN /dev/asm-fra04 3

OCRVOT_0000 NORMAL UNKNOWN /dev/asm-ocrvot1 4

OCRVOT_0001 NORMAL UNKNOWN /dev/asm-ocrvot2 4

OCRVOT_0002 NORMAL UNKNOWN /dev/asm-ocrvot3 4

17 rows selected.

SQL>

--开始加盘：

[oracle@rac1 ~]$ sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 16 12:01:40 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

--可以看到，ocr是属于asm file的，根据定义，asm file是会做rebalance的。

SQL> l

1* select file_number,GROUP_NUMBER,type from v$asm_file where type not in ('ARCHIVELOG','DATAFILE','ONLINELOG','CONTROLFILE') order by GROUP_NUMBER

SQL> /

FILE_NUMBER GROUP_NUMBER TYPE

----------- ------------ --------------------

256 1 ASMVOL

253 2 ASMPARAMETERFILE

273 2 PARAMETERFILE

279 2 TEMPFILE

275 3 PARAMETERFILE

255 4 OCRFILE

6 rows selected.

SQL> alter diskgroup OCRVOT add disk '/dev/asm-ex_ocrvot_01' size 600m;

Diskgroup altered.

SQL> alter diskgroup OCRVOT add disk '/dev/asm-ex_ocrvot_02' size 600m;

Diskgroup altered.

SQL> c/2/3

1* alter diskgroup OCRVOT add disk '/dev/asm-ex_ocrvot_03' size 600m

SQL> /

Diskgroup altered.

--可以看到有rebalance的动作

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE

------------ ----- ---- ---------- ---------- ---------- ---------- ----------

EST_MINUTES ERROR_CODE

----------- --------------------------------------------

4 REBAL RUN 1 1 0 323 0

0

SQL> /

GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE

------------ ----- ---- ---------- ---------- ---------- ---------- ----------

EST_MINUTES ERROR_CODE

----------- --------------------------------------------

4 REBAL RUN 1 1 87 323 404

0

SQL> /

GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE

------------ ----- ---- ---------- ---------- ---------- ---------- ----------

EST_MINUTES ERROR_CODE

----------- --------------------------------------------

4 REBAL RUN 1 1 236 323 412

0

SQL>

SQL> /

GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE

------------ ----- ---- ---------- ---------- ---------- ---------- ----------

EST_MINUTES ERROR_CODE

----------- --------------------------------------------

4 REBAL RUN 1 1 323 323 0

0

SQL> --reblanace完成

SQL> /

no rows selected

SQL>

SQL> --看到 255号asm file，即ocr file，是分配到了6个disk上。即完成了rebalance。

SQL> select number_kfdat from x$kfdat where group_kfdat=4 and fnum_kfdat=255 group by number_kfdat;

NUMBER_KFDAT

------------

0

1

2

3

4

5

6 rows selected.

SQL> --看到votingdisk还是在原来的0，1，2号盘上，即没有做 rebalance。

SQL> select number_kfdat from x$kfdat where group_kfdat=4 and fnum_kfdat=1048572 group by number_kfdat;

NUMBER_KFDAT

------------

0

1

2