Home » RDBMS Server » Backup & Recovery » ORA-01203: wrong incarnation of this file - wrong creation SCN (Oracle,10g,Linux)
ORA-01203: wrong incarnation of this file - wrong creation SCN [message #392690] Wed, 18 March 2009 22:47 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member


Hi,

Before a days, tablespaces dropped by users in oracle databases. i have backup for this tablespaces. i need to restored this tablespaces in oracle databases.But during the restore i am getting ORA-01203: wrong incarnation of this file - wrong creation SCN error file.I have explained below what i did.



1)sqlplus system/password@sachin

SQL>CREATE TABLESPACE MIKE
LOGGING
DATAFILE 'C:\Oracle\data\MIKE1.DBF' SIZE 20M
REUSE AUTOEXTEND
ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM
SIZE 200K SEGMENT SPACE MANAGEMENT AUTO;

tablespace created.

SQL>ALTER TABLESPACE MIKE OFFLINE;

SQL>EXIT

2) enter into the OS path 'C:\Oracle\data\' and drop the mike1.dbf datafiles and paste the backup datafiles with same name


3)sqlplus system/password@sachin

SQL>ALTER TABLESPACE MIKE ONLINE;

ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: 'C:\ORACLE\DATA\MIKE1.DBF'
ORA-01203: wrong incarnation of this file - wrong creation SCN


how to resolve this problem?
Is this method is correct?

Thanks,
Michael
Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #392692 is a reply to message #392690] Wed, 18 March 2009 23:02 Go to previous messageGo to next message
BlackSwan
Messages: 22800
Registered: January 2009
Senior Member
>Is this method is correct?
NO, which is why it did not work.

>how to resolve this problem?
It depends upon what kind of backups were done.
Ideally you do a Point In Time Recovery,
but I suspect you will be prevented from doing so.

Post script which does your backups.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #392702 is a reply to message #392690] Thu, 19 March 2009 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do that, you have to restore your backup as a new database, export the content of the tablespace and reimport it in your new tablespace in the previous database.

Regards
Michel
Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #392874 is a reply to message #392690] Thu, 19 March 2009 09:26 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
Hi,

ORA-01203: wrong incarnation of this file - wrong creation SCN
Cause: The creation SCN in the file header is not the same as the creation SCN in the control file. This is probably a copy of a file that was dropped.
Action: Restore a current copy of the data file and do recovery as needed.

The problem is when and how you do the backup of the datafile.

Regards,
Alex

[Updated on: Thu, 19 March 2009 09:46] by Moderator

Report message to a moderator

Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #393954 is a reply to message #392690] Wed, 25 March 2009 03:32 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,

Could you please let me know is your DB is at archivelog or noarchivelog mode.

Pokhraj
icon13.gif  Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #513720 is a reply to message #392690] Wed, 29 June 2011 02:53 Go to previous messageGo to next message
Omario
Messages: 3
Registered: June 2011
Junior Member
I understand in 1 second what holdingbe has tried and failed at: He lost a tablespace and tries to recover it by copying DBF file on OS level and then try to restore so the database picks it up again, kind of unofficial/hacked import if you like.

What bothers me is that I have the same challenge I need to restore a plain DBF file to a table space, and all comments on any forum or what have you are: No you can't do that, no you're doing it wrong, but noone cares to even try to explain how to do it the proper way. He knows he's doing it wrong, he allready knows it don't work, he has the error messages to prove it.

Give us something to work with instead of repeating the error in other wordings. What good does that for anyone? GRRRRR Mad

YEAH restore your backup, YEAH restore current copy, NOOOO maybe we do not have any.... NOOOO maybe we want to try to do it differently YES we want to know if it is even possible!
Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #513723 is a reply to message #513720] Wed, 29 June 2011 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Omario wrote on Wed, 29 June 2011 09:53
...Give us something to work with instead of repeating the error in other wordings. What good does that for anyone? GRRRRR Mad
...


Maybe you didn't read carefully the answers:

Michel Cadot wrote on Thu, 19 March 2009 06:29
You can't do that, you have to restore your backup as a new database, export the content of the tablespace and reimport it in your new tablespace in the previous database.
...


If this is not the plan of what you have to do, what is it?

Regards
Michel


[Updated on: Wed, 29 June 2011 03:03]

Report message to a moderator

Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #513741 is a reply to message #513723] Wed, 29 June 2011 04:03 Go to previous messageGo to next message
Omario
Messages: 3
Registered: June 2011
Junior Member
Soz, I'll try to be 100% precise and specific Embarassed ;

Original Q: Is there a way you can restore data and/or tablespace IF you only have a DBF file? Is it possible?

So:

1. No I don't want to restore a backup (we have it but its just one table we want, not whole database)
2. I cannot export tablespace because table we need is allready overwritten, makes no sense at all
3. We do however have a DBF file -NO CONTROL FILE AND NO DUMP HOWEVER- with the 'good' table data in it.

Ty! Was little frustrated by answers so far.
Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #513745 is a reply to message #513741] Wed, 29 June 2011 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But the answer is there: "You can't do that".
If you have ONLY a dbf file, you have to call Oracle to get back your data. They have a tool to read the file and convert it to INSERT statements. Of course, this will cost you an arm and a leg.

Regards
Michel
Re: ORA-01203: wrong incarnation of this file - wrong creation SCN [message #513749 is a reply to message #513745] Wed, 29 June 2011 04:57 Go to previous message
Omario
Messages: 3
Registered: June 2011
Junior Member
Thank you, hope that wasn't too hard Cool
Previous Topic: Difference crosscheck command
Next Topic: Script to save users/privs before cloning
Goto Forum:
  


Current Time: Mon Sep 22 15:49:49 CDT 2014

Total time taken to generate the page: 0.09220 seconds