Re: Oracle archive mode and hot backups
Date: 7 Aug 2009 11:17:43 GMT
Message-ID: <7e2gqnF2d9dpaU1_at_mid.individual.net>
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.
-- PrestonReceived on Fri Aug 07 2009 - 06:17:43 CDT