From oracle-l-bounce@freelists.org Wed Oct 12 11:45:03 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9CGj25K011303 for ; Wed, 12 Oct 2005 11:45:02 -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 j9CGivvX011252 for ; Wed, 12 Oct 2005 11:44:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8DF581FCF98; Wed, 12 Oct 2005 11:44:51 -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 21724-06; Wed, 12 Oct 2005 11:44:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0250F1FD1C3; Wed, 12 Oct 2005 11:44:50 -0500 (EST) Message-ID: <434D3D0E.7070108@jcpenney.com> Date: Wed, 12 Oct 2005 11:42:54 -0500 From: Riyaj Shamsudeen User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: juancarlosreyesp@gmail.com Cc: oracle list Subject: Re: not including temp neither undo tablespace in full backup References: In-Reply-To: Content-Type: multipart/mixed; boundary="------------030604070901090506080601" X-OriginalArrivalTime: 12 Oct 2005 16:42:52.0963 (UTC) FILETIME=[FD54FF30:01C5CF4B] X-Disclaimer: Outbound Correspondence X-VirusScan: JCP virus scan detected no virus X-archive-position: 26818 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rshamsud@jcpenney.com Precedence: normal Reply-To: rshamsud@jcpenney.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.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 --------------030604070901090506080601 Content-Type: multipart/alternative; boundary="----------=_1129135373-14339-96" Content-Transfer-Encoding: binary ('binary' encoding is not supported, stored as-is) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Are you kidding ? Not backing up undo tablespace is a sure way to make sure that your backups are useless! How can Oracle perform a) rollback phase of the instance recovery b) applying changes to undo segments during media recovery, without undo tablespace ? Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA (ver 7.0 - 9i) Allocation & Assortment planning systems JCPenney Juan Carlos Reyes Pacheco wrote: >Hi, meanwhile we do always a immediate shutdown. >We have decided not to backup temp neither undo tablespaces in a full >backup we get periodically. >Because it can be easily recreated. > >Does anyone has some comment about it. > >Thanks in advance. > >-- >Oracle Certified Profesional 9i 10g >Orace Certified Professional Developer 6i > >8 years of experience in Oracle 7,8i,9i,10g and developer 6i >-- >http://www.freelists.org/webpage/oracle-l > > > ------------=_1129135373-14339-96 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Are you kidding ? Not backing up undo tablespace is a sure way to make sure that your backups are useless!

How can Oracle perform a) rollback phase of the instance recovery b) applying changes to undo segments during media recovery, without undo tablespace ?

Thanks
 
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA (ver 7.0 - 9i)
Allocation & Assortment planning systems
JCPenney 


Juan Carlos Reyes Pacheco wrote:
Hi, meanwhile we do always a immediate shutdown.
We have decided not to backup temp neither undo tablespaces in a full
backup we get periodically.
Because it can be easily recreated.

Does anyone has some comment about it.

Thanks in advance.

--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l

  

------------=_1129135373-14339-96-- --------------030604070901090506080601 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: Signature The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. --------------030604070901090506080601-- -- http://www.freelists.org/webpage/oracle-l