Re: not including temp neither undo tablespace in full backup

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_at_il.proquest.com> 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_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
>

--
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