Best Practice 2: Use RMAN

Many data warehouses, which were developed on earlier releases of Oracle Database, may not have integrated RMAN for backup and recovery. However, just as there are many reasons to leverage ARCHIVELOG mode, there is a similarly compelling list of reasons to adopt RMAN. Consider the following:

  1. Trouble-free backup and recovery

  2. Corrupt block detection

  3. Archive log validation and management

  4. Block Media Recovery (BMR)

  5. Easily integrates with Media Managers

  6. Backup and restore optimization

  7. Backup and restore validation

  8. Downtime-free backups

  9. Incremental backups

  10. Extensive reporting