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

http://www.cndba.cn/dave/article/821

1)  As Oracle OS user, run the next commands on each node (if ASMLIB API is used): http://www.cndba.cn/dave/article/821

$> 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):http://www.cndba.cn/dave/article/821

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).

 http://www.cndba.cn/dave/article/821

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

 

 http://www.cndba.cn/dave/article/821

 

 

 

 

From Oracle

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

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

Email: dvd.dba@gmail.comhttp://www.cndba.cn/dave/article/821http://www.cndba.cn/dave/article/821

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

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

聊天 群：40132017   聊天2群：69087192

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

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 11g