Database failed to restart and the following message appeared;
ORA-01113: file 54 needs media recovery
ORA-01110: data file 54: 'D:\ORADATA\CMG_01.DBF'
I did the following and this is what i got:
SQL> alter database recover datafile 34;
alter database recover datafile 34
ERROR at line 1:
ORA-00279: change 923435034 generated at 01/24/2007 18:39:52 needed for thread
ORA-00289: suggestion :
ORA-00280: change 923435034 for thread 1 is in sequence #112724
I have no clue on how to handle this, how can I recover the database? There are no archive log files in place. Please advise.