Re: archivelog mode
From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1996/01/05
Message-ID: <4ciudb$4ms_at_cougar.vut.edu.au>#1/1
Date: 1996/01/05
Message-ID: <4ciudb$4ms_at_cougar.vut.edu.au>#1/1
Chuck Hamilton (chuckh_at_ix.netcom.com) wrote: : 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,
: SELECT * FROM V$DATABASE;
: --
In sqldba, do this:
archive log list
HTH,
Leng.
-- Leng Kaing DBA - Directory Technology P/L Email: lkaing_at_ventnds1.telecom.com.au Ph: +61-3-9892-9081 Fax: +61-3-9892-9344Received on Fri Jan 05 1996 - 00:00:00 CET