Sunday, October 18, 2015

Expand OCRVOTE diskgroup size before upgrading to 12c



[root@rac01 ~]# oracleasm createdisk VOTE2 /dev/sdd1
Writing disk header: done
Instantiating disk: done

SQL> select path, name, header_status from v$asm_disk;

PATH                 NAME                           HEADER_STATU
-------------------- ------------------------------ ------------
ORCL:VOTE2                                          PROVISIONED
ORCL:DATA1           DATA1                          MEMBER
ORCL:FRA1            FRA1                           MEMBER
ORCL:VOTE1           VOTE1                          MEMBER

SQL> alter diskgroup OCRVOTE add disk 'ORCL:VOTE2' drop disk VOTE1;

Diskgroup altered.

SQL> select path, name, header_status from v$asm_disk;

PATH                 NAME                           HEADER_STATU
-------------------- ------------------------------ ------------
ORCL:VOTE1                                          FORMER
ORCL:DATA1           DATA1                          MEMBER
ORCL:FRA1            FRA1                           MEMBER
ORCL:VOTE2           VOTE2                          MEMBER