Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wrong incarnation of this file - wrong creation SCN

674481Oct 21 2010 — edited Nov 12 2010

We currently have a media recovery problem, and the problem seems not to get resolved.

System is Solaris 10 on a 64bits Sparc with 10.2.4 Oracle database.

Problem:
Can't recover from backup and archivelog fiiles.

We ran "alter database recover" and we got database altered and we open the database. But when query datafile table, the datafile (datafile 14) was still in recovered mode - I don't know how that happed.

Next, drop tablespace, inlucuding contents and added a new tablespace and the database opened again without error. But this time we still need the data from the old datafile.

We tried to add the old datafile to the tablespace, then we got "Wrong incarnation of this file - wrong creation SCN".

Where do we go from here?

This post has been answered by Dude! on Oct 23 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2010

Added on Oct 21 2010

#general-database-discussions

53 comments

10,093 views