Re: archivelog mode

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/12/18
Message-ID: <4b414j$sae_at_cloner2.ix.netcom.com>#1/1


med10054_at_leonis.nus.sg (NORHISHAM BIN MAIN) wrote:

>HI,
 

>How do I check if my DB is running in archivelog mode ? Are there any
>tables that records this info ? I can have the "arch" process running
>but it does not neccessarily mean that the DB is in archivelog mode,
>right ?

SELECT LOG_MODE FROM V$DATABASE;

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!
Received on Mon Dec 18 1995 - 00:00:00 CET

Original text of this message