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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).