From oracle-l-bounce@freelists.org Mon Oct 31 12:47:56 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9VIlk8L002518 for ; Mon, 31 Oct 2005 12:47:56 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9VIlOvX002464 for ; Mon, 31 Oct 2005 12:47:30 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 917E721380B; Mon, 31 Oct 2005 13:47:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11136-10; Mon, 31 Oct 2005 13:47:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 142792137FB; Mon, 31 Oct 2005 13:47:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 31 Oct 2005 13:45:21 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 15A24213807 for ; Mon, 31 Oct 2005 13:45:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10941-07 for ; Mon, 31 Oct 2005 13:45:21 -0500 (EST) Received: from smtprelay04.ispgateway.de (smtprelay04.ispgateway.de [80.67.18.16]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 91DD92137F0 for ; Mon, 31 Oct 2005 13:45:20 -0500 (EST) Received: (qmail 6374 invoked from network); 31 Oct 2005 18:45:18 -0000 Received: from unknown (HELO [192.168.2.5]) (515854?@[84.175.83.206]) (envelope-sender ) by smtprelay04.ispgateway.de (qmail-ldap-1.03) with SMTP for ; 31 Oct 2005 18:45:18 -0000 Message-ID: <4366658C.7040005@eichenlaub.net> Date: Mon, 31 Oct 2005 19:42:20 +0100 From: Stephan Eichenlaub User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: DGoulet@vicr.com Cc: oracle-l@freelists.org Subject: Re: FW:NFS issues References: <4001DEAF7DF9BD498B58B45051FBEA6502E09E95@25exch1.vicorpower.vicr.com> In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502E09E95@25exch1.vicorpower.vicr.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-archive-position: 27853 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: stephan@eichenlaub.net Precedence: normal Reply-To: stephan@eichenlaub.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=5.0 tests=BAYES_00 autolearn=ham version=2.63 Goulet, Dick wrote: > > Yes we can write files on the NFS mount, and the syslogs have > nothing in them. But the DB sure is having a pile of fun with it. > Alter log says it's creating the archive log, but nothing shows up and > the db just hangs. I've seen similar problems while writing secondary archivelogs on a nfs mount. Once in a blue moon (about once or twice per month actually) the file just contained a few bytes at the start and then nulls till the end, size being the same size as the primary archivelog file. Despite investigation we never found the real reason but everyone we asked recommended to stay away from nfs. Nowadays we're just writing archivelogs to the machine oracle is running on. Then we're copying them at system level with rsync and a 20 minutes delay to make sure the archivelogs are really really fully written and not changed anymore. rsync called in a cron job running every 10 minutes. Works smoothly. (With rsync the delay could probably be shortened down to a minute or so as it just copies the file again if changed but 20 minutes delay is ok for us.) That the db hangs might stem from your configuration: Do you force oracle to write the archivedlog (MANDATORY)? It makes sense to enforce writing of at least one archivelog destination but only when you can assure that at least one destination DOES work. Else the database will hang, as you just experienced. Disclaimer: If I'm wrong concerning newer versions, don't whack me. My knowledge is taken from 8.1.7 Stephan -- http://www.freelists.org/webpage/oracle-l