Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: not including temp neither undo tablespace in full backup

RE: not including temp neither undo tablespace in full backup

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 12 Oct 2005 15:56:57 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2705366BAF@AABO-EXCHANGE02.bos.il.pqe>


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_at_freelists.org
[mailto:oracle-l-bounce_at_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 Received on Wed Oct 12 2005 - 14:59:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US