My Oracle Support Banner

Instance Recovery Hang Due to Parallel Recovery Slaves Blocked on IO (Doc ID 1435359.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
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: 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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.