Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archive Logs
"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
![]() |
![]() |