Re: Location of redo logs

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 23 Oct 1998 22:17:31 GMT
Message-ID: <3630f6e7.4323188@news.siol.net>

On Fri, 23 Oct 1998 20:56:07 GMT, abraham_at_my-dejanews.com wrote:

>In article <70qdm9$1u8k1_at_tmpsp002.tmpprv.allied.com>,
> "Zachary Agatstein" <Zachary.Agatstein_at_atsc.allied.com> wrote:
>> A newbie question:
>> If I don't have a LOG_ARCHIVE_DEST parameter specified in my initxxx.ora
>> file, how do I find out where these redo logs reside?
>>
>> Thanks
>>
>> Zach
>
>select file_name from dba_data_files
>
>and identify your redo log files
>
>- Abraham

Hm, one should use a bit of black magic to find the archived redo logs destination from the DBA_DATA_FILES ;-)

More straightforward way would be:

SELECT name, value FROM V$PARAMETER WHERE NAME = 'log_archive_destinat';

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Oct 23 1998 - 17:17:31 CDT