Whitepaper posted on behalf of Manjunatha Reddy MC, Krishna Kamal Kapa and Wendy Chen.

With database size growing from gigabytes to terabytes, it is always a challenge for database and storage administrators to implement a reliable, efficient, and cost effective backup and recovery solution that protects business-critical applications against downtime and disaster. An efficient backup and recovery solution should not have any impact on application performance, while reducing the Recovery Point Objective (RPO) and Recovery Time Objective (RTO). Storage snapshot technology allows customers to quickly backup and restore large amount of data without jeopardizing data integrity and performance.
In this whitepaper, we address this backup and recovery challenges of providing continuous protection for Oracle data using Dell storage snapshot technology available with Dell™ Compellent™, EqualLogic™, and PowerVault™ storage solutions. Efficient snapshot technology from Dell storage offers zero impact to database performance, while providing zero application downtime during backups. This capability allows administrators schedule more frequent backups that maximize data protection and reduce the recovery time.
Below are the backup and recovery solutions discussed using Dell storage snapshot technology.
  • Offload RMAN backup to backup server
  • Perform point-in-time recovery
  • Perform complete database recovery with zero data loss