Storage Allocation Help for 9i Cluster

From: Neil Boemio <neil.boemio_at_gecapital.com>
Date: 8 Feb 2002 08:24:17 -0800
Message-ID: <9dfce6cc.0202080824.6162d09a@posting.google.com>

We will be setting up a 2 node cluster (Win 2000 and 9i Real Application Clusters) with 2 Compaq 4100 arrays. Each array has 12 36GB drives. We plan on using RAID0+1 on each array (so 6 drives mirrored on each array).

Our database is currently about 30GB. We generate about 4GB of archive log files each night. During the day, operations are primarily read. At night we have batch jobs that do a lot of the writing.

Can anyone suggest the best way to partition our arrays for storage and spare storage? I was thinking to start as follows:

Array 1 (6 drives free - 216GB)

22GB of data datafiles

leaves 194 GB free

Array 1 (6 drives free - 216GB)

8GB of index datafiles
20MB of on-line log files
4GB (varies) of archive log files

leaves approximately 203 GB free

So do I allocate 1 partition of Array 1 to be say, 100GB and the rest allocated as a spare partition? Or do I even need to allocate a spare partition? Can I just use the whole array?

Same for Array 2 ... can I just use the whole array or do I need to allocate spare partitions? Received on Fri Feb 08 2002 - 10:24:17 CST