Emc backup and recovery for oracle database 11 g l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 30

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


  • 365 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

EMC Backup and Recovery for Oracle Database 11 g

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

What is a Proven Solution?

Functionality

Performance

Interoperability

Scalability


Emc proven solutions documentation l.jpg

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 l.jpg

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 rman backup to data domain via nfs l.jpg

Configuration OneRMAN backup to Data Domain via NFS


Configuration one components l.jpg

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


Database environment tested l.jpg

The solution tested was based on a 200 GB Oracle OLTP order entry database

Database Environment Tested


Backup performance impact l.jpg

Backup Performance Impact


Restore recovery time l.jpg

Restore / Recovery Time


Configuration two networker backup to data domain via nfs l.jpg

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 l.jpg

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


Database environment tested14 l.jpg

The solution tested was based on a 1 TB Oracle OLTP order entry database

Database Environment Tested


Data domain impact on storage l.jpg

Five week period full backups of 1TB database

Data 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 l.jpg

Single restore greatly improves RTO

Data 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 l.jpg

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 l.jpg

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 l.jpg

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


Database environment tested20 l.jpg

The solution tested was based on a 1 TB Oracle OLTP order entry database

Database Environment Tested


Emc data domain impact on storage l.jpg

Five week period full backups of 1TB database

EMC 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 l.jpg

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


Emc backup and recovery for oracle solution features and business impact l.jpg

EMC Backup and Recovery for Oracle Solution features and business impact


Performance cpu centric vs spindle bound l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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

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


  • Login