Re: I have a clarification

Scary stuff

NFS mounting tablespaces or any other database file that may affect your integrity is not a great thing to do. NFS is UDP not TCP therefore there is no checking to see that packets passed from one server to the other are ever received. Your database has probably come up with that tablespace offline as it was unable to locate the .dbf file. The other possibility is that your SA set up the mount using automount and as such the filesystem on the Linux system was mounted at the time that you requested it. You may see something in your Oracle logs and if it couldn't get the mount then you System log may also show something if all is not quite as it seems.

Next go to your supplier for your Sun hardware and purchase another disk. Good luck and the good grace of your god or gods will only save you from data corruption.

HTH Peter

At 08:35 PM 11/07/2001, you wrote:
>Hi Gurus,
>
>We have an Oracle 8i database running under Solris 5.6. I have
>production databases running on that. Due to space problem I have
>created tablespace for which the physical datafiles are pointing to a
>different linux Server thru NFSMount.
>
>If in case the solaris has to be shutdowned next time i will issue the
>NFS command to get access to the Linux server files.
>
>Now my doubt is Due to some problem Solaris machine was shutdown and
>next time it came up we did not NFS mount to the linux server. I started
>Oracle and i had absolutely no problem in bringing the database up. How
>come this could be possible? when my datafiles are in different server
>on which my tablespace is based upon.
>
>Can anyone please give me clarification for this.
>
>Regards
>Sundar
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rangachari Sundar
> INET: sundar_at_focusite.com
>
>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: Peter McLarty
  INET: peter.mclarty_at_incts.com

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