RE: Mutliplexing control/redo files

From: <Joel.Patterson_at_crowley.com>
Date: Fri, 8 Oct 2010 09:53:10 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA05CED146_at_JAXMSG01.crowley.com>



I've been wondering about this but don't really get specifics.  

I finally decided 'right'. Put 'em together so I went like this  

/orasoft mount point for all software

/oradata/SID1/allDB1files

/oradata/SID2/allDB2files

/oradata/SID3/allDB3files

...

etc.  

As for organizational clarity... beauty is in the eye of the beholder. As for deleting your files... oh if that can happen, it can happen on any configuration.  

Just havn't got past this. As for putting another mount point on admin or $ORACLE_BASE/'diag' for large tracing... it seems that if oracle cannot write to the alert log, then the db stops anyway so I havn't been able to absorb that concept completely yet.

Joel Patterson
Database Administrator
904 727-2546


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rodd Holman Sent: Wednesday, October 06, 2010 11:30 AM To: oracle-l_at_freelists.org
Subject: Re: Mutliplexing control/redo files  

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_at_dcso.nashville.org> 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

 


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 08 2010 - 08:53:10 CDT

Original text of this message