From oracle-l-bounce@freelists.org Fri Jun 4 13:53:29 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i54IrDB11603 for ; Fri, 4 Jun 2004 13:53:23 -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 i54IqJ611522 for ; Fri, 4 Jun 2004 13:53:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E51D172C54B; Fri, 4 Jun 2004 13:38:31 -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 03822-01; Fri, 4 Jun 2004 13:38:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2548A72CA98; Fri, 4 Jun 2004 13:38:31 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 04 Jun 2004 13:37:10 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9E6AE72C1C1 for ; Fri, 4 Jun 2004 13:37:09 -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 03263-38 for ; Fri, 4 Jun 2004 13:37:09 -0500 (EST) Received: from web20422.mail.yahoo.com (web20410.mail.yahoo.com [66.163.169.98]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 14FC772C993 for ; Fri, 4 Jun 2004 13:37:09 -0500 (EST) Message-ID: <20040604185544.95408.qmail@web20422.mail.yahoo.com> Received: from [156.43.4.1] by web20410.mail.yahoo.com via HTTP; Fri, 04 Jun 2004 11:55:44 PDT Date: Fri, 4 Jun 2004 11:55:44 -0700 (PDT) From: Paul Drake Subject: RE: To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2038 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: discgolfdba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --- "Mercadante, Thomas F" wrote: > Paul, > >1. block checking (inline). don't need to run dbv. > OK. This makes sense. Although the risk is > probably small - how many times have we > experienced corrupted blocks? more than once, due to bad hardware/drivers. wanna see it in the log as soon as it happens. in these days of quarterly sarbanes-oxley driven backup/restore/recover checks, this is a way of having a paper trail against some forms of corruption. > >2. doesn't backup blocks that have not been written > to. > > Grudgingly ok. I would keep the free space small > for any database that I am > not running in archivelog mode. > I would *never* run > a prod db in noarchivelog mode. agreed. won't/don't have any. think database where developers are trying out different designs and using lots of space, re-running test loads. not even the real dev db. > >3. operation is in the controlfile (or rman > catalog). > I guess. > >4. not platform-specific. > *Everything* is platform specific. > I guess is comes down to personal preference. I > don't think I'd put myself > in the position to allow this to happen. > I'd argue like hell against it! > Have a good weekend! thanks. sure hope so, could use one. Pd __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------