| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1578...block corrupted...error is normal...a block...had a
My understanding is the following :
If an object is created with direct load, append etc. with
"nologging" enabled, then no "redo" will be generated
for the initial "create".
After this though, all transactions are logged, and redo is generated.
So, if a backup is performed all data is recoverable up to that point,
and you will be able to do a recovery from that point on.
If the object is not created via a "direct load", then logging is performed, even when the "nologging" parameter is set.
Am I correct in my thinking ?
I did have any experience with LOBs where "nologging" was enabled on the LOB column, and I was unable to recover the changes from the last backup. Fortunately, I was able to recover the missing records from the exports, and I immediately enabled "logging".
thanks.
ed
--
http://www.fastmail.fm - Access all of your messages and folders
wherever you are
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 23 2005 - 10:08:55 CDT
 |
 |