Instance Recovery Hang Due to Parallel Recovery Slaves Blocked on IO
Last updated on OCTOBER 05, 2017
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2Information 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: oracle@linux-hw (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 timeChanges
none.Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms