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 :)
