what are the benefits of using RMAN?

@ : Home > > Interview Room

Here’s a brief description of the important benefits of using RMAN instead of usermanaged backup and recovery techniques:

  • 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 relevant 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
Alert me