RE: How to organize oracle directories in Unix ?

As long as your mount points are not sharing disks from the same volume group you are correct. However, its expensive to write to RAID 5 which is why you will usually see raid 0+1 instead.

-----Original Message-----
Sent: Sunday, September 09, 2001 7:55 AM To: Multiple recipients of list ORACLE-L

Hi Joe,

What's your configuration ? Raid 1 ?
How do U organize the oracle directories ?

Correct me if I am wrong. I thought though I use Raid 5 but with different mount points, I will not have contention problems For example
One mount point for data files
Another mount point for index files.

Please advise. Thanks.

Regds,
New Bee
-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 09/09/2001 8:30 PM

if u dont know the underlying striping and someone else built the filesystes, then the point is moot, you might as well have one logical disk, since you cant reallt guarantee where something is going to end up anyways.

with all of the raid5 stuff(that evryone likes so much anymore), we as DBAs dont have control over where stuff is, so a good backup/recovery plan is a must, at least in the old days when a physical device was mapped to a filesystem(pre-logical volume days), we could handle making sure of duplexing redo logs, etc.

joe
"CHAN Chor Ling Catherine (CSC)" wrote:
>
> Hi Guru,
>
> How do you organize your oracle directories in Unix ?
>
> I am thinking of using the configurations below. We are using Raid 5
with
> various mount points.
>
> \dg1\oracle => contains Oracle Human Resources software applications
and
> oracle home .eg. sidappl, sidcomn, sidora
>
> \dg2\oracle => contains redo log file and control file eg. sidredo &
sidctrl
>
> \dg3\oracle => contains redo log file and control file eg. sidredo &
sidctrl
>
> \dg4\oracle => contains redo log file and control file eg. sidredo &
sidctrl
>
> \dg5\oracle => system tablespace file and temp tablespace data file
.eg.
> siddata
> \dg6\oracle => data file and rollback segment data file .eg. siddata
> \dg7\oracle => index file eg. sididx
> \dg8\oracle => archive log file .eg. sidarc
>
> Is there any disadvantage if I put the redo log file and control file
in
> different directories but in the same mount point ?
>
> Is there any disadvantage if I put the rollback segment data file
together
> with my data file in the same directory ?
>
> Is there any disadvantage if I put the tablespace data file together
with my
> temp tablespace data file in the same directory ?
>
> TIA
>
> Regds,
> New Bee

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: kimberly.smith_at_gmd.fujitsu.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).