Re: 11g, Unable to do nolog operations
From: Mladen Gogala <mladen_at_bogus.email.invalid>
Date: Sun, 4 Oct 2009 12:00:06 +0000 (UTC)
Message-ID: <haa2o6$tme$1_at_solani.org>
On Fri, 02 Oct 2009 13:11:24 -0700, Mark D Powell wrote:
Date: Sun, 4 Oct 2009 12:00:06 +0000 (UTC)
Message-ID: <haa2o6$tme$1_at_solani.org>
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.
-- http://mgogala.freehostia.comReceived on Sun Oct 04 2009 - 07:00:06 CDT