Re: Oracle archive mode and hot backups

From: ddf <oratune_at_msn.com>
Date: Fri, 7 Aug 2009 05:52:25 -0700 (PDT)
Message-ID: <7dd75c0d-5263-46bc-bb04-4755d70bab56_at_z34g2000vbl.googlegroups.com>

On Aug 7, 6:17 am, "Preston" <dontwant..._at_nowhere.invalid> wrote:
> Jeff Morgan wrote:
> > We have an Oracle 10g database on UNIX moving to a new data center.
> > We are still testing a stage server. The DBA state that the standard
> > is to have the database in archive mode to allow for hot backups.
>
> > We ran into an issue when the 17 gigs of space in the archive folder
> > was full.  The DBA's solution was to write a script to automatically
> > delete archive files when the folder reaches 10 gigs.  I questioned
> > the need to create archive files if they are ultimately deleted.  The
> > DBA stated that the actual archive files are not used and can be
> > deleted.  The archive mode is only used for hot backups.
>
> > From what I have researched, the archive files are required for
> > recovery.  Can anyone shed some light on the whole archive/hot backup?
>
> There are several reasons why those archive logs may not be needed for
> recovery. As any backup routine should be tested, I suggest you get him
> to run his script, then trash the database & get him to recover it.
>
> --
> Preston

An excellent idea, and when that database is so far gone as to be unrecoverable possibly this 'DBA' will realize the error of his ways.

David Fitzjarrell Received on Fri Aug 07 2009 - 07:52:25 CDT