From oracle-l-bounce@freelists.org Mon May 3 14:59:26 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i43JwLI26072 for ; Mon, 3 May 2004 14:59: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 i43JvL625967 for ; Mon, 3 May 2004 14:58:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E67F872D5E8; Mon, 3 May 2004 14:47:26 -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 03684-25; Mon, 3 May 2004 14:47:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 384EC72D699; Mon, 3 May 2004 14:47:26 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 03 May 2004 14:46:09 -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 CF43872CD83 for ; Mon, 3 May 2004 14:46:08 -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 02798-67 for ; Mon, 3 May 2004 14:46:08 -0500 (EST) Received: from kmg.com (fw.kmg.com [207.243.118.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 658CD72D1B8 for ; Mon, 3 May 2004 14:46:07 -0500 (EST) Received: from okcexg3.kmg.com ([167.151.96.253]) by kmg.com with Microsoft SMTPSVC(5.0.2195.5329); Mon, 3 May 2004 14:59:38 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Oracle recovery Importance: normal Date: Mon, 3 May 2004 14:59:34 -0500 Priority: normal Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B85088B2@okcexg3.kmg.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Oracle recovery thread-index: AcQxR++meRvhBRHLQV2pY9bPHSTa4wAAPzhA From: "Smith, Ron L." To: X-OriginalArrivalTime: 03 May 2004 19:59:38.0883 (UTC) FILETIME=[2A832D30:01C43149] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4272 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rlsmith@kmg.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org We do full exports on all databases at least once a day for table level recovery if needed. We also do daily hot backups for point in time recovery. I feel there is a need for both. Ron Smith -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Daniel Fink Sent: Monday, May 03, 2004 2:42 PM To: oracle-l@freelists.org Subject: Re: Oracle recovery I recall a paper from Oracle (about 5 years ago) that analyzed the various outages, the methods of recovery and how long they took. I have it at home and I'll see if I can get a doc_id from it. The point I would make with the DBA is that exports are not a recovery mechanism, they are only able to restore to a given point (time of the export) and they do not restore everything (sys objects). With an export, there is no way to roll-forward. Of course, a cold backup w/out archive logs is also unable to roll-forward. All data from the last export and the current time is lost period end of story. Is this acceptable? Perhaps. In certain environments where data loss is not a problem, exports are a pretty simple way of capturing a snapshot of the data. It is also not just 'data' that is lost. It is anything stored inside the db, including procedures, packages, etc. In a development environment, a days worth of coding could easily run into the 10s of 1000s of dollars. Daniel "M.Godlewski" wrote: >=20 > Believe it or not the database I'm currently using the DBA is forcing=20 > us to use exports as our applications recovery scenario. I'm trying=20 > to locate information about archive logging and the tablespace point=20 > in time recovery versus full database recovery. I wanted to find some > kind of percentages about the number of databases that need full=20 > database recovery (ie applying all archive logs) and percentages of=20 > databases that only needed TSPIR. >=20 > I thinking if I can get some type of failure rate it could help sway=20 > him into using archive log mode which would give us better recovery options. ---------------------------------------------------------------- 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 -----------------------------------------------------------------