RE: Datafiles on NFS mount

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Tue, 24 Oct 2000 16:54:36 -0400
Message-Id: <10659.120102@fatcity.com>

I see that it's not supported. Well, ours was just a development database, so no harm if it died. I've since mothballed it anyway.

Sorry if my post encouraged anyone to use NFS mounts. ;-)

Diana

-----Original Message-----
From: Diana Duncan [mailto:Diana_at_filefrenzy.com] Sent: Tuesday, October 24, 2000 3:46 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Datafiles on NFS mount

Hi,

This works just fine for us, with the following caveats:

The NFS mounts must be performed before the database is brought up after a reboot.
You cannot do a backup controlfile to trace onto the NFS mounted drive - it runs forever.

Reboots would be a problem, if your database is open and you reboot the machine owning the drives you are using. We haven't had that happen.

Diana

-----Original Message-----
Sent: Tuesday, October 24, 2000 2:00 PM
To: Multiple recipients of list ORACLE-L

Hello,

Is Oracle 8.1.6 capable of creating and using a datafile on an NFS-mounted disk on another machine? We have two Sun machines (OS block size is 8k on both); the machine running Oracle is short on disk, while there is plenty available on the second machine. We are planning to purchase another larger machine, but in the meantime would like to get by for a short period without investing more in the present machines. We are not using hot backups (it's a small datawarehouse). What problems occur when either of the machines is rebooted?

Thanks to any responders.
beckerb_at_dgabby.mfldclin.edu
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bill Becker
INET: beckerb_at_mfldclin.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Diana Duncan
INET: Diana_at_fileFRENZY.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------