RE: Mirroring redo log groups or not ?

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <david.barbour1@xxxxxxxxx>, <Jon.Crisler@xxxxxxx>
  • Date: Tue, 7 Apr 2009 19:04:09 -0400

There is no protocol that can protect you from human error by someone with
authority to remove an online log file.

 

I'd actually be surprised if there was someone dumb enough to remove active
online logs and not anal enough to remove all the copies. But we'll never
know, because you're positing that the folks who removed single member log
groups would have been saved by multiple members. Unless you have a time
machine, you cannot test that.

 

Regards,

 

mwf

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of David Barbour
Sent: Tuesday, April 07, 2009 2:22 PM
To: Jon.Crisler@xxxxxxx
Cc: Rajeev Prabhakar; Oracle-L Freelists
Subject: Re: Mirroring redo log groups or not ?

 

Mirroring protects you from more than disk failure, it also protects you
from human error.  Please, mirror your logs.  There is a long history
littered with un-employed DBAs backing this recommendation.

<snip>

 

Other related posts: