RE: Inheriting a "interesting" recovery process

  • From: "Guerra, Abraham J" <AGUERRA@xxxxxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Fri, 4 Aug 2006 08:26:58 -0500

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