Re: ASM diskgroup is dismount

Looks like one of the disks comprising the disk group gave up its ghost. Please check /var/log/messages. Try dropping the defective disk from the disk group. If that doesn't work, there is always RMAN. This doesn't look like a good way to start the year 2020. However you should always look on the bright side of life 😉.
Regards

On Thu, Jan 2, 2020, 11:18 Vinay Kumar Narisetty <narisetty.vinay_at_gmail.com> wrote:

> Hi,
>
> Oracle 19c database my ASM disgroups got dismounted.Diskgroup name "DATA"
> .I can mount it back today morning and startup the database instance
> without any issue.
>
> I see below message in alert.log file:
> 2020-01-01 18:36:14.477+ORA-15032: not all alterations performed
> ORA-15017: diskgroup "DATA" cannot be mounted
> ORA-15040: diskgroup is incomplete
> ORA-15080: synchronous I/O operation failed to read block 0 of disk 0 in
> disk group
> ORA-27061: waiting for async I/Os failed
> Linux-x86_64 Error: 5: Input/output error
> Additional information: 4294967295
> Additional information: 4096
> . For details refer to "(:CLSN00107:)" in
> "/u01/app/grid/diag/crs/rmpp-proddb/crs/trace/ohasd_oraagent_grid.trc".
> 2020-01-01 18:36:14.486 [OHASD(4156)]CRS-2878: Failed to restart resource
> 'ora.DATA.dg'
> 2020-01-01 18:36:14.545 [ORAAGENT(4337)]CRS-8503: Oracle Clusterware
> process ORAAGENT with operating system process ID 4337 experienced fatal
> signal or exception code 11.
> 2020-01-01T18:36:14.599529-06:00
> Errors in file
> /u01/app/grid/diag/crs/rmpp-proddb/crs/trace/ohasd_oraagent_grid.trc
> (incident=1):
> CRS-8503 [__lll_unlock_elision()+48] [Signal/Exception: 11] [Instruction
> Addr: 0x7f7629fe0640] [Memory Addr: (nil)] [] [] [] [] [] [] [] []
> Incident details in:
> /u01/app/grid/diag/crs/rmpp-proddb/crs/incident/incdir_1/ohasd_oraagent_grid_i1.trc
>
> Can any one advice why my ASM diskgroup is dismounted ?
>
> alert.log;
> 2019-12-31 13:53:04.324 [ORAAGENT(4337)]CRS-5010: Update of configuration
> file "/u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora"
> failed: details at "(:CLSN00015:)" in
> "/u01/app/grid/diag/crs/rmpp-proddb/crs/trace/ohasd_oraagent_grid.trc"
> 2020-01-01 18:36:12.106 [ORAAGENT(4337)]CRS-5011: Check of resource "PUNV"
> failed: details at "(:CLSN00007:)" in
> "/u01/app/grid/diag/crs/rmpp-proddb/crs/trace/ohasd_oraagent_grid.trc"
> 2020-01-01 18:36:14.477 [ORAAGENT(4337)]CRS-5017: The resource action
> "ora.DATA.dg start" encountered the following error:
> 2020-01-01 18:36:14.477+ORA-15032: not all alterations performed
> ORA-15017: diskgroup "DATA" cannot be mounted
> ORA-15040: diskgroup is incomplete
> ORA-15080: synchronous I/O operation failed to read block 0 of disk 0 in
> disk group
> ORA-27061: waiting for async I/Os failed
> Linux-x86_64 Error: 5: Input/output error
> Additional information: 4294967295
> Additional information: 4096
> . For details refer to "(:CLSN00107:)" in
> "/u01/app/grid/diag/crs/rmpp-proddb/crs/trace/ohasd_oraagent_grid.trc".
> 2020-01-01 18:36:14.486 [OHASD(4156)]CRS-2878: Failed to restart resource
> 'ora.DATA.dg'
> 2020-01-01 18:36:14.545 [ORAAGENT(4337)]CRS-8503: Oracle Clusterware
> process ORAAGENT with operating system process ID 4337 experienced fatal
> signal or exception code 11.
> 2020-01-01T18:36:14.599529-06:00
> Errors in file
> /u01/app/grid/diag/crs/rmpp-proddb/crs/trace/ohasd_oraagent_grid.trc
> (incident=1):
> CRS-8503 [__lll_unlock_elision()+48] [Signal/Exception: 11] [Instruction
> Addr: 0x7f7629fe0640] [Memory Addr: (nil)] [] [] [] [] [] [] [] []
> Incident details in:
> /u01/app/grid/diag/crs/rmpp-proddb/crs/incident/incdir_1/ohasd_oraagent_grid_i1.trc
>
> 2020-01-01 18:36:16.381 [ORAAGENT(33223)]CRS-8500: Oracle Clusterware
> ORAAGENT process is starting with operating system process ID 33223
> 2020-01-01 18:36:22.963 [ORAAGENT(33223)]CRS-5017: The resource action
> "ora.punv.db start" encountered the following error:
> 2020-01-01 18:36:22.963+ORA-01078: failure in processing system parameters
> LRM-00109: could not open parameter file
> '/u01/app/oracle/product/19.3.0/db_1/dbs/initPUNV.ora'
> . For details refer to "(:CLSN00107:)" in
> "/u01/app/grid/diag/crs/rmpp-proddb/crs/trace/ohasd_oraagent_grid.trc".
> 2020-01-01 18:36:24.046 [OHASD(4156)]CRS-2878: Failed to restart resource
> 'ora.punv.db'
>
>
> Regards,
> Vinay Narisetty
>

--
http://www.freelists.org/webpage/oracle-l