RE: Mirroring redo log groups or not ?

From: Kenneth Naim <kennaim_at_gmail.com>
Date: Tue, 7 Apr 2009 19:49:41 -0400
Message-ID: <2403F44F954B400E9BD5A16C39BF69F8_at_KenPC>

I've had an admin "cleanup" a filesystem that was filling up by removing all *.log files, since the other redo file were on separate filesystems we were protected and so was his job. We also name our redo logs with a .ora extension now.  

Ken  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham
Sent: Tuesday, April 07, 2009 7:04 PM
To: david.barbour1_at_gmail.com; Jon.Crisler_at_usi.com Cc: 'Rajeev Prabhakar'; 'Oracle-L Freelists' Subject: RE: Mirroring redo log groups or not ?  

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:49:41 CDT