Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

datafile 1 belongs to an orphan incarnation error in standby database

hi experts,

I checked the consistency of our standby database by switching it to primary. I issued command ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE; and ALTER DATABASE OPEN;. I have successfully loged on to that server and have checkedthe data. Now, when i'm going to tunr it back to its standby state. Here's what I've done:

SQL> shutdown immediate;

SQL> startup nomount;

SQL> alter database mount standby database;

Then it said that control files are not standby control files. So i created a standby control file in the main server and copied those files to the standby in their proper location.

I issued alter database mount standby database again and it successfully altered. But when I'm applying the redolog files, i'm getting error: ORA-19909 datafile 1 belongs to an orphan incarnation and it points the datafile. I've checked on RMAN on main and standby but both are sync with the incarnation list. What could be the problem?

Thank you in advance!

Not what you were looking for? View more on this topic or Ask a question