RE: Mirroring redo log groups or not ?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 7 Apr 2009 19:04:09 -0400
Message-ID: <7A8E9CC14F1D4135AECA28537F131D32_at_rsiz.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Barbour
Sent: Tuesday, April 07, 2009 2:22 PM
To: Jon.Crisler_at_usi.com
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>  

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

Received on Tue Apr 07 2009 - 18:04:09 CDT