Re: Mutliplexing control/redo files
- From: przemolicc@xxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 7 Oct 2010 09:42:54 +0200
What does it mean "large db" ?
Did you do performance tests how your db would perform on ZFS filesystem ?
ZFS is memory hungry (if not tuned ...) and there are far less knowledge
about Oracle+ZFS then Oracle+VxFS/UFS.
Regards
Przemek
On Wed, Oct 06, 2010 at 10:29:57AM -0500, Rodd Holman wrote:
> I am also going through a re-architect process for my large db. We are
> looking at Solaris/ZFS for file systems. Solaris is using the zpool
> method which effectively creates the same disk ambiguity to oracle that
> a SAN, NAS, or SAME would. Like Andrew, I use separate folders for
> organization clarity. I am setting up my layout as follows:
>
> /u01/oradata/SID/system (all the base db tablespaces, undo, and temp
> that get installed when you do the base install (controlfile goes here))
> /u01/oradata/SID/dbf (users01.dbf and any other application tablespaces)
> /u01/oradata/SID/redo (obvious)
> /u01/oradata/SID/archive (also obvious)
> /var/opt/oracle (oratab file, oraInv.loc file, and multiplexed control
> file.) This is a separate mirrored pair from the zpool. A similar
> Windows construct would be to put a directory under C: and store a
> controlfile there as well.
>
> This doesn't provide and real protection or additional security, it just
> organizes the db files so that anyone coming into the system (We have
> consultants and other DBA's that are not as familiar with this db as I)
> can quickly figure out what is where.
>
> The real mount volume (zfs mount point) is at the /u01/oradata/SID level
>
>
> In a Windows environment I would substitute D: (or what ever drive you
> mount at) for the /u01 and go from there.
>
> --Rodd Holman
>
> On 10/06/2010 09:35 AM, Andrew Kerber wrote:
>> I like to use different folders because it helps to protect against
>> user error. Other than that, there is no difference.
>>
>> On Wed, Oct 6, 2010 at 9:02 AM, Storey, Robert (DCSO)
>> <RStorey@xxxxxxxxxxxxxxxxxx <mailto:RStorey@xxxxxxxxxxxxxxxxxx>> wrote:
>>
>> Does having a multiplex control file, with copies in separate
>> folders any different that having copies all in the same folder?
>>
>> Thanks
>>
>> --
>> Andrew W. Kerber
>
----------------------------------------------------------------------
Jak placic mniejsze rachunki za telefon?
Sprawdz >> http://linkint.pl/f281c
--
//www.freelists.org/webpage/oracle-l
Other related posts:
