From oracle-l-bounce@freelists.org Fri Jun 4 14:58:21 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i54Jw6Y23788 for ; Fri, 4 Jun 2004 14:58:16 -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 i54Jvu623746 for ; Fri, 4 Jun 2004 14:58:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7346E72C7D8; Fri, 4 Jun 2004 13:27:01 -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 01480-59; Fri, 4 Jun 2004 13:27:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE1C372C680; Fri, 4 Jun 2004 13:27:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 04 Jun 2004 13:25:28 -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 5D08F72C420 for ; Fri, 4 Jun 2004 13:25:28 -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 01445-18 for ; Fri, 4 Jun 2004 13:25:28 -0500 (EST) Received: from GAVHSEN0A1AD.HSEN (exchsen0a1ra.dfa.state.ny.us [198.22.236.246]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CCB8A72C72A for ; Fri, 4 Jun 2004 13:25:27 -0500 (EST) Received: from snysdolmail1.labor.state.ny.us ([172.16.96.117]) by exchsen0a1ra.dfa.state.ny.us with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id M1C2CQ73; Fri, 4 Jun 2004 14:44:03 -0400 Received: by snysdolmail1.labor.state.ny.us with Internet Mail Service (5.5.2650.21) id ; Fri, 4 Jun 2004 14:44:00 -0400 Message-ID: X-Sybari-Trust: 8816b395 1dacc2b8 d7c7da2a 0000013d From: "Mercadante, Thomas F" To: "'oracle-l@freelists.org'" Subject: RE: Date: Fri, 4 Jun 2004 14:44:01 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2032 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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? >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. >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! Tom Mercadante Oracle Certified Professional -----Original Message----- From: Paul Drake [mailto:discgolfdba@yahoo.com] Sent: Friday, June 04, 2004 2:31 PM To: oracle-l@freelists.org Subject: RE: --- "Mercadante, Thomas F" wrote: > Dennis, > > I don't see why Oracle even provides this type of > backup (database in > mount-only mode using Rman). To me, if I was > considering this, I would just > shut the database down and perform a cold backup. > Using Rman in this > situation is a waste of time (unless someone can > give me a good reason why > it is useful). > > Rman's biggest strength is point in time recovery, > and that the db is up and > available all the time. > > Anything else just seems like a waste to me - no > practicality to it. > > Tom Mercadante > Oracle Certified Professional Tom, 1. block checking (inline). don't need to run dbv. 2. doesn't backup blocks that have not been written to. 3. operation is in the controlfile (or rman catalog). 4. not platform-specific. we've got some development dbs that are running in noarchivelog for the time being, so full rman backups while mounted is the way to go for them for now. 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------