Hi Jordan, Thanks for your reply. You are right. However, I do have the original datafiles on disk. Its just that the first time they were not included in the controlfle. I cannot do it right now but will this work: Suppose I recreate the controlfile, this time with the missing files Then, when it asks for an archivelog to apply for recovery (since there are new files now), I can use the existing redo log to recover. I have done this in the past in a slightly different situation where I had to recreate the controlfile when some files were missed out. It works. Maybe I will give it a go. In the meanwhile, if you have another hunch, do let me know. Thanks, Kanwar On Fri, 29 Jun 2007 07:58:32 am you wrote: > In my opinion you can not recover from this. I have done this several > times in the past(even today) and have not seen any way to restore the > files. The problem is that when you recreate the control file you must > do a "alter database open resetlogs". Once this is done any previous > backups are invalid. > > I could be wrong but I really don't think this can be fixed without > restore the entire database again. You could drop the Tablespace used by > the missing data files and recreate it. Then do a export/import of the > data from production. > > > > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kanwar Plaha > Sent: Thursday, June 28, 2007 5:36 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Missing datafiles > > Hi, > A database was copied from another one and the controlfile to create it > missed out couple of datafiles. > The database now has missing datafiles listed in it. > Also, the fact that some datafiles are missing was not known until a few > days when some changes to the > database have taken place. > My question is if its possible to 'restore' the database now? I can see > the missing datafiles on disk although > with an older timestamp than the ones that are online. > The database is in NOARCHIVELOG mode. However I checked v$log and found > that since database build, no > log switch has happened yet. Does this means shutting the database down > and recreating the controlfile > with the missing datafiles can bring the database to a consistent state? > Can it use the current redo log for > recovery, if required? > > This is rather urgent, although not critical since its not a production > environment. > > Thank you, > Kanwar > -- > //www.freelists.org/webpage/oracle-l > > > "Notice of Confidentiality" The information contained in this e-mail > message is intended for the use of the individual or entity named above. > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution, or copy of the > communication is strictly prohibited. > > "Notice of Confidentiality" The information contained in this e-mail > message is intended for the use of the individual or entity named above. > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution, or copy of the > communication is strictly prohibited. > > > > > > > > > > > -- //www.freelists.org/webpage/oracle-l