OraFAQ Forum: Backup & Recovery » ORA-01203: wrong incarnation of this file

Home » RDBMS Server » Backup & Recovery » ORA-01203: wrong incarnation of this file - wrong creation SCN (Oracle,10g,Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01203: wrong incarnation of this file - wrong creation SCN [message #392690]

Wed, 18 March 2009 22:47

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

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

Michel Cadot
Messages: 68641
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

Report message to a moderator

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

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

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

Report message to a moderator

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

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!

Report message to a moderator

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

Michel Cadot
Messages: 68641
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
...

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68641
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

Report message to a moderator

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

Omario
Messages: 3
Registered: June 2011

Junior Member

Thank you, hope that wasn't too hard Cool

Report message to a moderator

Previous Topic:	Difference crosscheck command
Next Topic:	Script to save users/privs before cloning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 01:02:53 CDT 2024