Hi all,
We are running Oracle 9i (OLTP) on Win2003 Server.
We are about to move our data from single server to SAN.
Since everything on the SAN gets striped accross all the drives, does
it still make sence to multiplex control files and redo logs?
What if volume has double parity drives?
Someone is already running 9i on windows on SAN?
What is your configuration, if you don't mind to share?

Thanks,
Eugene

On 28 Sep 2005 16:26:37 -0700, epipko@gmail.com wrote:

>Since everything on the SAN gets striped accross all the drives, does
>it still make sence to multiplex control files and redo logs?

It only doesn't make sense, if you admit no humanoids to the server,
capable of deleting a file.

--
Sybrand Bakker, Senior Oracle DBA

epipko@gmail.com wrote:
>
> Hi all,
> We are running Oracle 9i (OLTP) on Win2003 Server.
> We are about to move our data from single server to SAN.
> Since everything on the SAN gets striped accross all the drives, does
> it still make sence to multiplex control files and redo logs?
> What if volume has double parity drives?
> Someone is already running 9i on windows on SAN?
> What is your configuration, if you don't mind to share?
>
> Thanks,
> Eugene

Its primarily about peace of mind...

If rely on the SAN for redundancy then you are exposed to

a) loss of a redo log due to human error
b) corruption of a redo log

(b) is very rare in my experience and only you can quantify (a)
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

epipko@gmail.com wrote:
> Hi all,
> We are running Oracle 9i (OLTP) on Win2003 Server.
> We are about to move our data from single server to SAN.
> Since everything on the SAN gets striped accross all the drives, does
> it still make sence to multiplex control files and redo logs?
> What if volume has double parity drives?
> Someone is already running 9i on windows on SAN?
> What is your configuration, if you don't mind to share?
>
> Thanks,
> Eugene
>

I would still multiplex and if possible over different controllers. If
one controller goes down, you still have the other. It also protects
against accidentally deleting the only copy of a critical file.

- --
To reply by email remove "_nospam"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)

iEYEARECAAYFAkM8EAcACgkQzIf+rZpn0oTVawCdFGWq/IofZ/+bBBQ9ydWd5bTw
8/QAn1IEga4Y18KDuj1aFOu2SPIPtlyb
=+/DZ
-----END PGP SIGNATURE-----

epipko@gmail.com wrote:
> Hi all,
> We are running Oracle 9i (OLTP) on Win2003 Server.
> We are about to move our data from single server to SAN.
> Since everything on the SAN gets striped accross all the drives, does
> it still make sence to multiplex control files and redo logs?
> What if volume has double parity drives?
> Someone is already running 9i on windows on SAN?
> What is your configuration, if you don't mind to share?
>
> Thanks,
> Eugene

Absolutely multiplex.

First because it has taken you more effort to write this post than
it could possibly take to multiplex control files and redo logs.

Second because you are making assumptions that will, almost by
definition, lead to bad performance.

Just because you have a SAN does not mean you have 1 LUN, does not
mean you have one HBA card with one channel, and most certainly
should not mean you have a single unzoned switch.

If you set up the SAN with 1 switch, 1 HBA channel, and 1 LUN you
will have just wasted tens of thousands of dollars.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)