RE: not including temp neither undo tablespace in full backup
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <juancarlosreyesp@xxxxxxxxx>, "Riyaj Shamsudeen" <rshamsud@xxxxxxxxxxxx>
- Date: Wed, 12 Oct 2005 15:56:57 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
