Re: Backup toubles: How and when can I delete my archive logs?

In article <a5oe53$qoi$1_at_lust.ihug.co.nz>, "Howard J. Rogers" <dba_at_hjrdba.com> wrote:

>True enough, and I was careless in my choice of terminology -but switching
>of ARCH is equally pointless. If you (or he!) were to base your decision on
>what to delete on v$archived_log, the question of a 'hot delete' wouldn't
>arise.

Ya, that's true, but it's also more complicated to incorporate into a simple script. It's hardly pointless either since it DOES the job cleanly enough.

>Meanwhile, being in archivelog mode with ARCH switched off is just asking
>for a system hang.

Unlikely for the few seconds it takes to copy off the archived logs to another directory and delete. If transactions may be expected to be so high as to go through 3 (at least) online redologs, you shouldn't be scheduling a regular backup at that time.

I think the best choice here is to just use RMAN and avoid these issues entirely. Received on Mon Mar 04 2002 - 07:35:15 CST