ORA-19909: Datafile 1 belongs to an orphan incarnation

ORA-19909: Datafile 1 belongs to an orphan incarnation

 Applies to: 

Oracle Database 10gR2

Description:

I have faced the error ORA-19909 while creating physical standby database through RMAN backup. When start recovery MRP process terminated with error.After doing some research work I found the following solution:

Solution:

After some research I have found the following solution:

The Problem occurs because the Primary Database has different incarnation with standby database.

On the Primary site:

Set environment

> rman  target /

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       PROD     143178490        PARENT  5988067599851 02-OCT-10

2       2       PROD     143178490        CURRENT 5988067601797 02-OCT-10

  

On the Standby site:

> rman  target /

RMAN> list incarnation

2> ;

using target database control file instead of recovery catalog

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       PROD     143178490        PARENT  5988067599851 02-OCT-10

2       2       PROD     143178490        PARENT  5988067601797 02-OCT-10

3       3       PROD     143178490        CURRENT 3755054101457 11-MAY-11

RMAN> reset database to incarnation 2;

RMAN> exit

Now start recover and monitor alert log file. MRP process started successfully and recovers the archive log files.

Your comments, especially which will help us improve the functionality, will be greatly appreciated :)