Data Guard Managed Recovery Apply Process Running Slowly
Last updated on NOVEMBER 01, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterInformation 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.
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