Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archive Logs
I'm returned not path when I perform
SELECT * FROM v$parameter
WHERE NAME LIKE 'log_archive_dest%'; I want to get where the archive logs
will reside.
What have I done wrong?
I'm using windows and runing 9i.
Cheers
Henry
"Rick Anderson" <Richard.Anderson_at_oracle.com> wrote in message
news:Xns933A3C67FA987RichardAndersonoracl_at_148.87.1.53...
> 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:33:40 CST