emc backup and recovery for oracle database 11 g l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
EMC Backup and Recovery for Oracle Database 11 g PowerPoint Presentation
Download Presentation
EMC Backup and Recovery for Oracle Database 11 g

Loading in 2 Seconds...

play fullscreen
1 / 30

EMC Backup and Recovery for Oracle Database 11 g - PowerPoint PPT Presentation


  • 457 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'EMC Backup and Recovery for Oracle Database 11 g' - Gabriel


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
emc backup and recovery for oracle database 11 g

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

agenda
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
slide3

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

what is a proven solution
What is a Proven Solution?

Functionality

Performance

Interoperability

Scalability

emc proven solutions documentation
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
emc proven solutions centers

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
configuration one components
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
configuration two networker backup to data domain via nfs
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
configuration two components
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
data domain impact on storage
Five week period full backups of 1TB databaseData 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
data domain impact on backup process
Single restore greatly improves RTOData 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
a look at incremental merge
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

configuration three networker backup to data domain via fibre channel
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

configuration three components
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
emc data domain impact on storage
Five week period full backups of 1TB databaseEMC 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
emc data domain impact on restore times
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
performance cpu centric vs spindle bound
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

scalability data domain systems trajectory

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)

why data domain
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
industry s most scalable inline deduplication systems
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

why emc backup and recovery for oracle
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

slide29

For More Information:Stop by EMC Booth #901 Backup and Recovery Solutions Workstation Global Solutions Workstation

http://www.datadomain.com/solutions/oracle.html