ORA-01203: wrong incarnation of this file

Asked By 210 points N/A Posted on -
qa-featured

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.

 

SHARE
Answered By 0 points N/A #84903

ORA-01203: wrong incarnation of this file

qa-featured

The File that was restored does not  match with the SCN  in the controlfile. Possible issue could be the creation  SCN in the file header is different from the creation SCN in the controlfile ,as the file that was restored from the backup is no more a valid backup since the incarnation of database took place after the backup.  Solution is to restore a file from a backup that was taken after the incarnation of database .

Related Questions