Questions on RAID-0 and RAID-0+1 considerations

Hi, all:

We have a new SUN Ultra Server with 30 2GB external disks. This is for an OLTP Oracle 7.1.6 database. We like to use mix RAID-0 and RAID-0+1 for all Oracle datafiles. Here is our initial setup:

1. 4 disks use RAID-0 for redo logs. This will have 2 mount points: one for three redo groups, export dump files and the other one is for the mirroring members of redo logs. Since RAID-0 is stripping only so we can have maximum write throughput and second mount point will serve as mirror to against disk failure.

Question is, would it be better if we use 6 non RAID disks and put three redo logs and their three mirror members into separated disk?

B. 26 disks use RAID-0+1 for rest datafiles, archives and backup directory. We will have 5 mount points:

1. Archive and backup directory
2. SYSTEM, TOOLS, and Control file 1
3. RBS tablespaces, and control file 2
4. DATA tablespaces, and Control file 3
5. INDEXES, TEMP, and USERS tablespaces.

Question here is, is it better if we use one mount point for all or use more mount points to slicing the tablespaces into more separated file system?

Thanks in advance!

Qun

qun.li_at_attws.com Received on Mon May 19 1997 - 00:00:00 CDT