| Fresh install [message #493994] |
Thu, 10 February 2011 14:23  |
Tr0cken
Messages: 22
Registered: August 2010
|
Junior Member |
|
|
Hi all,
I'm about to install a new DB Server. Oracle 11G Standard on RHEL5. The storage available are 6 146Gb SAS 15k disks. The server is hardware RAID capable.
What would it be the best configuration regarding RAIDs and separation of SO, DB engine, tables, indexes, redologs, etc?
Thanks in advance.
[Updated on: Thu, 10 February 2011 14:27] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Fresh install [message #494198 is a reply to message #493996] |
Fri, 11 February 2011 13:56  |
Tr0cken
Messages: 22
Registered: August 2010
|
Junior Member |
|
|
Thank you for your answers.
My main concern right now is performance.
So lets say I make a hardware RAID 0+1 array with all of the disks (400GB total available) and then:
Partition Mount Point File system Size
/dev/sda1 /boot ext3 150 MB
/dev/sda2 swap swap 16 GB
/dev/mapper/vg_root/lv_root / ext3 15 GB
/dev/mapper/vg_root/lv_var /var ext3 10 GB
/dev/mapper/vg_root/lv_tmp /tmp ext3 10 GB
/dev/mapper/vg_root/lv_u01 /u01 ext3 15 GB Oracle Engine
/dev/sdc1 /u02 ext3 20 GB - System datafiles/Temp
/dev/sdd1 /u03 ext3 200 GB - Tables/Indexes
/dev/sde1 /u04 ext3 512 MB - Redo logs
/dev/sdf1 /u05 ext3 512 MB - Redo logs
/dev/sdg1 /u06 ext3 512 MB - Redo logs
/dev/sdh1 /u07 ext3 30 GB - Archive logs
/dev/sdi1 /u08 ext3 100 GB - Data pump, etc
Would this be a good practice? Do you recomend separating something further or differently?
Thank you very much.
|
|
|
|
| Re: Fresh install [message #494200 is a reply to message #494198] |
Fri, 11 February 2011 14:23 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
If your disk under these file systems are RAID 0+1, it does not matter (from performances point of view) how you put them at OS level, you can use a single file system (or 2 one short stripe for redo logs and large stripe for data files).
The best way is to use ASM and let Oracle manages this point.
Regards
Michel
[Updated on: Fri, 11 February 2011 14:24] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
