RE: Configuration of the SAN

So many possibilities, but I'll try to avoid my usual book.

Two quick thoughts:

1. You bemoan "waste" in the lost acreage. One thing you can do with some of that acreage is more redo groups. If you want to maintain the ping-pong of arch versus lgwr, add them at the proper point in rotation and set them up odds and evens. This allows arch to fall farther behind in a burst before you gate and allows longer recovery within the online space without having to reference the archive destination.
2. If you consider the price for your SAN drives and really could live effectively with 4 or 8 GB total, you might want to consider solid state drives rated for survival in abrupt power outages. (I only feel comfortable with sufficient on board tested battery power to make two independent copies of the memory contents to two separate on board disks when an outage is detected. You want to be sure this exceeds the reliability of your technology stack to your SAN.) In addition to probably being price competitive and a whole lot faster, this will remove commit writes to the redo from the race for SAN cache. If your management software allows you to set up writing to the archives *NOT* through the cache, then you avoid polluting the SAN's cache with write once traffic.

Good luck.

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Luc Demanche Sent: Tuesday, March 29, 2005 11:41 AM
To: oracle-l_at_freelists.org
Subject: Configuration of the SAN

Hi,

We are trying to do a good configuration of our SAN. Let's see that exemple.

EMC, with disk of 146G.
- one LUN of RAID-5 for data (4+1 disks = 534G)

• one LUN of RAID-5 for index (4+1 disks = 534G)

Here is my question, about redo logs
- one LUN of RAID-1 for redo group 1 (2 disks mirroired = 146G)

• one LUN of RAID-1 for redo group 2 (2 disks mirroired = 146G)
• one LUN of RAID-1 for my archived log files (2 disks mirroired = 146G)

I will have a filesystem of 146G to store my redo group of 2G .... what a waste.
Same thing for my redo group 2 and my archived log files ...

What is your LUN configuration regardinf redo log groups and archived log files ?

Thank you

--
Luc Demanche
Oracle DBA
(514) 867-9977
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l