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 = http://www.EvDBT.com/ 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> > > > -- > //www.freelists.org/webpage/oracle-l > > > > > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l