Re: Problem in refresh
Date: Sat, 27 Sep 2008 10:54:21 +0530
Thanks everyone for all your excellent support an ideas.
There was a request from DEV team to restore and recover the previous requested backup and that has become useless due to overwritten of the same index datafile. Also the production backup was also corrupted and fortunately we were safe as we noticed in prior.
As Jared said, we will look into the script and put a check if that particular database has duplicate datafiles on different mount points while backup is running and alert back us.
For now the issue is resolved as dev team were ok in having the latest backups clone.
Thanks again for all your kind support and suggestion.
On Sat, Sep 27, 2008 at 1:09 AM, Jared Still <jkstill_at_gmail.com> wrote:
> That post was a bit terse, my apologies.
> I was just firing off a quick reply before I had to check out of my
> hotel and head to the airport.
> There is a problem in your backup procedures. Having files with the
> same name in different paths should not normally be.problem.
> Your backup procedures need to be reviewed, or the problem will occur.
> On 9/26/08, Jared Still <jkstill_at_gmail.com> wrote:
> > 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) <shastry17_at_gmail.com>
> >> Hello Gurus,
> >> My fellow team member has unknowingly added a datafile of the same name
> >> different mount point and now the database looks having two datafile
> >> 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
> >> 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
> >> has two identical named datafiles..
> >> Thanks,
> >> Ann
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> Sent from Gmail for mobile | mobile.google.com
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist