PQ Slave Initiating Offline of a Disk May Result in ORA-15078 or ORA-15130 ASM Diskgroup Forecibly Dismounted
(Doc ID 2636990.1)
Last updated on JULY 27, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199.0 [Release 12.2 to 19]
Information in this document applies to any platform.
DB instance Alert log will show PQ slaves initiating offline of a disk:
10-12 10:30:52.859464 10606 PDB_PRODNCM(3):NOTE: process
_p0la_cdbrac12 (302818) initiating offline of disk 120.2322156497
(DATAC1_FD_00_NZEPC01F03CE034XM) with mask 0x7e in group 1 (DATAC1) with
This may happen with several disks until the diskgroup is forcibly taken offline. From the ASM alert log:
ERROR: too many offline disks in PST (grp 1)
NOTE: cache dismounting (not clean) group 1/0xB2A07837 (DATAC1)
DB instance alert log may report ORA-15178:
Errors in file /u01/app/oracle/diag/rdbms/cdbrac1/CDBRAC13/trace/CDBRAC13_ora_324683.trc:
ORA-15078: ASM diskgroup was forcibly dismounted
And other trace files may report ORA-15130:
NOTE: handling error ORA-15130 while draining I/OsERROR: ORA-15130 thrown in
ARB0 for group number 1
ORA-15130: diskgroup "DATAC1" is being dismounted
The PQ slave trace file from the PQ slave that initiated the disk offline will have reconnects in it like :
still in progress)
*** 2019-10-13T12:45:31.095291-07:00 (PDB_PRODNCM(3))
Device Reopen async completion request 0x175db300, device handle 0x1734be50,
error code 0
Reconnect to box 0x173107d0 with timeout 1072 failed with error 38 (SKGXP
And may show a 15081 "failed xlate" error:
NOTE: process _p07n_cdbexp11 (358769) initiating offline of disk
117.4043091467 (DATAC1_FD_05_NZEPC01F03CE033XM) with mask 0x7e in group 1
(DATAC1) with client assisting
Possibly recently upgraded to 12.2+ or added more PQ slaves.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document