Re: [NO]ARCHIVELOG

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sun, 13 Nov 2005 00:53:16 GMT
Message-Id: <pan.2005.11.13.00.53.13.316769@sbcglobal.net>

On Tue, 08 Nov 2005 15:38:41 +0100, Joachim Hofmann wrote:

> Hello,
>
> how can I recognize if a Database is running in ACHIVELOG - Mode,
> and what is the procedure to switch between [NO]ACHIVELOG ? [Oracle 9i]
>
> Thanks
>
> Joachim

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production

SQL> select log_mode from v$database;

LOG_MODE

ARCHIVELOG

-- 
http://www.mgogala.com

Received on Sat Nov 12 2005 - 18:53:16 CST