Monday, October 1, 2012

Why you should use Oracle RMAN for backups and recovery

  • You can take advantage of the powerful Data Recovery Advisor feature, which enables
    you to easily diagnose and repair data failures and corruption
  • There are simpler backup and recovery commands
  • It automatically manages the backup files without DBA intervention
  • It automatically deletes unnecessary backup datafiles and archived redo log files both
    from disk and tape
  • It provides you with detailed reporting of backup actions
  • It provides considerable help in duplicating a database or creating a standby database
  • It lets you test whether you can recover your database, without actually restoring data
  • It lets you verify that available backups are usable for recovery
  • It lets you make incremental backups, which isn’t possible by any other means of
    backup
  • It lets you perform database duplication without backups by using the network-enabled database duplication feature, also known as active duplication
  • It automatically detects corrupt data blocks during backups, with the corruption rele-vant information recorded in the V$DATABASE_BLOCK_CORRUPTION view
  • When only a few data blocks are corrupted, you can recover at the data block level,
    instead of recovering an entire datafile
  • You can take advantage of the unused block compression feature, wherein RMAN skips
    unused data blocks during a backup
  • Only RMAN provides the ability to perform encrypted backups
  • You can use RMAN with a variety of third-party storage systems
  • You can use a powerful yet easy-to-use scripting language, which lets you write custom
    backup and recovery scripts quickly

No comments:

Post a Comment