Transcript Document
Data Protection for Database Environments Tony Ossege Storage Sales Consultant Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Trend Affecting Data Growth “Keep it all” “Social Media” 45% Average Annual Growth Rate “Big Data & Analytics” “Regulation & Compliance” “Archive” Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Factors Affecting Data Protection Choices Backup Window Data Value Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Recovery Point Objective Recovery Time Objective Integrated Software Many Types of Data Loss to Protect Against User Error Management Error Forgetfulness Malicious Behavior Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Software Error Storage Media Error Storage System Failure Data Center Outage One Solution Does Not Meet All Requirements Wks Days Hrs Mins Secs Secs Mins Hrs Days Data Loss Downtime (Recovery Point Objective) (Recovery Time Objective) Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Wks Tools for Oracle Database Data Protection The Ultimate Integrated Data Protection Solution Software Tools Oracle Enterprise Manager, Database Tools Data Guard & Active Data Guard Data Recovery Advisor, RMAN Operating System Tools Built in Backup and Recovery Tools, Snapshots, Boot Environments Virtualization Tools Oracle Virtual Machine, Enterprise Manager Storage Tools Snapshots, Replication, Archive, Analytics Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Recovery Manager (RMAN) Oracle-integrated Backup & Recovery Engine Oracle Enterprise Manager RMAN Tape Drives Database Fast Recovery Area Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Cloud Intimate knowledge of database file formats and recovery procedures Manages and automates the backup, restore, and recovery policies and process Catalog all backup and recovery activities Operates online and in parallel for fast processing Corrupt block detection during backup and restore with the ability to validate backups Integrated with Enterprise Manager, Oracle Secure Backup, and third party backup products Data Replication Primary Site Data Guard & Active Data Guard Primary Database Synchronous & Asynchronous Data Replication Data protection – continuous synchronization and data validation Data availability – automatic failover to standby database Minimize planned downtime – database rolling upgrades Data Guard included with Oracle Database Enterprise Edition (EE) Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Standby Site Physical or Logical Standby Database Oracle’s Storage Portfolio Database I/O NAS File I/O SAN Block I/O Exadata ZFS Storage Appliance Pillar Axiom Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Tape StorageTek Tape Fastest Time to Restore Database Backup and Recovery Options Exadata Production Exadata Test/Dev/DR Copyright © 2012, Oracle and/or its affiliates. All rights reserved. ZFS Storage Appliance Tape Library Maximum Availability Architecture Complete Replication, Backup and Recovery Solution Data Guard Replication Database Content ZFS Replication Applications & Unstructured Data Primary Data Center Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Secondary Data Center Database with Multi-Level Data Protection Increased Efficiency – Maximum performance for the maximum data with automated storage tiering Improved Performance Oracle Database RAC – Higher application performance by offloading backups and reporting to data protection site Active Data Guard Streamlined Operations – Simpler administration with automated, policy based, tiered storage migration – Active Data Guard and tiered storage ensure Business Continuity and Disaster Recovery across many types of data loss Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Tiered Storage Database Backup to Sun ZFS Storage Appliance Increased Efficiency – Hybrid Columnar Compression reduced data warehouse size by 5x Improved Performance – 10x faster backups support larger data in the same amount of time Streamlined Operations – Direct connection over Infiniband – Fewer administrators for larger amounts of backup data Copyright © 2012, Oracle and/or its affiliates. All rights reserved. RMAN over InfiniBand Database Data Protection to Tape Highly reliable with low operating costs Data protection for all Oracle Database versions running on any servers and primary storage Fault isolation from Oracle Database servers and storage Easy consolidation of all data protection Long media life and WORM capabilities for compliance and long-duration archiving Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Tiered Storage Data Protection Policy Based Storage Archive Manager Fast recovery of recent backups Low-cost, secure retention of data 1 SAN or NAS 3 High reliability and WORM storage for compliance 4 Automatic creation of remote copies for disaster recovery Automatic, application transparent, policy driven, multi-tier migration 2 High Speed Low Cost Disk Disk Long Term Archive SAM Storage Pool Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Remote Storage Oracle On Oracle Value Which Solution Best Meets Your Needs? Short Term or No Data Retention Medium Retention Long Term Retention Encrypted Database Backups Hardware Backup Encryption Non Database Data Data Warehouse Backups RTO RPO Oracle Exadata Storage Expansion Seconds Smallest Granularity Sun ZFS Backup Appliance Seconds Smaller Granularity Oracle Tape Storage Minutes Larger Granularity Best Solution Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Strong Solution Oracle Storage for Oracle Database Data Protection Hardware and Software Engineered to Work Together Efficient: Enables you to buy less storage, and spend less operating it High Performance: Protects and restores data faster than other solutions, protecting growing data sets in less time, with less risk Streamlined: Provides customers a single vendor solution with unique Oracle-onOracle optimizations for their complete data protection needs Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Copyright © 2012, Oracle and/or its affiliates. All rights reserved.