Database Recovery

[Thomasps]

First of all you need to be careful while a recovery.

Your message says

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
*

Datafile 54 need recovery and you are recovring datafile 34? Why?

What happened to your archive log files? What is the current archive mode?

Check the files in C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_25.