RE: Inheriting a "interesting" recovery process

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...
 
Abraham Guerra
-----Original Message-----
From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: Friday, August 04, 2006 8:17 AM
To: Guerra, Abraham J
Cc: stvsmth@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Inheriting a "interesting" recovery process


On 8/4/06, Guerra, Abraham J <AGUERRA@xxxxxxxxx> wrote: 


        Your very best friends are:  'Cold Backup' (hot whenever you
can't do
        colds) and make sure your database is in archivelog mode if you
want
        full recovery...


Please  explain why a cold backup is necessary. 

Before 10g there are rather limited circumstances under which a cold
backup is necessary.

With 10g  and the (supported) ability to recover through a resetlogs,
there are even fewer reasons for it.



        If your database stores traffic tickets, then keep doing
whatever you're
        doing ;-) 
        
        


Wouldn't that be nice.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: