I want to install a fairly small db (15GB) on a dell server.
The machine has local disk storage with 8disks of 300 GB configured at RAID 10.
The array is made of 8 disks mirrored (4 active and 4 mirrors).
We are installing a couple of virtual machines (RHEL and WINDOWS server2008) using VMware.
I am trying to decide on how to install oracle software and databases:
Here is what i am thinking but i am open to better ideas.
1) Keep the disks at RAID 10 and not reconfigure it for RAID 1 for other temp or log files.
2) Seprate disks for applications (Red hat linux and windows application)
Use 6 physical disks for oracle/linux and 2 disks for crystal reports server and other windows applications.
3) for oracle I want to separate disks as follows:
3a) Use 1 disk for oracle software install. This is where oracle database software and oracle HTTP server/web server software is installed.
3b) Use 1 disk for all database files (data files, control files, online redo logs).
3c) Use 1 disk for flashback area (flashback recovery files, backup files, archive redo log files, multiplexed files, etc.)
1) Do you think this is a good layout for storage or not? If not what would you change.
I understand that using RAID 10 is expensive in terms of storage but we can afford that since we have enough storage and probably clean up files every 2 weeks. basically it is not worth it to reconfigure some disks to RAID 1.
2) When I use oracle installer to install oracle sofware and DBCA to create databases
can i select each disk and directory i want it installed per the above layout.