Re: Problem in refresh

From: Jared Still <>
Date: Fri, 26 Sep 2008 09:49:19 -0700
Message-ID: <>

As it has not yet been mentioned, I will say it now:

Fix your backup procedures.

On Tue, Sep 23, 2008 at 6:04 PM, Shastry(DBA) <> 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

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Fri Sep 26 2008 - 11:49:19 CDT

Original text of this message