From oracle-l-bounce@freelists.org Wed Mar 9 23:09:23 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2A59N13029428 for ; Wed, 9 Mar 2005 23:09:23 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2A59Mem029421 for ; Wed, 9 Mar 2005 23:09:22 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 957997F10F; Wed, 9 Mar 2005 23:07:48 -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 14432-09; Wed, 9 Mar 2005 23:07:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C74A7F12F; Wed, 9 Mar 2005 23:07:48 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=E9nfrjJdMuzBgkfGhlHMAI/ipvONMj7mC0zMgoNBp/f0KpdJxnVVo1uidzyhjso4pethM52jdSQ5aYqAHYrNaGOrc04UmH+fpszBhyJlY7Ju/ScKuIfKQOrUfiAGQ8s/4EAEl6DmrZejdvyccoxNc8iJo0TgVYKcYcRjDKHXCCU= Message-ID: Date: Thu, 10 Mar 2005 04:06:03 +0000 From: Jared Still To: dba.orcl@gmail.com Subject: Re: Datawarehouse backup Cc: "oracle-l@freelists.org" In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: X-archive-position: 17114 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Some comments inline: On Wed, 9 Mar 2005 22:41:26 -0500, Sami Seerangan wrote: > 1) Stop ETL jobs > 2) Change all the tablespaces to READ-ONLY mode except SYSTEM > 3) Alter system switch logfile( 3 times) I am curious to know why you are doing steps 2 and 3. > 4) Shutdown database ...> 9) Start ETL job > Seems like a lot of extra work. Here's an idea: put your database in archivelog mode, back it up online, including of course the relevant archive logs. When you're not backing up you could simply delete the archive logs as they are created, or possibly, if you can take a few minutes at the beginning and end of the backups, put the database in archivelog mode and then take the database back out of archivelog mode. The point being that you have 2 very small downtime windows required for the database backup. This might not be be an acceptable method, it depends on how many bounces of the database you can affored on a regular basis. If the overhead of archive logging is not too much for you, just delete those archived logs during the week, leaving the database in archivelog mode. If you are planning on having a week of unrecoverable data anyway with cold backups and noarchivelog mode, this should work fine. This would of course be tested first on a test system, along with the requisite recovery test to ensure that you have all the details down pat. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l