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: Inheriting a "interesting" recovery process

Re: Inheriting a "interesting" recovery process

From: David Sharples <davidsharples_at_gmail.com>
Date: Fri, 4 Aug 2006 15:42:33 +0100
Message-ID: <be592d550608040742t13762c80w8f43ee41bcd8a328@mail.gmail.com>


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
Received on Fri Aug 04 2006 - 09:42:33 CDT

Original text of this message

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