O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using backup optimization

Using this feature, the backup of files; that is, the data files, archived redo logs, and the backup sets which are already backed up to a destination device type will be skipped. Such optimization is very helpful to speed up the backups and reduce the size of the backup sets, especially for read-only tablespaces. Though this is something that should work with the normal BACKUP command, it doesn't! This option works only for the following commands:

  • DATABASE
  • ARCHIVELOG ALL/LIKE
  • BACKUPSET ALL
  • RECOVERY AREA
  • RECOVERY FILES
  • DATAFILECOPY

To see whether or not you have the backup optimization option on, you can use the SHOW command as follows:

RMAN> SHOW BACKUP OPTIMIZATION;

RMAN configuration parameters for database with db_unique_name ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required