Re: LOG_ARCHIVE_DEST and NFS

On 2002.08.14 07:48 Vladimir Barac wrote:
> 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.
>
>

Having archives go to an NFS mounted directory, where backup server is, is a standard trick and nothing particularly risky. A decent backup server is still a better solution. The problem is the fact that the NFS server can, quite unpredictably, go offline and then, your database is stuck. The solution is to use log_archive_dest_n parameter in conjunction with log_archive_dest_state_n parameter which a) defines state, so you can take care of the offline destinations and b) uses Oracle*Net, so that you can send archives to another node without the NFS.

Cajoling NFS into using TCP is, allegedly, possible, but I've never seen it done. I even tried it unsuccessfully on 2 SUN E450 machines after reading the NFS3 specification document, but it wouldn't work. I suspect that about the only thing you can do is to re-write NFS yourself.

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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