RE: Mirroring redo log groups or not ?

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mark W. Farnham
Sent: Tuesday, April 07, 2009 7:04 PM
To: david.barbour1@xxxxxxxxx; Jon.Crisler@xxxxxxx
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@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: