Ann, If you have all archivelog files since the creation of that problematic datafile you can use the following procedure to restore it: http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov006.htm#sthref753 PS: I hope it's 10G because for 9i procedures a tad different 8-) --romas On Tue, Sep 23, 2008 at 9:04 PM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote: > Hello Gurus, > > My fellow team member has unknowingly added a datafile of the same name in > different mount point and now the database looks having two datafile names > which are identical and located in different mount points. We are taking > hot-backups and the file got overwritten as both file names were common. > when we refreshed and checked for v$datafile for status='RECOVER' we observe > the datafile is missing. Is there a way we can get this rectified as user > needs the restore and recovery of 15 days old backup. Could you please > suggest and help as backup tar ball is overwritten file and prod database > has two identical named datafiles.. > > Thanks, > Ann >