Re: Table v$log and archived log files ?

The v$log view's information is coming from the control file, and the column 'archived' (which is probably what you are referring to) is actually a bit (or several) set by the archiver process ('ARCH') upon completion of archiving activity for a particular group. It's this bit that stops a log group being over-written by fresh redo until a successful archive of the log has been made whilst in archive log -so one would most certainly hope that it was reliable, otherwise there would be a risk of Oracle losing your data!

In other words, it *is* a reliable indication that a group has been successfully archived -though that's not quite the same thing as saying that a the physical writing of a particular file has been completed. There could be things like a disk write cache to confuse the issue, for example; or you may have configured for ARCH to take multiple copies of the online logs, yet also have configured for some of those duplicates to be optional... I think you'll find the ARCHIVED bit is set when the *compulsory* copies are taken, which leaves the physical status of the additional duplicates rather up in the air.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"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

>