RE: Datafiles on NFS mount

Hi,

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

1. The NFS mounts must be performed before the database is brought up after a reboot.
2. 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-----
From: Bill Becker [mailto:beckerb_at_mfldclin.edu] Sent: Tuesday, October 24, 2000 2:00 PM
To: Multiple recipients of list ORACLE-L Subject: Datafiles on NFS mount

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).