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

Creating duplexed backups

By default, RMAN will create only a single copy of the backup but it is always advisable to have more than one copy of the backup because, as Murphy's law says, if something can go wrong, it will. To safeguard from a situation where you have lost the one and only copy of the backup, you can create multiple copies of the backup piece within your backup set with a maximum of four copies allowed.

Note

The option for duplexed backups is possible only for backup pieces and not for image copies. Also, the auto backup of the control file is never duplexed.

To understand this feature, let's configure the duplexed backup to two copies for a tablespace and take its backup:

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK ...

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