1© copyright 2010 emc corporation. all rights reserved. keep oracle data safe – emc protects your...
TRANSCRIPT
1© Copyright 2010 EMC Corporation. All rights reserved.
Keep Oracle Data Safe – EMC Protects Your Cloud
2© Copyright 2010 EMC Corporation. All rights reserved.
Today's Discussion• EMC, Oracle and Your Cloud
• Oracle Backup and Recovery Challenges
• Transformational Backup Model
• Deduplication Impact in an Oracle Environment
– EMC Data Domain– EMC NetWorker– EMC Avamar
• EMC Proven Solutions for Oracle
3© Copyright 2010 EMC Corporation. All rights reserved.
Unique EMC | Oracle Investments
Joint Beta Testing and Validation
Joint Best Practices and Solutions
Technology Centers
1995 Present
Joint Escalation Center
Product Integration
Internal IT Usage
MATURITY OF THE ALLIANCE
INV
ES
TM
EN
T
4© Copyright 2010 EMC Corporation. All rights reserved.
EMC Meets the Needs of Oracle Customers
• Lower cost – virtual pools of Oracle IT assets increase utilization and automation
• Higher service levels - makes it faster to deploy new Oracle-based apps and keep them protected and online
• Increased agility – share virtual resource pools allows Oracle IT as a service
5© Copyright 2010 EMC Corporation. All rights reserved.
What Does Your Cloud Need?• Great Storage With Innovative Tiering
– VMAX, VNX – Run Oracle up to 3X faster
– FAST VP– Improve Oracle performance by 44% with lower costs
• Outstanding Replication– Replication Manager, RecoverPoint – Recover in
Minutes, not Days
• Industry Leading Virtualization
• Flawless Data Protection – EMC Backup and Recovery Systems
6© Copyright 2010 EMC Corporation. All rights reserved.
The Backdrop for Data Protection Explosive data growth
• Typically represents a factor of 4 to 30 times production capacity
• Daily, weekly, and monthly full backups kept for months or years
7© Copyright 2010 EMC Corporation. All rights reserved.
Oracle Backup and Recovery Challenges• Managing capacity required to store many copies of
Oracle backups– Typically 10-20x amount of source data
• Recovery from tape– Cumbersome and operationally intensive
• Protecting archive logs– Backups monopolize tape infrastructure
• Enabling disaster recovery (DR)– Massive bandwidth required across WAN , especially for large
database backups
8© Copyright 2010 EMC Corporation. All rights reserved.
Transforming Your Oracle Backup Environment
WAN
Retain longerKeep backups onsite longer with less disk for fast, reliable restores, and eliminate the use of tape for operational recovery.
Replicate smarter Move only deduplicated data over existing networks for up to 99% bandwidth efficiency and cost-effective DR.
Recover reliablyContinuous fault-detection and self-healing ensure data recoverability to meet SLAs.
9© Copyright 2010 EMC Corporation. All rights reserved.
Backup and Recovery Architectures:
In Transition from Tape to DiskBackup/Recovery
Architecture
on premise off premise
Conventional(Tape-centric)
Transformational(Disk-centric)
Backup/MediaManager
Onsite Backup Storage
Disaster RecoveryStorage
Application BackupClients
Deduplication backup software and system
Backup software VTL VTL/Tape
Backup software Tape Tape
Deduplication storage Deduplication storageBackup softwareBackup softwareHome
DB
Data Protection Management Software
NetWorker
NetWorker
NetWorker Data Domain
Avamar
Disk Library
Data Protection Advisor
Data Domain
10© Copyright 2010 EMC Corporation. All rights reserved.
Applying Deduplication to Oracle
Initial Full
Changed Data
Week 1 Week 2 Week 3
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 ++
With deduplication
500 GB
Enables full restores
11© Copyright 2010 EMC Corporation. All rights reserved.
EMC Data DomainEasy integration with existing environment
Replication
CIFS, NFS, NDMP, DD Boost
Ethernet
Virtual Tape
Library (VTL) over
Fibre ChannelDD880 appliance
Control Tier
Target Tier Disaster Recovery Tier
4U 2 to 6 ports 10 and 1 Gigabit Ethernet; 4 Gb/s Fibre Channel RAID 6 5.4 TB to 142.5 TB usable capacity with shelves 1 TB or 500 GB 7.2k rpm SATA HDD in shelf File system NVRAM N+1 fans and redundant, hot-plug power supplies
DD880 appliance
Backup and Archive Applications
12© Copyright 2010 EMC Corporation. All rights reserved.
EMC Data DomainRMAN disk-only backup and recovery strategies
ProductionDatabase
Dev/TestDatabases
DRDatabases
DR Restores can be performed
manually or automated via
scripts
RMAN backups are performed
natively via NFS/CIFS
Data Domain Deduplication Storage
Operational Restores can be leveraged for Dev/Test
environment refresh
RMAN backups are replicated automatically using minimal bandwidth
Data Domain Deduplication Storage
• Simplifies the backup process
– RMAN disk-only backup and recovery strategies are more straightforward
• Leverages Oracle Enterprise Manager
– GUI for managing backups, restore points, creating backup reports, etc
• Supports other Oracle backup capabilities
– Incremental merge– Flash Recovery
13© Copyright 2010 EMC Corporation. All rights reserved.
Sun Wed ThuMon Tue SatFri
DB Full
Incremental
FullFull Full FullFullFull Full
Full FullFull FullFull
• Enables full recovery from the latest merge, lose all previous fulls• Keeping daily fulls would require making another copy of full each day
RMAN Incremental MergeMerge daily incrementals with previous full, creates a new full
14© Copyright 2010 EMC Corporation. All rights reserved.
Sun Wed ThuMon Tue Fri
DB
Incremental
Fastcopy
RMAN Incremental MergeImpact of EMC Data Domain deduplication
Sat
• Quickly creates a copy of last full using a fraction of storage• Can recover from full backup each day
Full
Full Full Full Full Full Full
15© Copyright 2010 EMC Corporation. All rights reserved.
• Backup application associates policies to RMAN jobs and manages schedules, retention, etc.
• Enhanced media management to accommodate copy to tape
• Wizard-driven configuration and canned scripts
• Facilitates managing different retention levels on disk and tape
EMC Data DomainRMAN integration with third-party backup
Qualified with the most widely used third-party backup applications
16© Copyright 2010 EMC Corporation. All rights reserved.
Data Domain Impact in Oracle EnvironmentsCN Rail – A large Canadian freight railroad
• RMAN to NFS mounts on replicated EMC Data Domain systems
• 4 week retention schedule
– 10% average daily change rate, archive logs backed up hourly
• All database backups replicated to SunGard
Virtual
Used
Sustained deduplication ratios of >6:1 (includes archive logs)
17© Copyright 2010 EMC Corporation. All rights reserved.
EMC NetWorker for OracleEnsured recoverability. Unified control.
• Enterprise performance, scalability and security
• Simplifies Oracle backup and recovery
• Wizard-driven configuration
• Remote updates via push installation
• Reduces backup impact and required storage
• Deduplication support
• Snapshot management
• Delivers value-added features
• Event-based backup
18© Copyright 2010 EMC Corporation. All rights reserved.
EMC NetWorker with Data DomainNewly-announced functionality
• Tight integration
• Better manage backup processes
• Fully maximize the benefits of disk-based backup systems
• Efficient network replication minimizes reliance on slower tape-based methods
Replication
Target tier Disaster recovery tier
Data Domain
ServerManagementConsole
NetWorker
File Systems and Applications
19© Copyright 2010 EMC Corporation. All rights reserved.
EMC AvamarDeduplication backup solution
• End-to-end, software/hardware solution
• Improves backup window, less network load
• Integrated high availability and reliability
• Flexible deployment options– Avamar Data Store– Avamar Virtual Edition– Agent-only for ROBO
AvamarVM
Full backups, every time – one-step recovery
Higher backup success rate & reliability Increased ROI, lower TCO, less risk
20© Copyright 2010 EMC Corporation. All rights reserved.
Avamar Support for Oracle• Avamar Client for Oracle
Provides full integration with Oracle RMAN
SBT_Tape interface, provided by Avamar, offers direct communication with RMAN
Assures application-consistent, hot backups in archive log mode
• Flexible administration
Run RMAN backups from Avamar, via scheduled (cron) jobs, or from Oracle Recovery Catalog
• Fast backup and recovery
Allocating multiple RMAN channels boosts performance
21© Copyright 2010 EMC Corporation. All rights reserved.
EMC Proven Solutions for Oracle
• Provide tested, documented, and demonstrable solutions with reference architectures and best practices
• Utilize subject matter experts who work closely with customers and who fully support each EMC Proven solution
• Leverage deep, strategic relationships —Cisco, Microsoft, Oracle, SAP, VMware Lower risk and cost of
deploymentAccelerated time to business
impact Higher operational efficiencies
Combine EMC products and services with key third-party offerings
22© Copyright 2010 EMC Corporation. All rights reserved.
Why EMC Backup and Recovery for Oracle
• Enables efficient backup and restores for Oracle
– Store weeks of backups on disk using EMC Data Domain and EMC Avamar 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
23© Copyright 2010 EMC Corporation. All rights reserved.
Resources
Documented reference architectures and configuration guides
Oracle Solution Centers – Reston, VA; Menlo Park, CA; Atlanta GA
EMC Solution Centers – Hopkinton, MA; Santa Clara, CA; Cork, Ireland
www.emc.com/products/category/backup-recovery.htm www.emc.com/oraclesolutionswww.emc.com/virtualizingoracle
24© Copyright 2010 EMC Corporation. All rights reserved.
THANK YOU