Re: Archived redo logs

Jurjen Oskam wrote:
> 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?
>
>
> 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.
>
>
> Thanks,

HI,

Try to use v$archived_log to check which ARCHIVELOG is COMPLETED

select NAME, ARCHIVED, DELETED from v$archived_log where ARCHIVED like '%YES%';

-- 

   www.konsultancIT.pl
Oracle&MS-SQL consulting