From oracle-l-bounce@freelists.org Thu Oct 13 18:42:56 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9DNgtGc032635 for ; Thu, 13 Oct 2005 18:42:55 -0500 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 j9DNgnvX032623 for ; Thu, 13 Oct 2005 18:42:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E45F51FEA8F; Thu, 13 Oct 2005 18:42:40 -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 14937-09; Thu, 13 Oct 2005 18:42:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2EC4B1FEB6A; Thu, 13 Oct 2005 18:42:40 -0500 (EST) From: "Mark W. Farnham" To: , , "Riyaj Shamsudeen" Cc: "oracle list" Subject: RE: not including temp neither undo tablespace in full backup Date: Thu, 13 Oct 2005 19:36:10 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-archive-position: 26957 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mwf@rsiz.com Precedence: normal Reply-To: mwf@rsiz.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 A fairly standard method is shutdown (some fast way, you pick it), startup restrict, shutdown normal. Now while this eliminates the "indefinite" waiting for everyone to log out, it does not get you down quickly in the face of a very large rollback. However, since every important situation I can recall put a high premium on time to recover when a need to recover is detected, then if for some reason you're relying on a cold backup, shouldn't it also be after a normal shutdown so that the restart does not require an unknown length of rollback before the database is fully operational? (I used to say operational at all, but hooray you can open before all the rollbacks are complete in these modern times.) and the why bother? comment is pretty much on target. only other bit I'd mention is to remember to get a copy of your current on-line redo logs and control file as the first step of recovery. (not as part of backup, unless that is a frozen complete set cold backup not intended to ever be rolled forward). mwf -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Bobak, Mark Sent: Wednesday, October 12, 2005 3:57 PM To: juancarlosreyesp@gmail.com; Riyaj Shamsudeen Cc: oracle list Subject: RE: not including temp neither undo tablespace in full backup Hmm...a normal shutdown? How long is that going to take? (Has anyone ever really used normal shutdown for anything useful?? ;-)) On any moderately busy database, you could be waiting indefinitely for a normal shutdown. (All it takes is one user to go home and not log out.) you may be better off with a "shutdown transactional". But, why bother? Just follow the standard best practices, and don't worry so much about your backups. Always backup all datafiles, but never tempfiles or on-line redo, and use the 'alter database backup controlfile ...' command to make a backup copy of your controlfile. -Mark -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Juan Carlos Reyes Pacheco Sent: Wednesday, October 12, 2005 3:42 PM To: Riyaj Shamsudeen Cc: oracle list Subject: Re: not including temp neither undo tablespace in full backup Thanks a lot Riyaj, I had tested the situation you saidme in the past, but any way letme test again. Maybe I'll have to ask a normal shutdown. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l