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_at_gmail.com] Sent: Friday, August 04, 2006 8:17 AM
To: Guerra, Abraham J
Cc: stvsmth_at_gmail.com; oracle-l_at_freelists.org Subject: Re: Inheriting a "interesting" recovery process

On 8/4/06, Guerra, Abraham J <AGUERRA_at_amfam.com> 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 04 2006 - 08:26:58 CDT