Re: What do others do for database file mounts

If you can swing it, a separate volume for FRA/backups, preferably on separate storage media (disks) might be good, too. It's never good to be in the position where a single storage failure (or a single human error) can destroy both your datafiles and your backups.

On Fri, Feb 13, 2015 at 2:57 PM, Michael Cunningham < napacunningham_at_gmail.com> wrote:

> NetApp is my favorite because of the reliability I've experienced. Here is
> how I've configured before.
>
> My environment used NFS.
> 1 volume for the datafiles named /DB_UNIQUE_NAME/datafiles
> 1 volume for archive log files name /DB_UNIQUE_NAMEarch/arch
> 1 volume for redo logs /redologs/DB_UNIQUE_NAME
>
> This setup was nice because I could restore a snapshot of /DB_UNIQUE_NAME
> only (not /DB_UNIQUE_NAMEarch) and then roll forward using the archive log
> files in /DB_UNIQUE_NAMEarch.
>
> Redologs duplexed to local disk also.
>
> I did not use data fabric manager. We wrote our own scripts to perform
> snapshot backups and we were able to clone databases in 2 minutes
> (regardless of size).
>
> recommendations would be to make sure there are enough disks on the
> datafile aggregate/volume to support the IOPS you need. I used SSD for both
> datafile and redologs volumes. I also had to put SSD in the local server
> because that is where my redolog bottleneck was located. It turned out that
> writing redologs to the filer was faster than writing to the local disk -
> SSD fixed it.
>
> On Fri, Feb 13, 2015 at 9: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
>>
>
>
>
> --
> Michael Cunningham
>

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