Re: Question in HOT BACKUP

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 5 Oct 2004 10:37:16 +0100
Message-ID: <7765c89704100502373f3baa7f@mail.gmail.com>

On Mon, 4 Oct 2004 21:02:35 -0700, Jared Still <jkstill_at_gmail.com> wrote:
> On Mon, 4 Oct 2004 14:00:00 -0400, Bobak, Mark
> <mark.bobak_at_il.proquest.com> wrote:
> >
> > My favorite argument is:
> > Please describe a valid backup/recovery scenario where a backup
> > copy of on-line redo is required to succeed. (Hint, there
> > isn't one!)
> >
>
> Personally, there have been a few occasions where I have been
> very happy to have copies of the online logs.
>
> For instance: someone sent me 200G of cold backup tape, but the
> database was not being shutdown cleanly. The online logs were
> needed of course. The folks at the other end would not own up
> to the bad shutdowns until I lifted the relevant bits of the alert.log
> and emailed it to the other "DBA" and the project managers.
>
> I was thankful for his poor backup practice of backing up the logs,
> it saved us a bit of work.

An interesting counter to the describe a valid backup/recovery scenario argument.

We have an invalid backup/recovery scenario and in that case it is useful to follow bad practice.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 05 2004 - 04:32:47 CDT