My Oracle Support Banner

MRP0 Process on Cascading Standby Database Is Stppped After Converting to Snapshot Standby By ORA-19909 ORA-1110 (Doc ID 2654140.1)

Last updated on JUNE 27, 2021

Applies to:

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

Symptoms

This problem happnens on following configuration.

    Primary Database => (redo transport) => Standby Database => (redo transport) => Cascading Standby Database

When converting a Standby Database into a Snapshot Standby Database, MRP0 process on Cascading Standby Database is stopped due to ORA-19909/ORA-1110.

<< alert.log on a Cascading Standby Database)>>
2020-02-07T16:37:27.082588+09:00
Managed Standby Recovery starting Real Time Apply
Warning: Recovery target destination is in a sibling branch
of the controlfile checkpoint. Recovery will only recover
changes to datafiles.
MRP0: Detected orphaned datafiles!
Recovery will possibly be retried after flashback...
2020-02-07T16:37:27.098824+09:00
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: datafile 1: '<directory>/system01.dbf'
Managed Standby Recovery not using Real Time Apply
2020-02-07T16:37:28.206171+09:00
Recovery Slave PR00 previously exited with exception 19909
2020-02-07T16:37:28.206823+09:00
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: datafile 1: '<directory>/system01.dbf'
2020-02-07T16:37:48.212190+09:00
MRP0: Background Media Recovery process shutdown (<db_unique_name>)

Changes

A Standby Datbase is converted into a Snapshot Standby Database.

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.