Re: where is archive_name in 8.x ?

The V$LOG_HISTORY view never contained the name of the archivelog resulting from a log switch.
Use the V$ARCHIVED_LOG view instead, which *does* contain the archivelog filename (for local destinations).

Regards,
Rick

"Glen A. Stromquist" wrote:

> My hot backup script uses the view v$log_history to get the name and
> path of the archive log file so that it can archive and make a copy of
> any redo logs that were generated during the backup procedure.
> I noticed in 8.x that the archive_name column no longer exists in the
> v$log_history view, is the file name and path still stored somewhere in
> 8.x? if so, where?
>
> thanks in advance
>
> Sent via Deja.com
> http://www.deja.com/

--