| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: redo log file setup with mirrored drives
Ditto.
The biggest problem with non-Oracle-mirrored redo log is a personnel issue.
Take it from someone who's experienced a SA deleting all files from a 500 Gig DW during the middle of the day.
Jared
"Fink, Dan" <Dan.Fink_at_mdx.com>
Sent by: root_at_fatcity.com
11/26/2002 08:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: redo log file setup with mirrored drives
"Pending further evidence to the contrary, I'll take mirroring external to Oracle as the better choice."
Redo and archived redo logs are the most important files in the database. Lose a datafile? You can still recover the database. Lose all controlfiles? They can be recreated. Lose a single redo entry? Your recovery is terminated. Yes, there are unsupported methods to bypass this condition, but they are kludges and may be very, very expensive.
So, why do I still multiplex my redo logs (even on my 'test' Win2k
databases
at home)? O/S level mirroring protects against some failures, but it does
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 (usually with
a
separate controller), saved the database.
Considering the small size of the redo logs and their critical importance
to
the database, I'll both multiplex (oracle) and mirror (o/s).
"1. This is pure speculation."
Kirti is one of the many people on this list who has shown time and time
again that he does not engage in "pure speculation". While a skeptical
attitude is good and helps you develop, I tend to accept Kirti's posts
(and
Cary's, Tim's, Jared's, Robert's, and others on the 10 list) at face value
until I put together a test case and can prove it or disprove it.
Dan Fink
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
INET: Dan.Fink_at_mdx.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.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). Received on Tue Nov 26 2002 - 11:49:57 CST
 |
 |