Re: How can I get archive log destination path?
From: Contractor - Yuktton <jychan_at_corp.hp.com>
Date: 1995/06/23
Message-ID: <3sfgiq$1el_at_hpcc48.corp.hp.com>#1/1
Date: 1995/06/23
Message-ID: <3sfgiq$1el_at_hpcc48.corp.hp.com>#1/1
Peter Sharman (psharman_at_au.oracle.com) wrote:
: vlohia_at_oes.amdahl.com (Ved Lohia) wrote:
: >SQL*DBA monitor provides this info but I need it in my script.
: >
: Ved
: This can either be picked up from the init.ora file, or by doing an
: archive log list in SQL*DBA, or by select value from v$parameter where
: name = 'log_archive_dest'.
:
One small point to keep in mind: If you change the archive log dest using "alter system archive log to <destination>", it will not be reflected in the v$parameter view. As far as I know, the only way to get this accurately is in sqldba with "archive log list".
Johnny Chan
Independent Oracle Specialist
Received on Fri Jun 23 1995 - 00:00:00 CEST