RE: Inheriting a "interesting" recovery process

It also prevents rolling forward if a recovery is needed, i.e. PIT.  

Rich

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples Sent: Friday, August 04, 2006 9:43 AM
To: AGUERRA_at_amfam.com
Cc: Jared Still; stvsmth_at_gmail.com; oracle-l_at_freelists.org Subject: Re: Inheriting a "interesting" recovery process

very poor reasons  

all a shutdown does is clear out your buffer cache and shared pool making the database have to work hard when you restart it.  

What does keeping the archive logs have to do with anything. Don't you keep all of them anyway?  

On 04/08/06, Guerra, Abraham J <AGUERRA_at_amfam.com> wrote:

        Well, the only reason I would do colds is that the database is shut nicely and do not have to keep the archivelogs produced during the backup... also, shutting down the database once in a while avoids having problems with the fragmentation of the shared pool and stuff like that...

--
http://www.freelists.org/webpage/oracle-l