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: [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).
