How To Add a New Disk(s) to An Existing Diskgroup on RAC (Best Practices).

 

       Before you add the disk(s) to your production diskgroup, you can use the next steps to validate whether the candidate disk(s) is/are in good shape and can be accessed from each node (without harm the existing production diskgroups), as follow:

 

Solution

1)  As Oracle OS user, run the next commands on each node (if ASMLIB API is used):

$> id
$> /etc/init.d/oracleasm  scandisks
$> /etc/init.d/oracleasm  listdisks
$> /etc/init.d/oracleasm  querydisk <each disk from previous output>

Note: All the disks must be visible from each node.

2)  Confirm the disks are visible (I/O) at OS level (as Oracle OS user) from each node:

$> id
$> ls -l  <disk name>
$> dd if=<raw/partition file in question> of=/dev/null count=100 bs=8192

Example:

$> dd if=/dev/raw/raw1 of=/dev/null count=100 bs=8192  # raw device
$> dd if=/dev/oracleasm/disks/PRODA07 of=/dev/null count=100 bs=8192  # ASMLIB device

 

3)  Create a new temporary diskgroup:

SQL> CREATE DISKGROUP TEST EXTERNAL REDUNDANCY DISK '<YOUR CANDIDATE DISK>';

 

4)  Check if the diskgroup is created and mounted:

SQL> SELECT STATE, NAME FROM V$ASM_DISKGROUP;

 

5)  If so, then manually mount it on the other ASM instance(s):

SQL> ALTER DISKGROUP TEST MOUNT;
SQL> SELECT STATE, NAME FROM V$ASM_DISKGROUP;

 

6 If the previous steps had success and the TEST diskgroup can be successfully mounted (on each ASM instance), then drop the TEST diskgroup as follow:

 

SQL> alter diskgroup test dismount; --(from all the ASM instances, except from one).

SQL> DROP DISKGROUP TEST; --(from the ASM instance, which the diskgroup is still mounted).

 

7)  Then the candidate disk is ready to be added to the desired diskgroup:

SQL> ALTER DISKGROUP <my production diskgroup> ADD DISK '<your candidate disk>';

 

References

NOTE:288002.1 - OERR: ORA-15075 disk(s) are not visible cluster-wide

 

 

 

 

 

 

From Oracle

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

Blog： http://blog.csdn.net/tianlesoftware

Email: [e-mail]

DBA1 群：62697716(满);   DBA2 群：62697977(满)   DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群： 83829929  DBA5群： 142216823   

聊天 群：40132017   聊天2群：69087192

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请