ORA-01203: wrong incarnation of this file
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.
SQL>CREATE TABLESPACE MIKE
DATAFILE 'C:OracledataMIKE1.DBF' SIZE 20M
ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM
SIZE 200K SEGMENT SPACE MANAGEMENT AUTO;
SQL>ALTER TABLESPACE MIKE OFFLINE;
2) Enter into the OS path 'C:Oracledata' and drop the mike1.dbf data files and paste the backup data files with same name
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?