ASM diskgroup is dismount

From: Vinay Kumar Narisetty <narisetty.vinay_at_gmail.com>
Date: Thu, 2 Jan 2020 10:16:44 -0600
Message-ID: <CAFtUX+YhTSmi8zQSNmMFjSNLun9CB3ZMgbvN3=uS13KvhzeDcQ_at_mail.gmail.com>



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
Received on Thu Jan 02 2020 - 17:16:44 CET

Original text of this message