RE: redo log file setup with mirrored drives

Precisely why I name all Oracle files with ".dbf" extension. Who ever thought naming a redo log with ".log" was a good idea??? With all DB files the same, it's a simple rule: Don't touch .dbf files. No confusion there. If you need to mess with them (backups, etc), write and test a script. Try to prevent yourself from making a mistake.

"If at first you don't succeed, you had better be in test."

My $.02,
Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Fink, Dan [mailto:Dan.Fink_at_mdx.com]
> Sent: Tuesday, November 26, 2002 10:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: redo log file setup with mirrored drives
>

[snip]

> not protect against the accidental deletion of the file. I
> have had to deal
> with situations where people deleted the redo logs (disk
> space at 90%, let's
> clear out the log files...). Another copy on another device

[snip]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).