Home > Workload Solutions > Oracle > White Papers > Dell PowerMax 2500 and 8500 Best Practices for Mission Critical Oracle Databases > Data reduction and deduplication example
In the following example, an RMAN duplicate is used to create a host-based copy of an Oracle database. The full details of the example are in Appendix 2. PowerMax data reduction and deduplication example. The following table summarizes the test results:
| Effective Capacity (GB) | Physical Used Capacity (GB) | ||||
Before copy | After copy | Delta | Before copy | After copy | Delta | |
Source SG | 1,402.3 | 1,402.3 |
| 52.3 | 27.7 |
|
Target SG | 0.2 | 1,395.8 |
| 0.0 | 27.8 |
|
Total capacity | 1,402.5 | 2,798.1 | 1,395.6 | 52.3 | 55.5 | 3.2 |
Before the copy, the Oracle data in the source and target storage groups (SG) physically occupied 52.3 GB. Without using the obfuscation feature, the SLOB data is highly compressible by PowerMax, reducing the effective capacity from 1,402.5 GB to 52.3 GB of physical used capacity.
After the host-based copy, although the copy adds 1,396 GB of capacity, only 3.2 GB of physical used capacity was added due to PowerMax deduplication.
This example shows that PowerMax can provide both compression and deduplication benefits for host-based database copies when the source and destination of the data copied are ASM disk groups.