Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1K0e0p01068 for ; Wed, 19 Feb 2003 18:40:00 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1K0e0Q01059 for ; Wed, 19 Feb 2003 18:40:00 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA14650; Wed, 19 Feb 2003 13:23:35 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00551F5F; Wed, 19 Feb 2003 13:04:56 -0800 Message-ID: Date: Wed, 19 Feb 2003 13:04:56 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Koivu, Lisa" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Koivu, Lisa" Subject: RE: Veritas Agent for Oracle / incremental backups vs. hot 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="iso-8859-1" Content-Transfer-Encoding: 8bit Allan, I disagree. From what I remember, rman incremental backups are also block-level, hence the savings in tape/disk and time. The tradeoff is at restore time. Unless you are talking about a Veritas utility? There's no other way I know of in Oracle to execute an incremental backup outside of rman. ?? And honestly I wouldn't trust a third-party software tool to do it. I use backupexec/Oracle Agent for hot backups, and those are complete hot backups. If I'm missing something please say so. Lisa Koivu Oracle Database Bonehead. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -----Original Message----- Sent: Wednesday, February 19, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Actually assuming you checkpoint or commit at least once between backups it would not make any difference at all. An incremental backup catches changed files since the last backup which will typically be all your data files. SCN's get updated in all headers if any thing changes. Allan -----Original Message----- Sent: Wednesday, February 19, 2003 1:25 PM To: Multiple recipients of list ORACLE-L My manager asked me to assess how much smaller our backups would be if we were doing incremental backups of our database files, instead of the usual hot backups. We are running 8i on UNIX. I know that the answer is "it depends" and "you can't really know 'till you try", but we are just looking for a ballpark figure, perhaps in percentages. Our databases are between OLTP and DSS, closer to DSS environment, this being a scientific site. Thanks. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: boivinp@mar.dfo-mpo.gc.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: BoivinP@mar.dfo-mpo.gc.ca 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). ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: anelson@midf.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: Lisa.Koivu@efairfield.com 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).