RE: LOG_ARCHIVE_DEST and NFS

Two years ago we ran into a problem with export files being stored to an NFS mount, one of the export files was corrupt.  

Oracle at the time advised us to avoid NFS mounts, they did not support any NFS implementations from operating system vendors, including HP, Digital, Sun. They also did not support NFS over TCP, which is offered by some
(perhaps all, I never checked that).
 

They did support some 3rd party NFS implementations, but these are expensive solutions.  

In the end we realized we should just ensure that there was enough disk space to stage the export files before archiving them.  

I suspect if you ask Oracle now about storing archived logs over NFS, you will get a similar answer.  

Do you want to risk corrupting your archived logs by storing them on NFS mounts? (being paranoid is a good thing when you're a DBA).  

Do a quick search in Metalink (perhaps even in google) to see what comes up for "archived logs NFS"

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-----Original Message-----
Sent: Wednesday, August 14, 2002 8:48 AM To: Multiple recipients of list ORACLE-L

Hello to everyone!  

In order to duplicate archived logs to other machine, I have to add new log_archive_dest parameter, which points to NFS mount point. No, I can't avoid that...  

I would like to hear bad stories, good stories, rants, recomendations, tricks'n'tips... about nfs combined with oracle.  

NFS uses UDP protocol, which is stateless (or it was stateless when I learnt about it). Is there any way to make NFS to use TCP protocol?  

Sun Solaris, Oracle 8i EE.  

Remote file systemis on Linux.  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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