Also remember that only bulk operations are actually nologging. Normal deletes,inserts and etc are still fully logged.
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/
We had a database with some tablespaces marked as nologging
Sys admin. copied files from backup on top of those files (hot backup)
Tablespaces with "nologging" complianed about needing media recovery.
Is the only way to circumvent this problem be to backup immediately after loads?
Question: Would flash recovery assist in recovery when datafiles are deleted or corrupted?
________________________________ How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ -- //www.freelists.org/webpage/oracle-l
