My Oracle Support Banner

An attempt To Start Up The MRP Process In Physical Standby fails with error ORA-10459 "cannot start media recovery on standby database; conflicting state detected" (Doc ID 1938554.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms


ORA-10459 "cannot start media recovery on standby database; conflicting state detected":

SQL> alter database recover managed standby database (...)

MRP0: Background Media Recovery terminated with error 10459
Errors in file /local/pb/oracle/admin/diag/rdbms/tpbp_mcc/TPBP1/trace/TPBP1_pr00_11112.trc:
ORA-10459: cannot start media recovery on standby database; conflicting state detected
Slave exiting with ORA-10459 exception
Errors in file /local/pb/oracle/admin/diag/rdbms/tpbp_mcc/TPBP1/trace/TPBP1_pr00_11112.trc:
ORA-10459: cannot start media recovery on standby database; conflicting state detected
Recovery Slave PR00 previously exited with exception 10459
MRP0: Background Media Recovery process shutdown (TPBP1)

 

Changes

The server machine with a physical standby database went down due to an operating system issue.  The server was then brought up and an attempt was made to start the standby recovery.

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
References


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