Reducing redo generation
This section shows you how to reduce redo generation using the LOGGING and NOLOGGING operations. The discussion is divided into two parts. In one part, you'll learn about things to do when LOGGING is in effect. In the other, you'll learn what to do when NOLOGGING is enabled.
Tips when LOGGING is in effect (not using NOLOGGING)
This section will cover some interesting tips to reduce redo generation without the need to use NOLOGGING.
Backups
As I mentioned earlier in the Redo generation and recoverability section in Chapter 1, Understanding the Basics of Backup and Recovery, user-managed backups can generate more redo. The best way to eliminate this problem is to use RMAN. RMAN does not need to write entire blocks to redo because it knows when a block is being copied. If you need to use the user-managed backup technique, then you can follow these steps to reduce redo generation:
Do not back up all the tablespaces at once (using the
ALTER DATABASE BEGIN BACKUPcommand)....
