RE: Mirroring redo log groups or not ?

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <tim@xxxxxxxxx>, <hkchital@xxxxxxxxxxxxxx>
  • Date: Tue, 7 Apr 2009 20:26:01 -0400

Here! Here!

Tim is quite right to encourage naming that says "Do not remove me." or even
"DO NOT REMOVE ME." That protocol will reduce the chances of automated error
and raise (lower?) the bar of stupidity required to manually remove redo
logs that are in use.

My point is simply that the person who deletes *.rdo will probably do it on
all the drives.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Tim Gorman
Sent: Tuesday, April 07, 2009 7:52 PM
To: hkchital@xxxxxxxxxxxxxx
Cc: mwf@xxxxxxxx; david.barbour1@xxxxxxxxx; Jon.Crisler@xxxxxxx; 'Rajeev
Prabhakar'; 'Oracle-L Freelists'
Subject: Re: Mirroring redo log groups or not ?

One situation I've witnessed....

A lot of people create the online redo log files with the file-extension 
of ".log".  A lot of SysAdmins have a "cron"-initiated script that 
removes files named ".txt", ".log", ".lst", etc that are older than N 
days old from certain file-systems, or sometimes when a file-system is 
filling up someone will run a "find" command to find big text files 
(i.e. ".log" is a good candidate) and get rid of them.  Put the two 
together and you've got the perfect storm.

For my part, I always use the file-extension of ".rdo" or just plain old 
".dbf", but never ".log".  Of course, someone can still remove files 
with those extensions, but I feel the probability is smaller...

Tim Gorman
consultant - Evergreen Database Technologies, Inc.
P.O. Box 630791, Highlands Ranch CO  80163-0791
website   =
email     = Tim@xxxxxxxxx
mobile    = +1-303-885-4526
fax       = +1-303-484-3608
Yahoo IM  = tim_evdbt

Hemant K Chitale wrote:
> VERY TRUE.  I've never bought the argument that mirroring online redo logs
is a protection from DBA error.
> ---  wrote:
> There is no protocol that can protect you from human error bysomeone with
> authority to remove an online log file.
> <snip>
> --
> //


Other related posts: