Hello, I know that there are many different ways that a database can be set up with regards to RAID levels but what i have found is that you get told what disks you have available and then try to work around it.
Our infrastructure guys want to move my 2 of my databases from the storage they are on. ISCSI drives on the SAN to free up some space.
They have offered me
2 sets of local mirrored pairs of disks on the server and potentially some RAID 5 on the SAN for datafiles and RAID 10 for logs.
Now,
The local disks are big so it is a shame to not use the space.
Would the following work ok do you think?
Option 1
Mirrored Pair 1 : (C: Drive (Windows and Oracle Binaries) + Redo Logs
Mirrored Pair 2 ( Data Files and Archive Logs)
Can we have Redo Logs on the same drive as the O/S without potential performance problems? There isn't massive activity on these databases. Generally only 0.6 log switches per hour (Usually there is a peak of activity for a few hours, perhaps 6 log switches each hour and then only 1 or 2 for the remaining hours in the day. 50MB size redo logs.
I presume having archive logs on the same as the data files storage with the low amount of log switching shouldn't be a performance problem.
Option 2 (Not keen as these are disks with a few hundred GB but would only be having a few hundred MB used
Mirrored Pair 1 : (C: Drive (Windows and Oracle Binaries) + Archive Logs
Mirrored Pair 2 : Redo Logs
SAN RAID 5 - Data Files
The info i have found is that Archive/Redo Logs should be on RAID 1.
Datafiles should be on RAID 10, if not RAID 5 or RAID 1
Any advice as to what to do based on what i have available to me?
Thanks