EMC Backup Recovery Systems

1. EMC Backup Recovery Systems Transforming Oracle RMAN Backup & Recovery OUG Scotland 2013 Scott Butler Advisory Systems Engineer EMC BRS

2. Disk and Tape Capacity required to store many copies of Oracle backups Bandwidth required to move large database backups across WAN for Disaster Recovery Oracle database recovery operations demand extremely reliable disk storage let alone countless tape media Integration and management of RMAN and backup infrastructure Data Protection Challenges for Oracle

3. Deduplication Enables Online Retention Efficiently store weeks of backups on disk for rapid database restores Reduce dependence on tape for Oracle data protection Replication Drives WAN-efficient Disaster Recovery Time-to-DR minimized, enabling offsite recovery of databases Data Invulnerability Architecture Ensures Reliable Recovery Provides much higher levels of hardware and software protection than conventional tape, RAID and file systems Flexible Integration with Oracle Provides multiple interface options (NAS, Boost, VTL) for use with Oracle data-protection best practices EMC BRS for Oracle Data Protection

4. Purpose Built Backup Appliances (PBBA) Open Systems + Mainframe Capacity EMC 64.9% 2012 Total Market 1,340PB

5. PBBAs Transform Backup Reliably Meet Backup Windows And Recovery SLAs SPEED 10-30x Less Backup Storage, Consolidate And Simplify EFFICIENCY • Up To 99% Bandwidth Efficiency Eliminates Trucking Tapes For DR SMARTER DR

6. EMC BRS Oracle RMAN Backup Options • Data Domain enables the industry’s most advanced and flexible Oracle backup solutions for DBA’s • Direct backups using DD Boost for RMAN enables the fastest and most efficient backup and recovery • Direct backups via NFS, dNFS and CIFS • Backup Apps with DD Boost for Avamar • Backup Apps with DD Boost for NetWorker • Collaborative backups between DBA and Backup Admin • Flexibility enables customers to choose the best approach for their environment

7. Data Domain Introduction

8. Introduction to Data Domain Data Domain Functionality Control Tier Backup and Archive Applications Target Tier Disaster Recovery Tier IBM EMC Symantec CommVault HP Dell CIFS, NFS, NDMP, DD Boost Ethernet Virtual Tape Library (VTL) or DD Boost over Fibre Channel Replication Data Domain System Data Domain System

9. Thurs Incremental A C K Second Friday Full Backup Friday Full Backup Mon Incremental A B H B C D E F L G H A B C D A E F G Tues Incremental Weds Incremental C E B G J I A B C D E F G Introduction to Data Domain Data Deduplication: Technology Overview Backup Estimated Data Logical Reduction Physical FRIDAY FULL 1 TB 2–4x 250 GB Monday Incremental 50 GB 7–10x 5GB Tuesday Incremental 50 GB 7–10x 5GB Wednesday Incremental 50 GB 7–10x 5GB Thursday Incremental 50 GB 7–10x 5GB Second FRIDAY FULL 1 TB 50–60x 18 GB TOTAL 2.2 TB 7.6x288 GB H I J K L

10. Introduction to Data Domain SISL Scalable Architecture DD990 (2012) 8000 Throughput MB/sec. • From DD200 to DD990: • Throughput: ~200x • Capacity: ~450x DD200 (2004) 40 >PB 1.25 570 Addressable Capacity in TB Post-RAID (Physical)

11. Generate Checksum Verify Data Re-Checksum and Compare Verify the file system metadata integrity File System Deduplication Verify user data integrity Local Compression Verify stripe integrity RAID Introduction to Data Domain Data Integrity: Data Invulnerability Architecture • End-to-end data verification • Checksum • Deduplication, write to disk • Verify • Self-healing file system • Cleaning • Expired data • Defrag • Verify • Other • RAID 6 • NVRAM • Snapshots End-to-end data verification

12. WAN Home Home Introduction to Data Domain Network Efficient Replication for True Disaster Recovery • Flexible replication • One-to-many • Many-to-one • Bi-directional • System-to-system • Cascaded 1–5% DB Data Domain system Archive data 1–5% Backup data Data Domain system 1–5% Data Domain DD890 Data Domain system Destination: Data Center Hub Supports hundreds of remote sites Source: Remote sites 95–99% cross-site bandwidth reduction

13. Introduction to Data Domain Data Domain BOOST • Distributes parts of deduplication process to backup server or application clients • Increases aggregate throughput by up to 2x • Enables more efficient resource utilization • Provides application control of Data Domain replication process • Supports majority of backup software market and native utilities in industry-leading database utilities DD Boost

14. Introduction to Data Domain Protection Storage: EMC Data Domain for Backup and Archive Data • Low $$/Petabyte • Efficient backup and archive storage with deduplication technology • Reliability: Storage of last resort • Data Invulnerability Architecture • RAID 6 • Fast, Efficient Scalability with data growth • Industry-leading ingest of backup and archive data • Up To 100 PB of logical capacity in a single system • Efficient and Scalable Disaster Recovery • Reduce bandwidth requirements by up to 99 percent • Replication from up to 270 remote systems to a single system • Seamless Integration • Qualified with all leading backup and archive applications • Encryption and compliance retention requirements • Meets compliance requirements for archive retention • Both internal and external key management with RSA Backup Data Archive Data

15. Oracle Backup with Data Domain Boost

16. Oracle Backup and Recovery RMAN Directly Over Data Domain Boost Database Admin Oracle Database Oracle RMAN DD Boost Data Domain System

17. LAN DD Boost For RMAN What Gets Distributed? Without DD Boost 1 ID Segment 2 Unique? 3 Compress 4 Write RMAN Oracle Server

18. LAN DD Boost For RMAN 50% Faster Backups 20 to 40% Lower CPU Utilization 99% Less LAN Bandwidth What Gets Distributed? With DD Boost 1 ID Segment 2 Unique? 3 Compress 4 Write RMAN DD Boost Oracle Server

19. Data Domain Replication Without DD Boost managed file replication Oracle Server Replicate RMAN Catalog Copy 1 Copy ? Copy 1 Copy ? RMAN Is Not Aware Of Copy 2

20. DD Boost Managed File Replication With DD Boost managed file replication Oracle Server DD Boost RMAN Catalog Copy 1 Copy 2 Copy 1 Copy 2 RMAN Controls The Creation of Backup Copies All Copies Are Cataloged By RMAN

21. DD Boost Advanced Load Balancing & Failover Without Advanced Load Balancing & Failover Oracle Server A Oracle Server B Oracle Server C Each Server Connects on a Dedicated Link No Ability To Balance Streams Across Network Links Job Failures From Network Failures

22. DD Boost Advanced Load Balancing & Failover With Advanced Load Balancing & Failover Oracle Server A DD Boost Oracle Server B DD Boost Oracle Server C DD Boost All Servers Connect To The Same Interface Streams Load Balanced Across Network Links Transparent Link Failover For Network Failures

23. Oracle Backup using RMAN Incremental Merge with Data Domain

24. Oracle RMAN Incremental Merge To traditional SAN or NAS storage Full Full Full Full Full Full Full Full Full Full Full Full DB Full • Enables full recovery from the latest merge, lose all previous fulls • Making a copy of a full each day is costly Incremental Mon Tue Wed Thu Fri Sat Sun

25. Oracle RMAN Incremental Merge Impact of EMC Data Domain with Fastcopy feature Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full DB Full Full • Quickly creates a copy of last full using a fraction of storage • Maintain full copies for each day enabling easier recovery Fastcopy Incremental Mon Tue Wed Thu Fri Sat Sun

26. Data Domain for Oracle RMANBoost versus NFS/dNFS • Consider RMAN with • Data Domain Boost when: • Full backups are recommended; especially w/ high change rate * • Time to scan entire database is not a concern • NFS security or mount point failure is a concern • RMAN managed DR is a requirement • Oracle 10g and 11genvironments • Consider RMAN via NFS/dNFS with Data Domain when: • Incremental merge ispreferred when change rate is low * • Time to scan entire database is a concern • Network link failure is rare or job restart is acceptable • Backup/Restore is the only requirement; DR is not • When the environment is Oracle 11g withdNFS • DBA’s have complete control over their own Database Backups & Recoveries and with a greater number of backup copies stored * Oracle recommends full if incremental is more than 20%

27. The EMC BRS, RMAN Catalog Assessment • Engage with your local EMC BRS Systems Engineer to better understand the health and statistics of your Oracle backups • Identify slow database backups and frequent failures • Helps to provide sizing inputs to accurately size a new Oracle tape free backup solution • Size of 1 day’s full backup across all databases • Size of 1 day’s archive log backups across all databases • Identify daily change rate • Identify whether compression and/or encryption are in use

28. A happy customer… “Thanks to Data Domain, backup performance has been significantly enhanced, while data storage requirements have been reduced by 96 percent…The DBAs have control of their backups and they are very happy with that.” Nancy Magers Associate Director for Disaster Recovery Brown University

29. and another happy customer… “In a private cloud, you have to look at the storage and backup as hand in glove because of the shared infrastructure. With EMC Data Domain, its been a seamless process to integrate backup with our virtualized infrastructure. We haven’t had a single issue, and our Oracle backups and restores are so much faster and easier to manage.” Tony Vaden Vice President and CIO American Tire Distributors

30. For more information… http://www.emc.com/collateral/hardware/white-papers/h10683-dd-boost-oracle-rman-tech-review-wp.pdf http://www.emc.com/backup-and-recovery/data-domain/index.htm http://www.emc.com/collateral/software/white-papers/h7219-data-domain-data-invul-arch-wp.pdf http://www.emc.com/collateral/analyst-reports/idc-worldwide-purpose-built-backup-appliance.pdf

31. Q&A

33. Oracle dNFS (Direct Network File System) • New in Oracle 11g • To enable, you must still NFS mount the remote storage on NAS or Data Domain (using OS). • Oracle configuration files tell Oracle database to manage NFS read/write via Oracle kernel rather than operating system. • dNFS aggregates NIC cards with no OS config needed. Great performance.