| 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
I suppose I should come clean on this deal and admit that we do indeed have Oracle duplex the redo files. The only time we would not do this is if some user with sufficient bureaucratic power has some suckwad app and was demanding that everything be done to bump up performance. If it comes to that, we'll do it and not lose any sleep over it. Even though we have Oracle duplexing, we still have had it happen that some storage array maintenance person went in and managed to hose up both sides of the duplex. Of course, this doesn't result in the loss of the database, but rather the loss of some data. But wasn't it fun debate.
What I found interesting was that nobody brought up what to do about the archived logs -- how much mirroring is "enough" and how long to wait before shoving them off onto tape. Now, the loss of these babies can get you into deep doodoo. But, here again, we must sometimes make compromises for the sake of a rotten application and overtaxed hardware. At our shop here, we are forced to rely on hardware mirroring of archives. We have no choice.
You just try to get as many people to sign off on the setup as you can.
None of this changes the truth of anything I wrote. I have found hardware
and software mirroring to be extremely reliable. I have never lost a file
to it, and it has saved my butt many times. At one place I worked, we
regularly tested yanking out power cords, I/O cables, storage array drawers,
anything we could think of, while the database and application were running
full blast. It never failed once (except for early Veritas on Motorola 88K
which was a mess).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: slee_at_dollar.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 Wed Nov 27 2002 - 01:18:41 CST
 |
 |