ORA-01203: wrong incarnation of this file

Asked By darinmicky 210 points N/A Posted on - 07/18/2011

Hi,

A few days before, tablespaces were dropped by users in Oracle databases. I have backup for these tablespaces. I need to restore these tablespaces in Oracle databases.But during the restore I was 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:OracledataMIKE1.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:Oracledata' and drop the mike1.dbf data files and paste the backup data files 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:ORACLEDATAMIKE1.DBF'
ora-01203: wrong incarnation of this file – wrong creation SCN

How to resolve this problem? Is this method correct?

Thanks.

Status: Open
Question Views: 3442
Answer Count: 1
Vote Up 0 Vote Down

Answer Accepted: No
Question Category: Oracle Database

Answered By madandba 0 points N/A #84903