Re: Physical layout of a DB in RAC environment

Roman Klesel wrote:

> Dear DBAs,
>
> from what I have learned one should keep things seperate in an
> produktive Oracle DB:
>
> online redologs:
> on 2 different dedicated physical disks (raid sets), groups swiching
> from one disk to another
>
> archive logs:
> on another dedicated disk (raid set)
>
> datafiles for undo/redo TSP on RAID 1
> datafiles for temp TSP on RAID 1
>
> other dataflies on RAID 5
>
> controlfiles 3 all on different physical disks.
>
>
> Now I'm confronted with a setup where all data is stored in a T1 storage
> system which internally does a RAID 5. Everything in this storage is
> software mirrored in another T1.
>
> Both RAC nodes use this storage system for all oracle relevant files
> redologs, archivelogs, controlfiles ...
>
> Plus the shadow DB uses this storage system for all its files too.
>
> Everything is connect through fiberchannel switches.
>
> Is this insane? Or does it just look mad to me? Or is this the modern
> way of doing things?
>
> Can you please comment on this!
>
> Greetings Roman

It works just fine. Let the SAN or NAS handle the problem. Once you've written to the head ... the rest can just be ignored.

With RAW we got rid of file systems. With 10g even the volume management can go away. It is a brave new world ... every 5 years or so.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)