The Data Warehouse Recovery Methodology

Devising a backup and recovery strategy can be a daunting task. When you have hundreds of terabytes of data that must be protected and recovered for a failure, the strategy can be very complex. This section contains several best practices that can be implemented to ease the administration of backup and recovery.

This section contains the following topics:

• Best Practice 1: Use ARCHIVELOG Mode

• Best Practice 2: Use RMAN

• Best Practice 3: Use Block Change Tracking

• Best Practice 4: Use RMAN Multisection Backups

• Best Practice 5: Leverage Read-Only Tablespaces

• Best Practice 6: Plan for NOLOGGING Operations in Your Backup/Recovery Strategy

• Best Practice 7: Not All Tablespaces Should Be Treated Equally