DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, March 11, 2017

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/

1 comment:

Anonymous said...

Your blog helped me to resolve the issue. thanks.