Re: What do others do for database file mounts

Unless the mounts you are receiving from the storage have different performance characteristics, there is little advantage in segregating the file types.

*I know Oracle stands firm that best practices are to segregate these files into separate mounts.*

Although this was the standard pre-10g, OFA and the Fast Recovery Area would contradict this statement. I would suggest one mount for datafiles, and another for the FRA. Using the FRA for backups, archive logs, flashback logs and redo logs dramatically reduces the work for the DBA. Multiplex the control file and archive logs across both mount points.

Seth Miller

On Fri, Feb 13, 2015 at 11:13 AM, Cohen, Andrew M. <Andrew.Cohen_at_tufts.edu> wrote:

> Hello List,
>
>
>
> We are moving to Fibre Channel connections with all of our storage on a
> Net App storage unit. One of the questions we got from our system admins
> was if we could limit the number of mounts that they provide us for out
> datafiles. With the newer disk technology that we all use, is it still
> important to segregate mounts for redo, CFs, datafiles, Archive logs, etc?
> I know Oracle stands firm that best practices are to segregate these files
> into separate mounts. I’m wondering what others do and if there is a
> compelling reason to continue this practice?
>
>
>
> Thanks,
>
> Andy
>

--
http://www.freelists.org/webpage/oracle-l