Re: file placement and SAN

On Wed, 24 Apr 2002 12:52:54 GMT, spamdump_at_nospam.noway.nohow (Ed Stevens) wrote:

>Our sever admin just informed me that future server upgrade plans call for the
>use of a SAN. Other than knowing what the acronymn SAN stands for, this is
>totally unknown territory for me. Particulary in light of the current
>discussioni on placement of indexes vs. data tables (separate data/index) I'd
>like to ask if anyone has any knowledge/experience with SAN, and what I should
>be looking to do with it.
>
>Our current standard configuration is an NT server with 'n' number of internally
>mounted disks of the size de jour. Two of the drives are paired into a mirror
>set (Raid-1) and the remainder are placed in a single stripe set (Raid-5).
>
>The server admin carves an 8-gb partition (C:) drive out of the mirror set for
>the OS, and a 4-gb partition ( D:) from the stripe set for the Oracle software.
>
>The remainder of the mirror set is put in a single partition (F:) with dedicated
>subdirectories for things like archive log files, backups, exports, redo.
>
>The remainder of the mirror set is put in a single partition (E:) with dedicated
>subdirectories for control files, rollback, and tablespaces.
>
>This entire arrangement is essentially the compromise we arrived at when we were
>first learning Oracle at 7.3 and our readings of the OFA publications available
>at that time -- primarily Loney's Oracle DBA Handbook, v7.3, and a white paper
>that translated that philosophy to a specifically NT environment.
>
>I would like to take this opportunity to approach this SAN with fresh thinking,
>a 'green field' opportunity, rather than simply migrating current practice. My
>primary goals for new standards would be performance, followed (very, very
>closely) by flexibility and the ability to adjust and adapt.

Evidently we have here the frequent problem of system administrators not cooperating with DBAs. The first thing you should do is check out whether Oracle supports using a SAN for your platform *at all* (and IIRC there a pretty few vendors they support for SUN, and for NT it might be not supported at all, as Oracle also can not deal properly with networked drives)

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 24 2002 - 11:43:27 CDT