Re: Archived redo logs

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 18 Jun 2003 10:10:29 +0100
Message-ID: <3ef02c85$0$18497$ed9e5944@reading.news.pipex.net>

"Jurjen Oskam" <joskam_at_quadpro.stupendous.org> wrote in message news:slrnbf098e.k9p.joskam_at_calvin.quadpro.stupendous.org...
> Hi everyone,
>
> I have a small question about archived redo logs, with (I hope :-) a
simple
> answer.
>
> Given a database in ARCHIVELOG mode. The archived log files are written to
> /oracle_arch.
>
> Is it safe to assume that *every* file in that directory is complete and
> not being written to by Oracle?

No. Unless archiving is temporarily stopped.

> 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.

As above the reasoning is correct - but the procedure does further assume that the backup is successful and will always be available. you might wish to keep n days worth of archive logs on disk just in case this assumption proves incorrect.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Wed Jun 18 2003 - 04:10:29 CDT