From oracle-l-bounce@freelists.org Wed Jun 30 07:10:53 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5UCAc023582 for ; Wed, 30 Jun 2004 07:10:48 -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 i5UCAS623525 for ; Wed, 30 Jun 2004 07:10:38 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F30AE72C81A; Wed, 30 Jun 2004 06:52:56 -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 28584-25; Wed, 30 Jun 2004 06:52:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53DC472C9C7; Wed, 30 Jun 2004 06:52:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 30 Jun 2004 06:51:34 -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 C6EFB72C18E for ; Wed, 30 Jun 2004 06:51:33 -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 28133-57 for ; Wed, 30 Jun 2004 06:51:33 -0500 (EST) Received: from galottery.org (mail.galottery.org [206.98.139.209]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0AC7C72C067 for ; Wed, 30 Jun 2004 06:51:33 -0500 (EST) Received: from CONNECT-MTA by galottery.org with Novell_GroupWise; Wed, 30 Jun 2004 08:14:04 -0400 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.1 Date: Wed, 30 Jun 2004 08:13:37 -0400 From: "Ron Rogers" To: Subject: Re: Question of degrees in Oracle DB recovery Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4061 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: RROGERS@galottery.org Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Practice recoveries are a must. Do not believe the reports that a tape was written to successfully. At my last employer the development server was backed up nightly using the OS dd> commands. A disk failed and a restore was attempted from the tape backups. The tape drive was defective and no tape was usable for a 2 month period. A lesson learned... practice restore procedures. It verifies your ability and the validity of the backup. Ron >>> Daniel.Fink@Sun.COM 06/29/2004 12:37:31 PM >>> I don't recall if this is an exact quote from Tim Gorman or Gary Dodge, but the essence is "The job of the dba is not to backup the database, but recover the database." If you use this approach, you will be focusing on the right issues and performing the right tasks (like performing test recoveries). Regards, Daniel Fink DENNIS WILLIAMS wrote: > Stephen > You are getting some excellent responses. I don't see where the following > point was mentioned (forgive me if I have overlooked it) > - A backup practice can't be trusted unless you've tested it with an > actual recovery. > > Dennis Williams > DBA > Lifetouch, Inc. > dwilliams@lifetouch.com > I said it "looked" clear - Riddick ---------------------------------------------------------------- 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 -----------------------------------------------------------------