From oracle-l-bounce@freelists.org Thu Sep 9 03:17:08 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i898H5R01075 for ; Thu, 9 Sep 2004 03:17:05 -0500 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 i898H5I01065 for ; Thu, 9 Sep 2004 03:17:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C844C72C54F; Thu, 9 Sep 2004 03:18:44 -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 01812-89; Thu, 9 Sep 2004 03:18:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E616772C554; Thu, 9 Sep 2004 03:18:42 -0500 (EST) Message-ID: <7765c89704090901214bb4db62@mail.gmail.com> Date: Thu, 9 Sep 2004 09:21:22 +0100 From: Niall Litchfield To: gleonard@wesbank.co.za Subject: Re: How to store 50 Terabytes per day? Cc: oracle-l@freelists.org In-Reply-To: <1831A554E8800049B6B970790D2513C035C0D2@fnbkrkmx01.fnb.co.za> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <1831A554E8800049B6B970790D2513C035C0D2@fnbkrkmx01.fnb.co.za> X-archive-position: 9301 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Thu, 9 Sep 2004 07:28:42 +0200, Leonard, George wrote: > Strangely enough I think the actual data space is not the problem here, > > Your problem will be the redo logs, giving them fast enough discs to > keep up with the data coming in and the same for archive logs (space and > speed), having enough space for 1 or 2 days worth and speed t keep up > with the redo log switching, then a big enough tape system to archive > the archive logs and to backup changed blocks. I can't recall what they do at SLAC, but I'm not sure that these large scientific data acquisition projects require a transactional database at all, sure writing the data to your storage medium is going to be a real headache - but if you lose an hours worth of data does it actually matter, do you redo the experiment, do you do similar experiments or do you move on. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/