PHYSICAL: Why does Managed Recovery spawn so many slaves? (Doc ID 885872.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

In 11.1 and up, Managed recovery spawns a lot of parallel slaves and limiting the parallel_max_servers parameter setting does not help.

Example:

If you set parallel_max_servers=1 on the Physical standby, you will still see managed recovery start with parallelism equal to the number of CPU's.

Completed: alter database recover managed standby database disconnect
Wed Aug 26 17:51:03 2009
ALTER SYSTEM SET parallel_max_servers=1 SCOPE=BOTH;
alter database recover managed standby database cancel
Wed Aug 26 17:51:10 2009
MRP0: Background Media Recovery canceled with status 16037
..........
RP0: Background Media Recovery process shutdown (V1116P)
Managed Standby Recovery Canceled (V1116P)
Completed: alter database recover managed standby database cancel
Wed Aug 26 17:51:22 2009
alter database recover managed standby database parallel 6 disconnect
Attempt to start background Managed Standby Recovery process (V1116P)
Wed Aug 26 17:51:22 2009
MRP0 started with pid=21, OS id=11708
MRP0: Background Managed Standby Recovery process started (V1116P)
Fast Parallel Media Recovery enabled
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 6 processes                           <--- starts even though I set parallel_max_servers=1
Waiting for all non-current ORLs to be archived...
Clearing online redo logfile 1 /u01/app/oracle/oradata/V1116/redo01.log
Clearing online log 1 of thread 1 sequence number 290
Errors in file /u01/app/oracle/diag/rdbms/v1116p/V1116P/trace/V1116P_mrp0_11708.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/V1116/redo01.log'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 291
Completed: alter database recover managed standby database parallel 6 disconnect



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