Re: Oracle archive mode and hot backups
Date: 7 Aug 2009 13:02:54 GMT
Message-ID: <7e2mvuF2enpq4U1_at_mid.individual.net>
ddf wrote:
> 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.
'We are still testing...'. Testing the backups should be part of that. If the recovery works after several tests, there's no problem.
-- PrestonReceived on Fri Aug 07 2009 - 08:02:54 CDT