Re: Oracle and SAN

John Wood wrote:
> Hi there,
>
> We are using Oracle 9i R2 on Window2K. We are planning to use SAN box for
> the database. It seems to me that the use of SAN may contradict what has
> been recommanded from Oracle, say separation of database files, redo log
> files, archived log files and the RMAN backup files.
>
> I am not familiar with SAN setup. I think it can be partitioned into many
> logical drives and each logical drive may have their own RAID configuration.
> I hope some one can give me a heads up what and how to configure the SAN.
> Or some link to get more info on setting up Oracle database on SAN box.
>
> Thanks.
>
> JW

There is nothing generic about a SAN that contradicts anything Oracle has said about storeage. Developing an optimum storage strategy is not trivial and involves understanding how the application will access disk. Thus it is not something easily written about in a quick usenet post.

Suffice it to say the number of physical disks, the number of LUNs, zoning of switches, and the use of LVMs can be the difference between super-sonic and glacial. To help you more on-line we will need a lot of information and as I stated this is likely not the correct medium.

Feel free to contact me off-line.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)