EMC Backup and Recovery for Oracle

Report
Keep Oracle Data Safe
– EMC Protects Your
Cloud
© Copyright 2010 EMC Corporation. All rights reserved.
1
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
© Copyright 2010 EMC Corporation. All rights reserved.
2
Unique EMC | Oracle Investments
Internal IT Usage
INVESTMENT
Product Integration
Joint Escalation Center
Technology Centers
Joint Best Practices and Solutions
Joint Beta Testing and Validation
MATURITY OF THE ALLIANCE
1995
© Copyright 2010 EMC Corporation. All rights reserved.
Present
3
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
© Copyright 2010 EMC Corporation. All rights reserved.
4
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
© Copyright 2010 EMC Corporation. All rights reserved.
5
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
© Copyright 2010 EMC Corporation. All rights reserved.
6
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
© Copyright 2010 EMC Corporation. All rights reserved.
7
Transforming Your Oracle Backup
Environment
Retain longer
Keep backups onsite longer with less disk
for fast, reliable restores, and eliminate the
use of tape for operational recovery.
Replicate smarter
WAN
Move only deduplicated data over existing
networks for up to 99% bandwidth efficiency
and cost-effective DR.
Recover reliably
Continuous fault-detection and self-healing
ensure data recoverability to meet SLAs.
© Copyright 2010 EMC Corporation. All rights reserved.
8
Backup and Recovery Architectures:
In Transition from Tape to Disk
Backup/Recovery
Architecture
Conventional
(Tape-centric)
Application Backup
Clients
Backup/Media
Manager
Onsite Backup
Storage
Disaster Recovery
Storage
Backup
NetWorker
software
Tape
Tape
Backup
software
NetWorker
Disk
VTL
Library
VTL/Tape
DB
Home
Backup
software
NetWorker
Deduplication
storage
Data Domain
Transformational
(Disk-centric)
Deduplication backup
software and system
Avamar
Data Domain
Data Protection
Data Protection
Management
Advisor
Software
on premise
© Copyright 2010 EMC Corporation. All rights reserved.
off premise
9
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
10
EMC Data Domain
Easy integration with existing environment
Control Tier
Backup and Archive
Applications
Target Tier
Disaster Recovery Tier
CIFS, NFS,
NDMP, DD Boost
Ethernet
Replication
Virtual Tape
Library (VTL) over
Fibre Channel
DD880 appliance









© Copyright 2010 EMC Corporation. All rights reserved.
DD880 appliance
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
11
EMC Data Domain
RMAN disk-only backup and recovery strategies
• Simplifies the backup process
– RMAN disk-only backup and
Production
Database
Dev/Test
Databases
DR
Databases
recovery strategies are
more straightforward
• Leverages Oracle Enterprise
Manager
– GUI for managing backups,
restore points, creating
backup reports, etc
• Supports other Oracle backup
capabilities
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
DR Restores can
be performed
manually or
automated via
scripts
Data Domain
Deduplication Storage
– Incremental merge
– Flash Recovery
© Copyright 2010 EMC Corporation. All rights reserved.
12
RMAN Incremental Merge
Merge daily incrementals with previous full, creates a new full
DB
Full
Full
Full
Full
Full
Full
Full
Full
Full
Full
Full
Full
Full
• Enables full recovery from the latest merge, lose all previous fulls
• Keeping daily fulls would require making another copy of full each day
Incremental
Sun
© Copyright 2010 EMC Corporation. All rights reserved.
Mon
Tue
Wed
Thu
Fri
Sat
13
RMAN Incremental Merge
Impact of EMC Data Domain deduplication
Full
DB
Full
Full
Full
Full
Full
Full
• Quickly creates a copy of last full using a fraction of storage
• Can recover from full backup each day
Fastcopy
Incremental
Sun
© Copyright 2010 EMC Corporation. All rights reserved.
Mon
Tue
Wed
Thu
Fri
Sat
14
EMC Data Domain
RMAN integration with third-party backup
• 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
© Copyright 2010 EMC Corporation. All rights reserved.
Qualified with the most widely
used third-party backup applications
15
Data Domain Impact in Oracle
Environments
CN Rail – A large Canadian freight railroad
• RMAN to NFS mounts on
replicated EMC Data
Domain systems
• 4 week retention schedule
– 10% average daily
Sustained deduplication ratios of
>6:1 (includes archive logs)
Virtual
change rate, archive logs
backed up hourly
• All database backups
replicated to SunGard
© Copyright 2010 EMC Corporation. All rights reserved.
Used
16
EMC NetWorker for Oracle
Ensured 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
© Copyright 2010 EMC Corporation. All rights reserved.
17
EMC NetWorker with Data Domain
Newly-announced functionality
• Tight integration
File Systems and Applications
• Better manage backup processes
• Fully maximize the benefits of diskbased backup systems
• Efficient network replication minimizes
reliance on slower tape-based
methods
NetWorker
Management
Console
Server
Data Domain
Replication
Target tier
© Copyright 2010 EMC Corporation. All rights reserved.
Disaster
recovery tier
18
EMC Avamar
Deduplication backup solution
Avamar
VM
• 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
 Full backups, every time – one-step recovery
 Higher backup success rate & reliability
 Increased ROI, lower TCO, less risk
© Copyright 2010 EMC Corporation. All rights reserved.
19
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
© Copyright 2010 EMC Corporation. All rights reserved.
20
EMC Proven Solutions for Oracle
Combine EMC products and services with key third-party offerings
• 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 deployment
 Accelerated time to business
impact
 Higher operational efficiencies
© Copyright 2010 EMC Corporation. All rights reserved.
21
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
© Copyright 2010 EMC Corporation. All rights reserved.
22
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/oraclesolutions
www.emc.com/virtualizingoracle
© Copyright 2010 EMC Corporation. All rights reserved.
23
THANK YOU
© Copyright 2010 EMC Corporation. All rights reserved.
24

similar documents