Re: [Spam SpamAssassin=6,49] Re: Inheriting a "interesting" recovery process

Good morning,

Oh, the British and their politeness. Sigh. But you're right, Nigel, and you usually are.

RMAN is the way to go these days. What very few people realise is that it has been recommended in popular pop music for decades.

It's true.

Remember ABBA?

Remember their hit Gimme, Gimme, Gimme? Ever listened carefully to it?

The chorus (recently re-used by Madonna in Hung Up, which is her song about Oracle Support) goes like this:

Gimme, Gimme, Gimme
RMan after midnight
Won't somebody help me
Chase the shadows away
(repeated a couple of times)

Mogens

Niall Litchfield wrote:

> absolutely correct. Mogens comment about disabling archiving is
> probably not something I'd have said, but he is correct that if you
> lose your database (or bits of it) then you won't be able to recover,
> you'd have to create a new db and import.
>
> What I'd have suggested, and indeed have done in my new position, is
> that you write immediately to the business owners, and cc your bosses
> pointing out that currently they could lose a whole days worth of work
> and that you can fix it really quite quickly by implementing a new
> backup regime. As you are on quite a recent release of Oracle I'd
> suggest you skip the whole 'BEGIN ...END BACKUP' thing and go straight
> to Recovery Manager (or RMAN). You can of course read about it in the
> docs and indeed at
> http://www.oracle-base.com/articles/9i/RecoveryManager9i.php though
> you'll want to skip the cataog for now.

--
http://www.freelists.org/webpage/oracle-l