A reader, September 22, 2006 - 4:45 pm UTC
A reader, December 23, 2011 - 2:41 pm UTC
"Normal inserts/updates/deletes on the table are logged as normal. nologging only affects
certain operations like direct path loads and such on the object." <from your first answer>
1. My database tablespces are NOLOGGING. and ARCHIVELOG enabled
2. Did a RMAN hot backup on source database 11gR2
3. moved the backup to target database
4. restored DB no errors
5. Applied archive logs (moved from source db)
6. About 100 of them applied. Then got error
Redo is inconsistent with data block
Please tell me if I am correct
1. The NOLOOGING will affect recovery only if there is direct load like insert APPEND. or SQL Loader direct
Otherwise recovery is not an issue with NOLOGGING
2. If the database shutdown and started on MOUNT state
since DB is consistent, DUPLICATE database from source to target will work successfully even if NOLOGGING and DIRECT load in source DB
3. I am sure you are not in favor of this, but for sake of completeness. cold RMAN backup and restore to target will work successfully even if NOLOGGING and DIRECT load in DB
Thanks
December 23, 2011 - 2:49 pm UTC
nologging would not produce that sort of error, that is more likely a corrupt redo log file - apply one of your multi-plexed copies of that redo log file.
1) it won't affect the recovery actually, it will affect the ability to retrieve the data after recovery. Anything that was NOT in the redo log files will not be in the datafiles. It wouldn't break the recovery process. It would cause errors later when selecting the data.
2) yes, because it would read the datafiles - which have all of the data in them. The redo would not be needed.
3) correct.