ora-15040 diskgroup is incomplete ORA-15042 ASM Disk"2" is missing.
hi,
unfortunatly our server get rebooted after taht we are try to start ASM instance then we got below error
ora-15040 diskgroup is incomplete ORA-15042 ASM Disk"2" is missing.but we are checking from OS side all disk are OK.all the Diskgroup are in external rededuncy.
GROUP_NUMBER NAME TYPE OFFLINE_DISKS U STATE
------------------------------
------------- -
1 DG_GROUP1 EXTERN 0 N MOUNTED
2 DG_GROUP2 EXTERN 0 N MOUNTED
3 DG_GROUP4 EXTERN 0 N MOUNTED
0 DG_GROUP3 0 N DISMOUNTED
when i m mount th diskgroup usging below query we have got error
SQL> alter diskgroup DG_GROUP3 mount;
alter diskgroup DG_GROUP3 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "2" is missing
what steps we need to perform to start the ASM does it causeess the data loss.how we can recover the database.
thanks,