ORA-01203: Wrong Incarnation Of This File – Wrong Creation SCN - Learnomate Technologies

Wakad : +919325408926 Icon

kalewadi : +918983069523 Icon

kharadi : +919325408926

Kiran Dalvi
14 Dec, 2023
0 Comments
1 Min Read

ORA-01203: Wrong Incarnation Of This File – Wrong Creation SCN

PROBLEM:

While opening a database, getting the error, ORA-01203: wrong incarnation of this file.

SOLUTION:

To fix this, either you have to restore that datafile from latest backup or drop the datafile if it doesn’t contain any valuable data.

In my case, the issue was with undo datafile, so I dropped the same.

SQL> alter database datafile '+DATA /WMBPRE/undotbs201.dbf' offline drop;

Database altered.

SQL> alter database open;

Database altered.