Re: Archive mode

From: <markp7832_at_my-deja.com>
Date: Wed, 01 Dec 1999 17:50:23 GMT
Message-ID: <823n4t$m4i$1@nnrp1.deja.com>

In article <823k70$jqd$1_at_nnrp1.deja.com>, kaprino_at_my-deja.com wrote:
> Hi,
>
> How can I find out if the I'm In ARCHIVELOG mode or NOARCHIVELOG
> mode while database is active. What table will contain imortant
> information about the current instance of the database.
> Thanks,
>
> kaprino
>

For version 8 you can look at the log_mode column of v$database. You may also want to look at v$log and v$instance. Both v$instance and v$database underwent significant additions/changes from ver 7 to 8.

Most all the v$ tables are documented in the Reference manual.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 01 1999 - 11:50:23 CST