Hi,

Database failed to restart and the following message appeared;

Database mounted.
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
1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_25\O1_MF_1_
112724_%U_.ARC
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.

Thanks.