Archive Logs

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 10 Mar 2003 09:55:59 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703674C09@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 Received on Mon Mar 10 2003 - 03:55:59 CST