Re: 11g, Unable to do nolog operations

From: Mladen Gogala <>
Date: Sun, 4 Oct 2009 12:00:06 +0000 (UTC)
Message-ID: <haa2o6$tme$>

On Fri, 02 Oct 2009 13:11:24 -0700, Mark D Powell wrote:

> There is no valid reason to set the system, sysaux, or an undo
> tablespace to nologging since Oracle provided features should be the
> only source of activity on these tablespaces.

You can't set UNDO tablespace to nologging. UNDO is always logged, otherwise recovery would not be possible. As for setting system and sysaux tablespaces to nologging, be prepared to encounter some unrecoverable dictionary objects. In other words, your database might become unrecoverable. Of course, such setting would also mean that the database is unsupported, too.

Received on Sun Oct 04 2009 - 07:00:06 CDT

Original text of this message