Re: standby database and nolog unrecoverable issue

Yes, it means that you cannot use nologging for DDL if you want to propagate these DDLs to the standby because the redolog contains "invalidation redo" for these DDLs marking the objects to be "logically corrupt". The same holds for recovering a database after restore. You should always place a "drop" or "truncate" of the respective object in your stream of operations to make sure it is emptied. Thus redolog will contain the drop or truncate which is propagated properly and which clears up the logical corruption.

Martin Received on Sun May 06 2001 - 11:45:57 CDT