Database Recovery

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.

You need the archivelogs If you do not have them, you are in big troubles

Can I just bring the database up without the archive logs. Please help. I know there will be data loss.

what did you do to get into this state in the first place (and dont say you just shutdown the database)

Did you re-create the control file in NOARCHIVELOG mode?

What happenned was 2 datafiles got deleted while users were cleaning up the directory (this is at remote site). The local IT tried to restart the server and found that the database was not coming up. By the time They reported to me this was what I saw and I did the following...now I am stuck...I did not create control file on non archive.

Appreciate your help.

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

Your message says

Code:

---

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.

Please connect as sysdba using SQL Plus and issue
archive log list
Put the output here
Issue
select file#,name,CHECKPOINT_CHANGE#,status from v$datafile
where status='RECOVER'
and put the results here
Issue
select CHECKPOINT_CHANGE# from v$database
and put the results here

Then we will know where we are and what the options are

Regards