Re: Archive Logs

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 10 Mar 2003 12:01:30 +0200
Message-ID: <3e6c61c8$1_1@news.estpak.ee>

Hi,

select name from v$parameter where name like 'log_archive_%dest%';

(this syntax shows also log_archive_duplex_dest)

Individual archives can be checked:

select name from v$archived_log

Issuing "archive log list" from command line gives DBA a nice overview of current archiving status in instance.

Tanel.

"Henry" <henry_at_nothing.com> wrote in message news:1047289325.842696_at_ftp.adept.co.za...
>
>
> Hi there
> Can someone help me with the sql statement for finding in which directory
> the archive logs are stored?
>
> cheers
> H
>
>
Received on Mon Mar 10 2003 - 04:01:30 CST