1 / 30

EMC Backup and Recovery for Oracle Database 11 g

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. Agenda. Leveraging Oracle Backups with EMC Data Domain

Gabriel
Download Presentation

EMC Backup and Recovery for Oracle Database 11 g

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EMC Backup and Recovery for Oracle Database 11g Jeff Browning, Oracle Solutions Consultant EMC Global Solutions Centers Mel Shum, Technical Marketing Engineer EMC Backup Recovery Systems Division

  2. 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, NetWorker backup over NFS to Data Domain • Database on SAN, NetWorker backup over Fibre Channel to Data Domain • Why EMC Data Domain • Summary

  3. 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 + 1 TB + + 1 TB Week 1 Week 2 Week 3 Enables full restores With deduplication Initial Full 500 GB Changed Data

  4. What is a Proven Solution? Functionality Performance Interoperability Scalability

  5. 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

  6. Hopkinton, MA Santa Clara, CA Cork, Ireland Vienna, Austria Shanghai, China Singapore EMC Proven Solutions Centers • Global presence • Real world environments • Cross organization and platform skill sets • Quality processes • Local and global focus

  7. Configuration OneRMAN backup to Data Domain via NFS

  8. EMC Celerra NS480 Fully integrated NAS array with CLARiiON back end, providing both NAS (NFS, CIFS) and SAN (FCP, iSCSI) EMC Data Domain DD660 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 Configuration One Components

  9. The solution tested was based on a 200 GB Oracle OLTP order entry database Database Environment Tested

  10. Backup Performance Impact

  11. Restore / Recovery Time

  12. Configuration TwoNetWorker backup to Data Domain via NFS • The backup process off-loaded to an EMC NetWorker proxy host using Navisphere® SnapView clones • Mount replica to the proxy node • Backups executed on proxy node to Data Domain via NFS

  13. EMC CLARiiON CX4 Fully automated storage tiering, Flash drives, Virtual Provisioning, 64-bit operating system, and multi-core processors EMC Data Domain DD880 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 CLARiiON storage infrastructure EMC NetWorkerand NetWorker 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 Configuration Two Components

  14. The solution tested was based on a 1 TB Oracle OLTP order entry database Database Environment Tested

  15. Five week period full backups of 1TB database Data Domain Impact on Storage • 24 TB of backup data over 5 week period • RMAN level 0 (full) backups • 92% net savings of storage space • 13:1 deduplication ratio

  16. Single restore greatly improves RTO Data Domain Impact on Backup Process • Without Data Domain • Full and incremental’s • Multi-stage restore operation • With Data Domain • A full only backup schedule • Single restore

  17. A Look at Incremental Merge • Nightly take cumulative incremental; apply to snapshot of weekly full First image backup2X storage savings • Results in up-to-date nightly full images available for rapid recovery DB Full Snap Snap Snap Snap Snap Incremental Snap Mon Tue Wed Thu Fri Sat Sun

  18. Configuration ThreeNetWorker backup to Data Domain via Fibre Channel • The backup process off-loaded to an EMC NetWorker proxy host using Navisphere® SnapView clones • Mount replica to the proxy node • Backups executed on proxy node to Data Domain VTL via Fibre Channel • LAN-less backup EMC Data Domain DD880

  19. EMC CLARiiON CX4 Fully automated storage tiering, Flash drives, Virtual Provisioning, 64-bit operating system, and multi-core processors EMC Data Domain DD880 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 CLARiiON storage infrastructure EMC NetWorkerand NetWorker 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 Configuration Three Components

  20. The solution tested was based on a 1 TB Oracle OLTP order entry database Database Environment Tested

  21. Five week period full backups of 1TB database EMC Data Domain Impact on Storage • 10 TB of backup data over 5 week period • RMAN level 0 (full) on weekends • Level 1 (diff. incremental) Mon-Thurs • 84% less storage fornightly full backups • 6:1 deduplication ratio

  22. 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

  23. EMC Backup and Recovery for Oracle Solution features and business impact

  24. Performance: CPU-Centric vs. Spindle-Bound Data Domain 1,500 SATA Fibre Channel Most deduplication vendors Throughput MB/s 50 50 100 150 200 Number of Disk Spindles

  25. Multi-controller systems with global deduplication 5 Distributed processing for single-controller systems 3 1.5 0.04 1.25 70 > PB Scalability: Data Domain Systems Trajectory Data Domain SISL Scaling Architecture: CPU-Centric 2011 (est.) Throughput GB/s DD880, July 2009 Industry’s fastest backup storage controller DD200 (2004) Addressable capacity in terabytes post-RAID (physical)

  26. 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

  27. Industry’s Most Scalable Inline Deduplication Systems DD600 Appliance Series DD880 Global Deduplication Array Software Options: DD Boost, DD Virtual Tape Library, DD Replicator, DD Retention Lock, and DD Encryption DDX Array Series Up to 16 Controllers DD140 Remote Office Appliance

  28. 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 NetWorker 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

  29. For More Information:Stop by EMC Booth #901 Backup and Recovery Solutions Workstation Global Solutions Workstation http://www.datadomain.com/solutions/oracle.html

More Related