Re: RedoLog utilization investigation

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 28 Apr 2005 08:27:01 +0200
Message-ID: <14iv61pu4ulutin0596fnrf4cv0qdrvt11@4ax.com>

On Wed, 27 Apr 2005 12:42:48 +0200, "GenTLe" <alexthegentleSPAMMATI_at_hotmail.com> wrote:

>The question regards only if there is a way to know if the redologs are
>stopped from the beginning of the server life (october 2003) or later. I
>wasn't in this company in that period and I'm trying to understand WHEN (and
>so WHO) stopped the redologs...

The redologs are NOT stopped, they are just NOT archived. Consequently the online redologs are recycled.
As the default at database creation is NOARCHIVELOG, chances are it was always on NOARCHIVELOG.
A change would have been audited in the alert, and in a file in the $ORACLE_HOME/rdbms/audit directory.

Your remark about the state of the tablespaces is irrelevant. Nologging only applies to a very limited number of operations.

All in all, I guess your predecessor also never read the Concepts Manual, and didn't know what he was doing.

Right now, this group can just wait for disaster to strike at your site.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Apr 28 2005 - 01:27:01 CDT