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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Fink, Dan [mailto:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).