Re: Mirroring redo log groups or not ?

From: Tim Gorman <>
Date: Tue, 07 Apr 2009 17:51:58 -0600
Message-ID: <>

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     =
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>
> --

Received on Tue Apr 07 2009 - 18:51:58 CDT

Original text of this message