PROBLEM:

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

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 4 failed verification check
ORA-01110: data file 4: '+B2BCMDB/BMCW/undotbs201.dbf'
ORA-01203: wrong incarnation of this file - wrong creation SCN

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 '+B2BWMDB/WMBPRE/undotbs201.dbf' offline drop;

Database altered.

SQL> alter database open;

Database altered.