Data Guard Managed Recovery Apply Process Running Slowly (Doc ID 1448626.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***

Symptoms

The managed recovery process MRP0 is running successfully but is slow in applying logs. The trace files for the recovery slaves show the following type of messages:

*** 2012-03-20 08:29:27.211
Recovery is unrecoverable because 6 other slaves require space.

*** 2012-03-20 08:29:37.908
Recovery is unrecoverable because it fails to get a free buffer.

*** 2012-03-20 08:29:38.490
Recovery is unrecoverable because 6 other slaves require space.

*** 2012-03-20 08:29:59.932
Recovery is unrecoverable because it fails to get a free buffer.


Note the number of slaves affected can be different depending on the environment.

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