Unable to make datafile online - ORA-01190: control file or data file 11 is from before the last RES
Unable to make datafile online, giving following error :
SQL> alter database datafile '/u02/oradata/ATTST/attst_data6.dbf' online;
alter database datafile '/u02/oradata/ATTST/attst_data6.dbf' online
*
ERROR at line 1:
ORA-01190: control file or data file 11 is from before the last RESETLOGS
ORA-01110: data file 11: '/u02/oradata/ATTST/attst_data6.dbf'
SQL> select fuzzy, status, error, recover, checkpoint_change#, checkpoint_time, count(*) from v$datafile_header group by fuzzy, status, error, recover, checkpoint_change#, checkpoint_time ;
FUZ STATUS ERROR
--- ------- -----------------------------------------------------------------
REC CHECKPOINT_CHANGE# CHECKPOIN COUNT(*)
--- ------------------ --------- ----------
YES ONLINE
NO 699655215 04-FEB-20 20