Instance Recovery Hang Due to Parallel Recovery Slaves Blocked on IO
(Doc ID 1435359.1)
Last updated on OCTOBER 15, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Instance recovery hang and systemstate dump showed a parallel recover slave blocked on wait event 'recovery read', its short stack also indicate it was blocked on I/O.
systemstate dump:
PROCESS 31:
----------------------------------------
......
OSD pid info: Unix process pid: 12484, image: xxxxxxxxxx (P005)
Short stack dump:
......skgfrliopo()+237<-skgfospo()+119<-skgfrwat()+135<-ksfdwtio()+266<-ksfdrwat0()+386<-ksfdrwat()+34<-kclcaio()+72<-kclrechk()+319.....
Wait State:
auto_close=0 flags=0x22 boundary=(nil)/-1
Session Wait History:
0: waited for 'recovery read'
=ffffffff, =0, =1
wait_id=5105291 seq_num=59097 snap_id=1
wait times: snap=0.056006 sec, exc=0.056006 sec, total=0.056006 sec
wait times: max=0.010000 sec
wait counts: calls=0 os=0
occurred after 0.000002 sec of elapsed time
1: waited for 'recovery read'
=ffffffff, =0, =1
wait_id=5105290 seq_num=59096 snap_id=1
wait times: snap=0.012000 sec, exc=0.012000 sec, total=0.012000 sec
wait times: max=0.010000 sec
wait counts: calls=0 os=0
occurred after 0.000002 sec of elapsed time
----------------------------------------
......
OSD pid info: Unix process pid: 12484, image: xxxxxxxxxx (P005)
Short stack dump:
......skgfrliopo()+237<-skgfospo()+119<-skgfrwat()+135<-ksfdwtio()+266<-ksfdrwat0()+386<-ksfdrwat()+34<-kclcaio()+72<-kclrechk()+319.....
Wait State:
auto_close=0 flags=0x22 boundary=(nil)/-1
Session Wait History:
0: waited for 'recovery read'
=ffffffff, =0, =1
wait_id=5105291 seq_num=59097 snap_id=1
wait times: snap=0.056006 sec, exc=0.056006 sec, total=0.056006 sec
wait times: max=0.010000 sec
wait counts: calls=0 os=0
occurred after 0.000002 sec of elapsed time
1: waited for 'recovery read'
=ffffffff, =0, =1
wait_id=5105290 seq_num=59096 snap_id=1
wait times: snap=0.012000 sec, exc=0.012000 sec, total=0.012000 sec
wait times: max=0.010000 sec
wait counts: calls=0 os=0
occurred after 0.000002 sec of elapsed time
Changes
none.
Cause
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
Symptoms |
Changes |
Cause |
Solution |