Re: Archive Logs

From: Rick Anderson <Richard.Anderson_at_oracle.com>
Date: Mon, 10 Mar 2003 12:50:36 GMT
Message-ID: <Xns933A4EEFC6598RichardAndersonoracl@148.87.1.53>

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in news:V8%aa.1512$pK2.2235_at_news.indigo.ie:

> Absolutely silly question...
>
> Is archiving switched on ?
>
> because on my play instance where archiving is not enabled when I do
>
> show parameter log_archive_dest I get no answer either ...
>
>
> "Henry" <henry_at_nothing.com> wrote in message
> news:1047296025.106957_at_ftp.adept.co.za...

>> 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
>>

>
>
>

Do NOT use V$PARAMETER - use V$ARCHIVE_DEST. For example:

select dest_id,status,destination from v$archive_dest;

Hope this helps.
Rick Received on Mon Mar 10 2003 - 06:50:36 CST