Backups in Data Guard environment

Originally posted on “Databases at CERN” blog

Physical standby databases seem to be ideal candidates for offloading backups from primary ones. Instead of “wasting” resources (unless you’re already using Active Data Guard for example), you could avoid affecting primary performance while backing up your database, especially if your storage is under heavy load even during normal (user- or application-generated) workload. So, if you’re seeking for good reasons to convince your boss/finance department/etc. that having standby database(s) is a must in your environment, ability to offload backups from primary databases would be for sure important (apart from usual ones, related to disaster recovery, etc.).

Continue reading “Backups in Data Guard environment”