Re: Archived redo logs

In article <u471fvkt992g5d4ufh0ueee8qeab78heog_at_4ax.com>, Sybrand Bakker wrote:

>>The reason I ask is because in our current setup all files in that directory
>>are backed up and deleted, *except* for the most current file. The reasoning
>>for this is that the most current file might still be written to. I'm not
>>sure this reasoning is correct.

> 
> this is exactly why you should issue an alter system switch logfile
> and alter system archivelog all prior to backup the archived redolog
> files, so you don't need to use this  procedure.

But (if I understand correctly) this still doesn't guarantee anything. Suppose I did this, but there are quite a lot of archived logs. My backup-script starts to process them, but in the meantime an online redo log fills up and starts to be written to a new archivelog file. My backup script comes along, finds this new, not-completely-written-yet, archived log file, and backs it up. Woops.

I like the suggestion of querying V$ARCHIVED_LOG (sp?); that way, you're guaranteed that the files you backup are complete and finished.

-- 
Jurjen Oskam

PGP Key available at http://www.stupendous.org/