Joe Boylan, Guest Blogger and Advisory Systems Engineeer, EMC Backup Recovery Systems
Joseph Boylan, Advisory Systems Engineer, EMC Backup Recovery Systems, and member of EMC Global Database Specialist team, knows databases. Working with some of EMC’s largest customers in the Northeast and Canada, and across North America, Joe helps organizations identify and solve database backup issues. He walks customers through his version of the Repeat Test.
At the Backup and Archive Booth at EMC World last night, Joe talked with attendees about application-driven backups and new Data Domain 5.3 Oracle-aware deduplication. In the following guest post, Joe shares his insight about protecting large-scale Oracle databases. Information that is sure to change your game.
* * * *
There’s no question users are very excited that they can improve performance of protecting large Oracle databases by increasing Oracle file per set/multiplexing tuning options without impacting deduplication rates. I see it when I engage with customers across the country, and I experienced it first-hand last night at the @EMCBackup booth.
And here’s why.
The customers I work with are in the process of transforming their IT organizations into internal service providers, and being able to provide performance-optimized application-driven backups is critical to this process. Without making advancements toward application-driven techniques, IT organizations will be challenged to continue to meet the significant growth challenges and the shortening of backup windows.
After joining EMC, the first major project I worked on was a mission-critical Oracle data warehouse; the system took more than two days to back up and was failing to meet SLAs, which dictated daily full backups for optimum recovery capabilities. This posed two challenges: First, how to reduce current backup times to acceptable service levels and, second, how to keep them there.
Many organizations that I have met with are in similar situations. Their mission-critical applications are growing at 50% to 100% a year—and this is putting more and more demand on infrastructure and is driving administrators to look for smarter ways of achieving data protection.
By deploying Oracle Incrementally updated backups with Data Domain, we were able to reduce backup times by 75%. Traditionally, administrators avoided this technique due to RMAN’s merge process overwriting the previous full backup; however, with EMC’s integration and pointer-based copy mechanisms, we were able to perform rapid backups while keeping as many backup data sets as we needed for data retention. And leveraging EMC’s deduplication technology, we were able to keep backup storage cost under control while benefiting from full backup images daily.
Oracle Incrementally updated backups are tremendously efficient and with the use of Oracle Block Change Tracking, RMAN keeps a record of all the changes to the datase. As an example, one of the clients I worked with had a 70TB database (and growing at 100% yearly) with daily changes of 500GB to 1.5TB. This solution allowed the DBA team to back up 500GB to 1.5TB daily while having a full 70TB image daily; it also dramatically reduced backup times. Big benefits!
This is a superior solution for large databases. The architecture coupled with Data Domain’s best-of-breed performance empowers DBAs with the ability to dynamically allocate needed channels and multiplexing for optimizing both backup and recovery while not being bound by the physical media and tape drive boundaries of legacy approaches. Since this method leverages image copy and the data is in native format/exact copies of the database files and logs, DBA’s can easily grab the files they need for recovery or mount the backups residing on the Data Domains via Oracle and drill more granular a d restore rows or tablespaces.
With increases of business dependency on application availability and extraordinary data growth, the requirements for improved data protection techniques are a must as the legacy methods are dated and struggling to provide adequate protection. If you’re at EMC World this week, stop by our Booth. We’d love to walk you through the benefits:
- Dramatically improved backup and restore times
- Native application format for flexible recovery options
- Simplified data management
- Improved DR management and visibility
For more information visit http://www.emc.com/backup-and-recovery/backup-for-oracle.htm.