ORA-15040: diskgroup is incomplete



ASM is running but diskgroup is not mounted and its in incomplete state.

[oracle@primary bin]$ps -ef|grep asm


oracle    4222     1  0 02:19 ?        00:00:00 asm_pmon_+ASM
oracle    4224     1  0 02:19 ?        00:00:01 asm_psp0_+ASM
oracle    4226     1  2 02:19 ?        00:01:43 asm_vktm_+ASM
oracle    4230     1  0 02:19 ?        00:00:12 asm_gen0_+ASM
oracle    4232     1  0 02:19 ?        00:00:00 asm_mman_+ASM
oracle    4236     1  0 02:19 ?        00:00:00 asm_diag_+ASM
oracle    4238     1  0 02:19 ?        00:00:02 asm_dia0_+ASM
oracle    4240     1  0 02:19 ?        00:00:00 asm_dbw0_+ASM
oracle    4242     1  0 02:19 ?        00:00:00 asm_lgwr_+ASM
oracle    4244     1  0 02:19 ?        00:00:00 asm_ckpt_+ASM
oracle    4246     1  0 02:19 ?        00:00:00 asm_smon_+ASM
oracle    4248     1  0 02:19 ?        00:00:00 asm_lreg_+ASM
oracle    4250     1  0 02:19 ?        00:00:00 asm_pxmn_+ASM
oracle    4252     1  0 02:19 ?        00:00:00 asm_rbal_+ASM
oracle    4254     1  0 02:19 ?        00:00:01 asm_gmon_+ASM
oracle    4256     1  0 02:19 ?        00:00:00 asm_mmon_+ASM
oracle    4258     1  0 02:19 ?        00:00:00 asm_mmnl_+ASM
oracle    4739     1  0 02:32 ?        00:00:00 ora_asmb_prod
oracle    4743     1  0 02:32 ?        00:00:00 oracle+ASM_asmb_prod (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle    6901  3508  0 03:36 pts/0    00:00:00 grep asm


Issue:


[oracle@primary bin]$asmcmd


asmcmd> lsdg




No diskgroups as shown.


When I tried to start asm, ora.asm resource was found in intermediate state.

SQL> alter diskgroup DATA mount;
alter diskgroup data mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup “DATA” cannot be mounted
ORA-15040: diskgroup is incomplete


Workaround:


When I listed ASM disks on node primary,VOLSTB was not listed


[root@primary bin]# oracleasm listdisks




[root@primary bin]# oracleasm init


Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module “oracleasm”: oracleasm
Configuring “oracleasm” to use device physical block size 
Mounting ASMlib driver filesystem: /dev/oracleasm

[root@primary bin]# oracleasm scandisks


Reloading disk partitions: done
Cleaning any stale ASM disks…
Scanning system for ASM disks…
Instantiating disk “VOLSTB”


[root@primary bin]# oracleasm listdisks


VOLSTB


Now I could mount VOLSTB disk successfully


Now can I mount DATA diskgroup successfully,


SQL> alter diskgroup DATA mount;


Diskgroup altered.


asmcmd> lsdg


State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     15358    15264                0           15264              0             N  DATA/

  • March 10, 2017 | 32 views
  • Comments