Re: Summary: Oracle and Disk Mirroring
Date: 21 Jul 1994 21:39:06 -0400
Message-ID: <30n7vq$ieg_at_search01.news.aol.com>
For my $00.02 (US), I've been testing RAID5 versus RAID0/JBOD on a box here, and this is not at all atypical:
create 2Gb tablespace, on raw partition on JBOD half of RAID box: 15 mins
or so max
create 1Gb tablespace,RAID5/UNIX filesystem half of same box: 1 hr 38
minutes
Considering ORACLE (especially 7's) extensive recovery facilities, I'm recommending we go with JBOD entirely, using Oracle to mirror key internal files. If they can reconfig our RAID box to the smallest possible amount of RAID5 disks vs JBOD, I'd also use the RAID5 to stage our redo logs prior to dumping them to tape.
Other than that, from what I've seen so far, not a chance. For a supercritical system, I'd use disk mirroring for everything, but right now I can't afford to take a 43 Gb box and halve that.
Email me for more diatribes. er, experiences.
R. (Scott) Hunter shunter_at_cfotax.attmail.com Database Administrator
AT&T Tax Services, Financial Services Organization, AT&T Corporation
Received on Fri Jul 22 1994 - 03:39:06 CEST