EMC Backup and Recovery for Oracle Database 11
EMC Backup and Recovery for Oracle Database 11 g Jeff Browning, Oracle Solutions Consultant EMC Global Solutions Centers Mel Shum, Technical Marketing Engineer EMC Backup Recovery Systems Division © Copyright 2010 EMC Corporation. All rights reserved. 1
Agenda • Leveraging Oracle Backups with EMC Data Domain – Applying deduplication in an Oracle environment • EMC Proven Solutions • Results of Three Scenarios Tested – Database on NAS, RMAN backup over NFS to Data Domain – Database on SAN, Net. Worker backup over Fibre Channel to Data Domain • Why EMC Data Domain • Summary © Copyright 2010 EMC Corporation. All rights reserved. 2
Applying Deduplication to Oracle Deduplication enables weeks or months of full backups to be stored in about the same space required for a single backup on traditional disk Without deduplication 1 TB + Week 1 1 TB + Week 2 1 TB + Week 3 With deduplication Initial Full Changed Data © Copyright 2010 EMC Corporation. All rights reserved. 500 GB Enables full restores 3
What is a Proven Solution? Functionality Performance Interoperability Scalability © Copyright 2010 EMC Corporation. All rights reserved. 4
EMC Proven Solutions Documentation • Reference architectures – Details about proven configuration – Accelerates end-to-end deployment • Best practices and supporting technical validation – Helps optimize performance – Describes how to install, configure, and integrate the entire solutions offering • EMC Global Solutions lab tested © Copyright 2010 EMC Corporation. All rights reserved. 5
EMC Proven Solutions Centers • Global presence • Real world environments • Cross organization and platform skill sets • Quality processes • Local and global focus Hopkinton, MA Santa Clara, CA © Copyright 2010 EMC Corporation. All rights reserved. Cork, Ireland Vienna, Austria Shanghai, China Singapore 6
Configuration One RMAN backup to Data Domain via NFS © Copyright 2010 EMC Corporation. All rights reserved. 7
Configuration One Components EMC Celerra NS 480 • Fully integrated NAS array with CLARii. ON back end, providing both NAS (NFS, CIFS) and SAN (FCP, i. SCSI) EMC Data Domain DD 660 • Dramatically reduces the amount of disk storage needed to retain and protect enterprise data EMC Celerra Manager • Provides complete control and efficiency managing a Celera storage infrastructure Oracle RMAN • Free, readily available and commonly used Oracle database backup utility Oracle Flashback Recovery Area • Simple, easily configurable disk to disk backup target for RMAN © Copyright 2010 EMC Corporation. All rights reserved. 8
Database Environment Tested The solution tested was based on a 200 GB Oracle OLTP order entry database Profile characteristic Value Benchmark profile Quest Benchmark Factory – TPC-C-like benchmark Response time < 10 ms Read / write ratio 70 / 30 Database scale 1000 warehouses (TPC-C standard) Size of database 200 GB Number of databases 1 Array drives Celerra NS 480 30 300 GB FC (primary database storage 15 2 TB SATA (FRA) Array drives DD 660 12 1 TB SATA (FRA) © Copyright 2010 EMC Corporation. All rights reserved. 9
Backup Performance Impact © Copyright 2010 EMC Corporation. All rights reserved. 10
Restore / Recovery Time © Copyright 2010 EMC Corporation. All rights reserved. 11
Configuration Two Net. Worker backup to Data Domain via NFS • The backup process offloaded to an EMC Net. Worker proxy host using Navisphere® Snap. View clones • Mount replica to the proxy node • Backups executed on proxy node to Data Domain via NFS © Copyright 2010 EMC Corporation. All rights reserved. 12
Configuration Two Components EMC CLARii. ON CX 4 • Fully automated storage tiering, Flash drives, Virtual Provisioning, 64 -bit operating system, and multi-core processors EMC Data Domain DD 880 • Dramatically reduces the amount of disk storage needed to retain and protect enterprise data connected via Ethernet EMC Navisphere Management Suite • Provides complete control and efficiency managing a CLARii. ON storage infrastructure EMC Net. Worker and Net. Worker Module for Oracle • Comprises a high-capacity, easy-to-use data storage management to simplify the backup and restore process EMC Power Path 5. 3 • Intelligently manages I/O paths, and supports multiple paths to a logical device © Copyright 2010 EMC Corporation. All rights reserved. 13
Database Environment Tested The solution tested was based on a 1 TB Oracle OLTP order entry database Profile characteristic Value Database characteristic OLTP Swingbench Order. Entry - TPC-C-like benchmark < 10 ms Benchmark profile Response time Read / Write ratio Size of databases 70 / 30 A Swingbench load that keeps the system running within agreed performance limits 1 TB Number of databases 1 Array drives: size and speed 300 GB 15 k rpm Database scale © Copyright 2010 EMC Corporation. All rights reserved. 14
Data Domain Impact on Storage Five week period full backups of 1 TB database • 24 TB of backup data over 5 week period • RMAN level 0 (full) backups • 92% net savings of storage space • 13: 1 deduplication ratio © Copyright 2010 EMC Corporation. All rights reserved. 15
Data Domain Impact on Backup Process Single restore greatly improves RTO Without Data Domain • Full and incremental’s • Multi-stage restore operation With Data Domain • A full only backup schedule • Single restore © Copyright 2010 EMC Corporation. All rights reserved. 16
A Look at Incremental Merge • Nightly take cumulative incremental; apply to snapshot of weekly full First image backup 2 X storage savings Full Snap DB Snap • Results in up-to-date nightly full images available for rapid recovery Snap Incremental Snap Sun © Copyright 2010 EMC Corporation. All rights reserved. Mon Tue Wed Thu Fri Sat 17
Configuration Three Net. Worker backup to Data Domain via Fibre Channel EMC Data Domain DD 880 • The backup process off-loaded to an EMC Net. Worker proxy host using Navisphere® Snap. View clones • Mount replica to the proxy node • Backups executed on proxy node to Data Domain VTL via Fibre Channel • LAN-less backup © Copyright 2010 EMC Corporation. All rights reserved. 18
Configuration Three Components EMC CLARii. ON CX 4 • Fully automated storage tiering, Flash drives, Virtual Provisioning, 64 -bit operating system, and multi-core processors EMC Data Domain DD 880 • Dramatically reduces the amount of disk storage needed to retain and protect enterprise data – connected via Fibre Channel as a VTL EMC Navisphere Management Suite • Provides complete control and efficiency managing a CLARii. ON storage infrastructure EMC Net. Worker and Net. Worker Module for Oracle • Comprises a high-capacity, easy-to-use data storage management to simplify the backup and restore process EMC Power Path 5. 3 • Intelligently manages I/O paths, and supports multiple paths to a logical device © Copyright 2010 EMC Corporation. All rights reserved. 19
Database Environment Tested The solution tested was based on a 1 TB Oracle OLTP order entry database Profile characteristic Value Database characteristic OLTP Swingbench Order. Entry - TPC-C-like benchmark < 10 ms Benchmark profile Response time Read / Write ratio Size of databases 70 / 30 A Swingbench load that keeps the system running within agreed performance limits 1 TB Number of databases 1 Array drives: size and speed 300 GB 15 k rpm Database scale © Copyright 2010 EMC Corporation. All rights reserved. 20
EMC Data Domain Impact on Storage Five week period full backups of 1 TB database • 10 TB of backup data over 5 week period • RMAN level 0 (full) on weekends • Level 1 (diff. incremental) Mon. Thurs • 84% less storage for nightly full backups • 6: 1 deduplication ratio © Copyright 2010 EMC Corporation. All rights reserved. 21
EMC Data Domain Impact on Restore Times The following chart shows the time duration of a Level 0 full backup, a Level 1 incremental backup, and a full restore of the database using eight RMAN channels © Copyright 2010 EMC Corporation. All rights reserved. 22
EMC Backup and Recovery for Oracle Solution features and business impact Solution Features Business Impact Documents process to offload backup from primary database, enabling a backup without impacting the primary data Ensures data protection requirements are met The solution-validated and documented best practices for Oracle 11 g RAC recovery Ensures rapid recovery with documented best practices Changes the repetitive backup practice of tape, with only unique, new data written to disk The test results show the benefits of data deduplication with a traditional backup strategy implemented using incremental backups © Copyright 2010 EMC Corporation. All rights reserved. 23
Performance: CPU-Centric vs. Spindle-Bound 1, 500 Data Domain SATA Throughput MB/s Fibre Channel Most deduplication vendors 50 50 100 150 200 Number of Disk Spindles © Copyright 2010 EMC Corporation. All rights reserved. 24
Scalability: Data Domain Systems Trajectory Data Domain SISL Scaling Architecture: CPU-Centric Throughput GB/s 5 3 1. 5 0. 04 Multi-controller systems with global deduplication Distributed processing for single-controller systems 2011 (est. ) DD 880, July 2009 Industry’s fastest backup storage controller DD 200 (2004) 1. 25 70 > PB Addressable capacity in terabytes post-RAID (physical) © Copyright 2010 EMC Corporation. All rights reserved. 25
Why Data Domain? • Less disk to resource, less to manage – CPU-centric deduplication – Inline – Green • Simple, mature, and flexible – Simple, mature appliance – Nearline tier: any fabric, any software, backup or nearline applications • Resilience and disaster recovery – Storage of last resort – Cross-site global compression: data center or remote office © Copyright 2010 EMC Corporation. All rights reserved. 26
Industry’s Most Scalable Inline Deduplication Systems DD 600 Appliance Series DD 880 Global Deduplication Array Software Options: DD Boost, DD Virtual Tape Library, DD Replicator, DD Retention Lock, and DD Encryption DD 140 Remote Office Appliance DDX Array Series Up to 16 Controllers Global Deduplication Array DD 140 DD 610 DD 630 DD 670 DD 880 Speed (Other) 450 GB/hr 675 GB/hr 1. 1 TB/hr 3. 6 TB/hr 5. 4 TB/hr Speed (DD Boost) 490 GB/hr 1. 3 TB/hr 2. 1 TB/hr 5. 4 TB/hr 8. 8 TB/hr 12. 8 TB/hr 140. 8 TB/hr Logical capacity 17– 43 TB 75– 195 TB 165– 420 TB 1. 1– 2. 7 PB 2. 8– 7. 1 PB 5. 7– 14. 2 PB 45. 6– 114 PB Raw capacity 1. 5 TB Up to 6 TB Up to 12 TB Up to 76 TB Up to 192 TB Up to 384 TB Up to 3. 07 PB Usable capacity 0. 86 TB Up to 3. 98 TB Up to 8. 4 TB Up to 55. 9 TB Up to 142. 5 TB Up to 285 TB Up to 2. 28 PB © Copyright 2010 EMC Corporation. All rights reserved. DDX Array 86. 4. TB/hr 27
Why EMC Backup and Recovery for Oracle • Enables efficient backup and recovery for Oracle – Store weeks of backups on disk using EMC Data – Domain data deduplication Reduces dependence on tape for Oracle data protection • Simplifies backup operations – Central point of management for Oracle backups to disk or tape using EMC Net. Worker • EMC Oracle expertise – Oracle specialists – More than 70, 000 mutual EMC/Oracle installations • Joint, proven solutions to shorten time to value – Packaged assessment, design, and deployment services © Copyright 2010 EMC Corporation. All rights reserved. 28
For More Information: Stop by EMC Booth #901 Backup and Recovery Solutions Workstation Global Solutions Workstation http: //www. datadomain. com/solutions/oracle. html © Copyright 2010 EMC Corporation. All rights reserved. 29
THANK YOU © Copyright 2010 EMC Corporation. All rights reserved. 30
- Slides: 30