Re: Using backup files with new DB

From: joel garry <joel-garry_at_home.com>
Date: 17 Nov 2006 14:25:43 -0800
Message-ID: <1163802343.621066.127680@h54g2000cwb.googlegroups.com>

Wolf Grossi wrote:
> joel garry wrote:
> > Wolf Grossi wrote:
> >> joel garry wrote:
> >>> Wolf Grossi wrote:
> >>>
> >>>> No archived logs were saved and no oracle support.
> >>> Past time to reevaluate your priorities.
> >>>
> >> What u mean?
> >>
> >
> > You need to have support and a proper, tested, backup and restore
> > methodology in place before you need them. Very basic administrative
> > principles. We've seen a lot of posts here over the years where people
> > haven't adhered to those principles, and quite often it is a conscious
> > decision not to bother with them because of the perceived cost.
> > Sometimes it's even worse, a poor prioritization of the the types of
> > things that can (read: will) go wrong - like not realizing that
> > depending on a super-duper storage device means a single point of
> > failure, or thinking oracle database files are just flat things you can
> > access any way you please.
> >
> > It is a management decision to prioritize how much their data is worth.
> > There are some amazingly bad decisions out there, by people who really
> > ought to know better. Don't be offended, you appear to be suffering
> > the results of such a situation. Just sayin', so maybe you can make
> > things better.

> lol :-)
> U do not understand the original question:
> I was askin 'how can I recover ...'
> and *not* 'how can I prevent...'

>

Glad you have a good sense of humor!

There is a reason it is called RMAN - Recovery Manager.

Backups are not the point, recovery is. Prevention, no recovery needed at all, is the best recovery. Short of that, the answer to 'how can I recover' is, be fully prepared to recover.

I only just ran across this:
http://www.rittman.net/2006/11/15/wheres-everything-gone/

His ISP never tested their backups, and symlinked all mysql database files to a different place than the default backup script looks... then reformatted the disk where the files were.

This interesting unfinished piece about recovering a mysterious set of db files just appeared: http://www.dizwell.com/prod/node/399

--
@home.com is bogus.
'there will probably never be "a language", "a universal solution" for
all 
problems.' - Tom Kyte

Received on Fri Nov 17 2006 - 16:25:43 CST