Dear Gurus
i recreatyed teh control file and opebned the database by issuing teh recover database command. While recreating the control file i user noresetlogs and noarchivelog options.
The database opened but now when i query the database it gives some data files missing.
one example is

ORA-00376: file 121 cannot be read at this time
ORA -01111: name for datafile 121 is unknown - rename to correct file
ORA -01110: datafile 121 : 'MISSING0121'

I want to know how will i know the name of the correct datafile .
Since i have just recreated the control file the data files are intact but why is this error coming .

A solution is appreciated

Regards
Shadab



----- Original Message -----
From: Shadab Mehboob
To: LazyDBA Discussion
Sent: Tuesday, May 08, 2007 6:46 PM
Subject: error in recreating control file


Hi Gurus
I want to change teh location of my database files which i do by recreating the controlfile to trace.
i recreate the .trc file by issuing teh command
SVRMGR> alter database backup controlfile to trace
.
The .trc file created i modify the location of the database files to a different directory.
When i run the .trc file it shows and error
ORA -1503 CREATE CONTROL FILE FAILED
ORA-01565 error in identifying file 'database22/moving/idx_log_history'
ora-7360 : sfifi: stat error , unable to obtain information about file

when i see this file in my database it is not present.
I want to knwo why does the .trc fil contain db files not present n the database.
ALso would anyone help me out how to recreate the control fiel in this case.

Regards
Shadab

Oracle LazyDBA home page