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 JUNE 27, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Standby database is configured as RAC.
- The server machine with a physical standby database went down due to an operating system issue.
- After the servers were finally brought up, all attempts to start the MRP process failed with below error .
ORA-10459 "cannot start media recovery on standby database; conflicting state detected":
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 |