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@xxxxxxxxx>
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
