Traditional ERP and CRM business applications are under constant pressure to protect and recover data in the shortest possible time. Organizations are greatly interested in achieving high throughput, low CPU utilization, fast backup and recovery time, low storage I/O response time, and so on. However, Oracle DBAs and other data center staff are also interested in achieving high data compression for Oracle backup sets, high network and storage throughputs, and high storage IOPS during the backup and restore times.
Dell EMC has designed a series of backup and recovery tests by using RAC OLTP databases on a Data Domain appliance. The backup and recovery of OLTP databases is of great importance as data stored in OLTP is loaded with a huge volume of organization-wide transactional or inventory data that supports mission-critical back-office applications. Faster response and recovery of this data is of particular importance, especially during longer database downtime.
During this testing we used the Data Domain DD6300 system with DD Boost. This configuration has yielded superior performance for over 10 years in many challenging situations.
The Data Domain system with DD Boost software enhances the speed of backup and recovery with high levels of deduplication and compression. This method accelerates speed and offers space savings with increased reliability of data restoration and recovery. In our test environment, we performed multiple tests in different use cases and achieved impressive results.
Our benchmark for success requires that the backup and recovery time is below 40 minutes for 1 TB of data with higher storage throughput under all circumstances, that space savings is 28 percent or more, and that the storage throughput is 450 MB/sec or more.