Re: Oracle on EMC Question

It is recommend that datafile and redo file is separate disk.

example)

/app/oracle -- Oracle software
/u01 -- datafiles
/u02 -- index datafiles
/r01, /r02, /r03 -- redo log files
/c01, /c02, /c03 --controlfiles

this is a proper way.. may be..
if you are system administrator, determine volume group and logical volume,filesystem
But You must locate a different volume group for datafiles and redo logfiles.
The volume group for datafile need striping and mirroring (RAID 0+1),possible
But volume group for redo logfile neet not striping, just mirroring..

It is a carelessness idea that placed all the datafiles in one directory

--
                    /////
                    (^_^)
+---oOO---------------------------------------+
|   libre
|   Email : libre_at_cyberlogitec.com  (Official)
|           libre_kr_at_yahoo.co.kr      (Free)
|           libre_kr_at_hotmail.com    (Free,MSN)
|           libre_kr_at_hanmail.net    (Free)
|           gosmdochi               (AOL)
+---------------------------------oOO---------+
                   |__|__|
                   |__|__|
                    || ||
                   ooO Ooo

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message
news:50f3ec07c83864c0ad4c0d4fd885487f.38849_at_mygate.mailgate.org...
> We are migrating our Oracle/IBM AIX database to an EMC disk array.  Our
> DBA has placed all the datafiles in one directory (mount point) on the
> EMC array.  He maintains that this is necessary with EMC, and the proper
> way to do it, given the caching that EMC does.
>
> Can someone verify that this is the case?  Our DBA has been known to cut
> corners in the past, so I would like a little peer review of this.
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG