From oracle-l-bounce@freelists.org Thu Oct 6 12:34:34 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j96HYN0K014316 for ; Thu, 6 Oct 2005 12:34:33 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j96HY7vX014240 for ; Thu, 6 Oct 2005 12:34:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A743D1F4FB1; Thu, 6 Oct 2005 12:33:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08387-01; Thu, 6 Oct 2005 12:33:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 269B41F4C45; Thu, 6 Oct 2005 12:33:10 -0500 (EST) X-IronPort-AV: i="3.97,182,1125896400"; d="scan'208"; a="35253743:sNHT20464388" X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: 10.2 locations for Admin and Oradata directories Date: Thu, 6 Oct 2005 12:31:05 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: 10.2 locations for Admin and Oradata directories Thread-Index: AcXKl5HkI0h6n0cBSM2N2tQjcbrXigAAyHPA From: "Jesse, Rich" To: , Cc: X-OriginalArrivalTime: 06 Oct 2005 17:31:06.0361 (UTC) FILETIME=[BB73FE90:01C5CA9B] X-archive-position: 26477 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rich.Jesse@quadtechworld.com Precedence: normal Reply-To: Rich.Jesse@quadtechworld.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 I should have stated that differently. Yes, I hope we can all agree that a different MP for the database is usually a good thing. But what I had meant was our database mount point is not in the $ORACLE_BASE tree. e.g.: MYDB;/opt/oracle> df -k Filesystem kbytes used avail capacity Mounted on /dev/vx/dsk/opt 5039406 157625 4831387 4% /opt /dev/vx/dsk/orabin_vol/ora_binaries 6291456 3358952 2909656 54% /opt/oracle /dev/vx/dsk/oradb_vol/mydb_vol 12582912 6112920 6419456 49% /oracle/mydb /dev/vx/dsk/oradb_vol/redo2_vol 512000 154828 351600 31% /oracle/mydb/redologs2 /dev/vx/dsk/orabin_vol/control1_vol 1048576 6672 1033776 1% /oracle/mydb/control1 /dev/vx/dsk/orabin_vol/archive_vol 5242880 67536 5134984 2% /oracle/mydb/archive /dev/vx/dsk/oradb_vol/redo1_vol 512000 154820 351608 31% /oracle/mydb/redologs1 /dev/vx/dsk/orabin_vol/control2_vol 1048576 6672 1033776 1% /oracle/mydb/control2 Other than that, OFA all the way, baby! :) Rich -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of David Sharples Sent: Thursday, October 06, 2005 12:00 PM To: Rodd.Holman@gmail.com Cc: oracle-l@freelists.org Subject: Re: 10.2 locations for Admin and Oradata directories reading the ofa paper now, nowhere can I see it say put the data on the same mount point as the software [quote] Intuition tells most installers that Oracle database files should be separated from other files on a system. There are concrete reasons for doing so, among which: database files' lifespans differ from all other files on your system; and database files will require a different backup strategy than the other files on your system. A thoughtful naming strategy for database files eliminates a whole class of administrative problems. [/quote] On 10/6/05, Rodd Holman wrote: Our datafile location (/oradata) is never mounted under $ORACLE_BASE. Keeps them nice and tidy in their own little/large playground. -- http://www.freelists.org/webpage/oracle-l