Re: Table v$log and archived log files ?

"Gerald Hein" <gerald.hein_at_epost.de> wrote in message news:3C65725D.6070108_at_epost.de...
> Hi,
>
> If table v$log tells me, that a specific sequence number (logfile) has
> been archived: is it really guaranteed, that the PHYSICAL WRITING of
> this archived log file has COMPLETELY finished ?
>
> In other words:
> I like to copy the archived log files to another disk (backup). Can I
> rely on the info I get from table v$log ?
>
> Thanks
> Gerald
>

The table v$log doesn't tell you a specific file has been archived, at if it would tell you that it would only provide info on the last archived redolog file.
You probably don't want to perform backup on every individual file. What you need is either v$log_history, or v$archived_log though I believe the latter view is RMAN specific.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address