From oracle-l-bounce@freelists.org Thu Dec 16 10:05:34 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iBGG5XV18519 for ; Thu, 16 Dec 2004 10:05:33 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iBGG5RN18493 for ; Thu, 16 Dec 2004 10:05:32 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E406572D56D; Thu, 16 Dec 2004 11:11:39 -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 30694-86; Thu, 16 Dec 2004 11:11:39 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3750972CC67; Thu, 16 Dec 2004 11:03:20 -0500 (EST) Message-Id: <6.1.2.0.0.20041216234240.0253cd70@pop.singnet.com.sg> X-Sender: hkchital@pop.singnet.com.sg Date: Thu, 16 Dec 2004 23:46:10 +0800 To: oracle-l@freelists.org From: Hemant K Chitale Subject: Re : Fwd: ArchiveLogs on NetApps ? -- an update Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 13775 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hkchital@singnet.com.sg Precedence: normal Reply-To: hkchital@singnet.com.sg X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Just to send out an update on this issue .... The Linux servers have 2 NIC connecting through two seperate switches in an Active/Active bonding. We changed the switch configuration to enable Flow Control and updated the Intel drivers for the NICs and switched them to Active/Passing. Then, we got much better performance -- a 100MB ArchiveLog written in 8-12 seconds. Also, the "corrupt block" error on the last ArchiveLog went away in repeated recovery tests. Hemant >Date: Tue, 07 Dec 2004 00:18:08 +0800 >To: oracle-l@freelists.org >From: Hemant K Chitale >Subject: ArchiveLogs on NetApps ? > > > >We've just begun our first NetApps [9iRAC on Linux] implementation. > >What I've found in testing so far is > > a) Writing ArchiveLogs to a NetApps Filer volume seems to be very slow > [5min for a 100MB >logfile against 30seconds on local disks] Do the ArchiveLog Dest volumes >have to be mounted >with the same NFS options as the Database Files volumes ? > >b) Testing recoveries using SNAP CREATE and SNAP RESTORE we find that we >frequently >encounter a corrupt block in the last ArchiveLog being written to the >ArchiveLog Dest volume. >Any ideas why ? > >Backup : > BEGIN BACKUP > Snap Create Database Files Volume > END BACKUP ;; ARCHIVE LOG CURRENT a few times > Snap Create ArchiveLog Files Volume > >Recovery : > Snap Restore Database Files Volume > Snap Restore ArchiveLog Files Volume > RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL > > > > >Hemant K Chitale >http://web.singnet.com.sg/~hkchital Hemant K Chitale http://web.singnet.com.sg/~hkchital -- http://www.freelists.org/webpage/oracle-l