What can cause nologging?

From: cs charlie <charliecs(nospam)_at_hotmail.com>
Date: Thu, 17 Aug 2006 00:56:02 GMT
Message-ID: <C8PEg.71900$MW.53988@trnddc04>

I am using 9206 on Linux. There is only third party application on this database. Every once a while, there is some unrecoverable_change on some of the datafile, which does not belong to system tablespace.

There is only some tables/indexes in sys schema which are nologging, all other tables/indexes are logging. Where could this unrecoverable operation be coming from? How could I eliminate them? Every once a while, I will have to rebuild my standby database.

Thanks very much for your help. Received on Wed Aug 16 2006 - 19:56:02 CDT