Re: oracle binaries and datafiles

I use separate mounts because I use SAN technology for some of my clones (EBS). I do not always need to clone the binaries. Having them on a separate lun lets my skip reconfiguring the database binaries every time.

--
Michael Brown
dba_at_michael-brown.org <mailto:dba_at_michael-brown.org>
http://blog.michael-brown.org



> On Mar 28, 2018, at 3:52 PM, Rich J <rjoralist3_at_society.servebeer.com <mailto:rjoralist3_at_society.servebeer.com>> wrote:

> 

> On 2018/03/28 14:34, Jeffrey Beckstrom wrote:


> 

>> We are migrating to Linux. We are planning on storing the Oracle binaries and datafiles on the same mount point. Should we rethink this and separate them. The mount point points to a SAN if that matters.


>  

> How often do you need to modify anything in $ORACLE_HOME versus the path(s) where the datafiles are stored?  Files in $ORACLE_HOME/dbs could be updated regularly.  Modifications to datafiles will hopefully be never, or rare if an older version needs a file moved.  Putting datafiles in the same relative path as files that need manual attention adds risk of accidents.  Even the latest OFA suggests separating them:  https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwlin/optimal-flexible-architecture-file-path-examples.html <https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwlin/optimal-flexible-architecture-file-path-examples.html>


>  

> My vote is to separate them, not just on mount point, but the top-level directory.

>  

> Rich



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