Return-path: Envelope-to: oracle-l@orafaq.net Delivery-date: Fri, 20 Sep 2002 23:52:53 +0800 Received: from newsfeed.cts.com ([209.68.248.164]) by jean.onefuse.com with esmtp (Exim 3.36 #1) id 17sQ5M-00055r-00 for oracle-l@orafaq.net; Fri, 20 Sep 2002 23:52:52 +0800 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA63434; Fri, 20 Sep 2002 08:52:57 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004D51BE; Fri, 20 Sep 2002 08:13:33 -0800 Message-ID: Date: Fri, 20 Sep 2002 08:13:33 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Gene Sais" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Gene Sais" Subject: Re:Backup Strategy - Informal Survey Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Robert - My info: Oracle 8.1.7 E.E. Largest DB is 900gb Hot Backups 2x week Cold Backups 1x month Export Backups 1x week on selective schemas I do export backups for creation of test db's, recover data validation = blunders, i.e. single object restores. Future plans are RMAN, RMAN, RMAN on 9i. I need incremental backups fast = :) Gene >>> dgoulet@vicr.com 09/20/02 10:53AM >>> Robert, I don't do exports of our large production systems mainly due to the = fact that I'd have to export them to tape and getting that much quite time, so = as not to bump in to an ORA-01555 or have someone else hit a rollback segment = issue, is impossible. Consequently two hot backups a week are the norm around here = & we guard out archived redo logs very well. Now I do take exports of selected tables before they get modified or = mass changed so that we have a point in time to go back to if all hell breaks = loose. Dick Goulet ____________________Reply Separator____________________ Author: "Freeman; Robert" Date: 9/20/2002 6:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an = important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author: Freeman, Robert INET: Robert_Freeman@csx.com=20 Fat City Network Services -- 858-538-5051 http://www.fatcity.com=20 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author:=20 INET: dgoulet@vicr.com=20 Fat City Network Services -- 858-538-5051 http://www.fatcity.com=20 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: Gsais@co.palm-beach.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).