Re: not including temp neither undo tablespace in full backup
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- Date: Wed, 12 Oct 2005 16:15:44 -0400
Thanks Mark, but in my database with about less than 20 users, can be
acceptable, remember I have a very small databases. About 2-6 gigas.
On 10/12/05, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
> 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
>
--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
//www.freelists.org/webpage/oracle-l
Other related posts:
