Traditionally, the best practice for mission-critical Oracle Database backup and recovery was to use storage-led, purpose-built backup appliances (PBBAs) such as Data Domain, integrated with RMAN, Oracle’s automated backup and recovery utility. This disk-based backup approach solved two problems:
1) It enabled faster recovery (from disk versus tape)
2) It increased recovery flexibility by storing many more backups online, enabling restoration from that data to recover production databases; and provisioning copies for test/dev.
At its core, however, this approach remains a batch process that involves many dozens of complicated steps for backups and even more steps for recovery. Oracle’s Zero Data Loss Recovery Appliance (RA) customers report that total cost of ownership (TCO) and downtime costs (e.g. lost revenue due to database or application downtime) are significantly reduced due to the simplification and, where possible, the automation of the backup and recovery process.
The new disk-based backup products geared to small to medium enterprise (SME) businesses are being enhanced with enterprise-class product features at prices that are getting less and less expensive, making it feasible to back up from disk to removable disks and do away with tape backups altogether. Read this white paper for more information.
Although ESG continues to see the vast majority of IT organizations living within a disk-plus-tape world, no one can argue against the idea that the cloud is becoming a viable and attractive component of any data protection architecture. Modern disk and tape solutions have overwhelming benefits for ROI, but those benefits can often be expanded by leveraging the economics and additional agility capabilities of a cloud tier. And all of those tiers would benefit from smarter data protection and preservation mechanisms through the combination of both backups and archiving.
By utilizing the speed and reliability of the EMC CLARiiON® AX150 networked storage system and the convenience of EMC Retrospect® 7.5 for Windows backup and recovery software, SMBs can implement fast, effective, reliable data protection that is easy to set up and manage without placing undue strain on IT resources.
Once a business clears the financial hurdle and begins to plan their data protection strategy the choices can appear daunting. Do they select tape or disk? Apply differential or incremental backups? How much will a new system cost and how much time will it take to implement? What data should be included in the backup? This article attempts to address these concerns.