Re: Question in HOT BACKUP

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Tue, 5 Oct 2004 10:37:16 +0100

On Mon, 4 Oct 2004 21:02:35 -0700, Jared Still <jkstill@xxxxxxxxx> wrote:
> On Mon, 4 Oct 2004 14:00:00 -0400, Bobak, Mark
> <mark.bobak@xxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts: