nologging and recovery

From: David <thump_at_cosmiccooler.org>
Date: Tue, 4 Jan 2005 15:29:32 -0800 (PST)
Message-ID: <42696.127.0.0.1.1104881372.squirrel@127.0.0.1>

Having a bit of a debate here...
Different docs have alluded to different issues and pros/cons.

Question....under 9i...what are the ramifications of performing the operations that support nologging and then having to recover the database?

These nologging operations are ongoing in such a fashion that it would not be possible to perform a db backup after each operation.

Can we recover and the associated objects error out with an error when accessed and need to be recreated or can we not recover the associated tbs/datafile at all?

For the record....the objects assocated with the operations were we would not need to perform logging do not need to be recovered. All objects currently reside in the same tbs.

-- 
..
David

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 04 2005 - 17:29:01 CST