Title: Nologging and partition exchange
Paul, After any NOLOGGING operation, please perform an RMAN incremental level=1 backup as soon as possible. Of course, level=0 or full is OK too, but the minimum is a level=1. The time period between the completion of the load and completion of the backup is a window of risk of possible data loss in the event of media failure or corruption, and that window of risk is the tradeoff (i.e. speed vs recoverability) that must be consciously accepted using for the NOLOGGING operation. Hope this helps... Tim Gorman consultant -> Evergreen Database Technologies, Inc. postal => P.O. Box 630791, Highlands Ranch CO 80163-0791 website => http://www.EvDBT.com/ email => Tim@xxxxxxxxx mobile => +1-303-885-4526 fax => +1-303-484-3608 Lost Data? => http://www.ora600.be/ for info about DUDE... Paul.Baumgartel@xxxxxxx wrote: -- //www.freelists.org/webpage/oracle-l |