Re: archive log destination

From: Richard L. Flores <flores_at_ccnet.com>
Date: 1997/04/07
Message-ID: <01bc4369$ae95a100$6f0a15cf@tmekscds>#1/1

Take a look at V$LOG_HISTORY.ARCHIVE_NAME. You can derive the archive destination from that column. Unfortunately, whenever you change the archive destination, ALL the archive_name's change paths. So, if you do switching, you cannot tell from V$LOG_HISTORY where any particular archive file is located.

Richard L. Flores
Independent Computer Consultant

gwleung_at_pacbell.net wrote in article <33497E86.DED_at_pacbell.net>...
> I am running Oracle 7.1.6 in ARCHIVELOG mode. I tried to change the
archived log
> destination from LOG_ARCHIVE_DEST to another location by ALTER SYSTEM
ARCHIVE LOG START
> 'new_dest'; It works fine, except it still shows the original
destination when querying
> up v$parameter. Is there any view/table which will show the current
archive log
> destination?
>
> Grace Leung
>
Received on Mon Apr 07 1997 - 00:00:00 CDT