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>

Follow-Ups:

RE: Mirroring redo log groups or not ?
From: Hemant K Chitale

RE: Mirroring redo log groups or not ?
From: Kenneth Naim

References:
- Re: database monitoring tools - what is your short list of
  - From: Yong Huang
- Nasty RAC Bug in 10g. If you are running multi-nodes and one instance or more is not normally running - Read this...
  - From: Robert Freeman
- Re: Nasty RAC Bug in 10g. If you are running multi-nodes and one instance or more is not normally running - Read this...
  - From: Ravi Gaur
- Mirroring redo log groups or not ?
  - From: Crisler, Jon
- Re: Mirroring redo log groups or not ?
  - From: Rajeev Prabhakar
- RE: Mirroring redo log groups or not ?
  - From: Crisler, Jon
- Re: Mirroring redo log groups or not ?
  - From: David Barbour

RE: Mirroring redo log groups or not ?

Other related posts: