Re: Archive Logs

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in news:E2F6A70FE45242488C865C3BC1245DA703674C09_at_lnewton.leeds.lfs.co.uk:

> To get the destination on 8i and above you need :
>
> SELECT * FROM v$parameter
> WHERE NAME LIKE 'log_archive_dest%';
>
> or, to get all archi parameter details :
>
> SELECT * FROM v$parameter
> WHERE NAME LIKE 'log_archive%';
>
> alternatively, check out the initSID.ora file - unless you are using an
> SPFILE !
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
>
> -----Original Message-----
> From: Henry [mailto:henry_at_nothing.com]
> Posted At: Monday, March 10, 2003 9:42 AM
> Posted To: server
> Conversation: Archive Logs
> Subject: Archive Logs
>
>
>
>
> Hi there
> Can someone help me with the sql statement for finding in which
> directory
> the archive logs are stored?
>
> cheers
> H
>
>
>

Never use V$PARAMETER to evaluate the value of archivelog destination information. The LOG_ARCHIVE_DEST_n init.ora parameters can be "incrementally" modified, and the V$PARAMETER view only shows the LAST value specified (not the *entire* value!).

ALWAYS use the V$ARCHIVE_DEST view to evaluate information about the archivelog destination. Remember, this shows you where the archivelog *will* reside (future tense).

Now, if you want to know where the archivelogs were *really* archived to, then you want to query the V$ARCHIVED_LOG (past tense! :-), as follows:

            select NAME from V$ARCHIVED_LOG;
This shows you the fully-qualified file name where the archivelog actually resides. Received on Mon Mar 10 2003 - 05:01:18 CST