Oracle Data Protection Concepts

Oracle Data

Protection Concepts

Accelerating Transformation

EMC Backup Recovery Systems Division

Matthew Ellis

Advisory Systems Engineer

Agenda

•

Market Conditions.

•

Oracle Data Protection Challenges.

•

Data De-Duplication Fundamentals.

•

EMC Data Domain.

–

Purpose Built Database Backup Appliance

•

Latest Oracle and EMC Solutions

–

Where does the De-Duplication happen?

–

Data Domain Boost.

•

10-30x Less Storage

•

99% Less Bandwidth

•

Reliable Recovery

•

Control And Visibility

Integrated Solutions Takes Oracle Protection To Next Level

EMC Backup And Recovery for Oracle

Purpose Built Backup Appliances

Open Systems + Mainframe Revenue

EMC

IBM

Others

HP

Symantec

Quantum

Source: IDC, Worldwide Purpose-Built Backup Appliance 2012–2016 Forecast and 2011 Vendor Shares , Doc #234489 , Apr

2012 . Above: Worldwide Supplier Revenue for 2011, Total PBBA Market

2011 Total Market

$2.4B

Backup Appliances Disrupts Backup

Market

•

Tape continues to

decline

•

Purpose Built Backup

The Paradigm Shift

•

Data Domain enables the industry’s

most advanced and flexible Oracle

backup solutions for DBA’s

–

Direct backups using DD Boost for

RMAN enables the fastest and most

efficient backup and recovery

–

Direct backups via NFS, dNFS and

CIFS

–

Supports Oracle backups with DD

Boost for Avamar and Networker

Shifting Ownership and Control Over

Backup to Database Administrator

“Businesses go from driving 75 mph down

the freeway to a near standstill. Backup is

the bottleneck, and this must change.”

Stephen Manley, CTO, EMC Backup Recovery Systems

THE

CHALLENGE:

Ensuring Oracle Backup Isn’t A

Oracle Backup and Recovery Challenges

•

Backup Windows - Petabytes

•

Storage Needed For Backup, Test,

Dev, QA, Pre-Prod.

•

Application Consistent Recovery

–

For Virtualized Environments.

•

DBA Control Creates Backup Silos

–

Quotas are needed

Regular Storage Array 1:1

LZ Compression ~ 2:1

Single Instance ~ 3:1

Fixed Block ~ 3:1

Data Reduction Methods

What is Data De-Duplication?

RMAN Catalog

Oracle/Application

Database Server

Oracle RMAN _{Data Domain}Local

System DR Site Data Domain System WAN

Database

Oracle/Application

Database Server

Database

RMAN

This Process illustrates Inline De-Duplication.

Where does the

DD Boost Software

•

Distributes parts of deduplication process to backup

server or application clients

•

Speeds backups by up to 50 percent

•

Enables more efficient resource utilization

•

Provides application control of Data Domain replication

process

•

Distributed segment processing enabled



Anchors and fingerprints segments



Checks with Data Domain system to find which segments

are new/unique



Compresses and sends new segments only



Avoids sending duplicate data to Data Domain system

•

How

•

What

•

Why???

Golden Circle – Why EMC BRS Solutions

Deduplication Changed Everything

Reduce:

•

Backup Times By Up To

90%

•

Data Stored By Up To

30x

•

Data Moved By Up To

95%

•

CPU Usage By Up To

80%

•

Replication Bandwidth By Up To

99%

•

EMC Leads this Market.

•

Variable Length De-duplication

•

Global De-Duplication

•

DDOS Enhancements

Data Domain Product Family

DD160

DD620

DD640

DD670

DD860

DD890

DD990

Speed (DD Boost)

1.1 TB/hr

2.4 TB/hr

3.4 TB/hr

5.4 TB/hr

9.8 TB/hr

14.7 TB/hr

31.0 TB/hr

Speed (other)

667 GB/hr

1.1 TB/hr

2.3 TB/hr

3.6 TB/hr

5.1 TB/hr

8.1 TB/hr

15.0 TB/hr

Logical capacity

40–195 TB

83–415 TB

0.32–1.6 PB

0.6–2.7 PB

1.4–7.1 PB

5.7–28.5 PB

2.9–14.2 PB

5.7–28.5 PB

13–65 PB

Usable capacity

Up to 3.98 TB

Up to 8.3 TB

Up to 32.2 TB

Up to 55.9 TB

Up to 142 TB

Up to 570 TB

Up to 285 TB

Up to 570 TB

Up to 1.3 PB

•

DD Boost

•

DD Encryption

•

DD Extended Retention

Small

Enter./

ROBO

Small

Enter./

ROBO

Midsize Enterprise

Midsize Enterprise

Large Enterprise

Large Enterprise

•

DD Replicator

Data Domain Fundamentals

Easy integration with existing environment

Replication

CIFS, NFS,

NDMP, DD Boost

Ethernet

Virtual Tape

Library (VTL) over

Fibre Channel

DD890 appliance

Control Tier

Target Tier

Disaster Recovery Tier

DD890 appliance

Data Integrity:

Data Invulnerability Architecture

Other

RAID 6

NVRAM

Snapshots

End-to-end data verification

Checksum

Deduplication, write to disk

Verify

Self-healing file system

Cleaning

Expired data

Defrag

Verify

Deduplication

Local Compression

RAID

File System

Generate

Checksum

Verify

Data

Verify the file system

metadata integrity

Verify user data

integrity

Verify stripe integrity

Oracle Backup and Recovery Options

Leveraging Oracle RMAN and Data Domain

Flexible; Easily integrates into existing processes

RMAN - Data Pump writes directly over CIFS/NFS

RMAN writes directly over Data Domain Boost

RMAN integrates with Backup Application

1

Option 1: RMAN – Data Pump Directly over NFS

Leverages Standard or Direct NFS

•

No 3

rd

party backup application

•

Full DBA control of backup and recovery

•

Easy integration with RMAN processes

•

Leverage Data Domain system as disk

LAN

Oracle Server

RMAN

Option 2

RMAN Directly Over Data Domain Boost

Database Admin

Oracle RMAN

Oracle Database

Option 3

RMAN Integrated With Backup Application w/ DD Boost

Database Admin

_{Oracle Database}

_{Backup Admin}

Backup App

DDBoost for RMAN

Oracle/Application

Database Server

Database

Oracle/Application

Database Server

Database

RMAN

DD Boost for Oracle RMAN

•

DBA directly controls backup and recovery

•

Faster, more efficient Oracle backups

•

Catalog aware, centralized disaster recovery

•

Simplified administration

Data Domain

System

Oracle

Database Server

Data Domain

System

Local

Data Center

Recovery Site

Disaster

RMAN Script Sample with Replication

run

{

alocate channel d1type 'sbt_tape‘

parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libddobk.so,ENV

=(ST

ORAGE_UNIT=rmanddboost1,BACKUP_HOST=hostname)';

Allocate channel d2 type 'sbt_tape'

parms='BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libddobk.so,ENV

=(ST

ORAGE_UNIT=rmanddboost1,BACKUP_HOST=hostname)’;

RMAN> backup copies 2 database format '%u_%p', 'destinationsystem/%u_%p‘ filesperset=1;

DATABASE;

}

Note: The storage unit specified in the

With Data Protection Advisor…

Automated, flexible, & efficient backup and recovery management

Payback typical in 12 months

Reduces costs—Insight drives efficiency

DPA & RMAN

•

For RMAN data collection, use an Oracle username that has access to

the RMAN catalog. If a separate Oracle username is created for data

collection, then ensure it has SELECT access to :

•

For Control File and Database monitoring, use an Oracle username

with access to the system catalogs in each instance. DBAs don’t

usually provide sys or sysdba access , so another username can be

setup within oracle and easiest would be to grant

SELECT_CATALOG_ROLE to this user

(grant list is documented in the DPA Admin Guide)

RMAN Recovery Catalog:

rc_backup_set;

rc_backup_datafile;

rc_datafile;

rc_database;

rc_backup_piece;

rc_backup_controlfile;

RMAN Control File:

v$backup_set;

v$database;

v$backup_datafile;

v$datafile;

DPA & RMAN

•

If customers elect to only collect RMAN data, then

Data Domain & Oracle Incremental

Merge

A Paradigm Shift in Performance

DB Size 

Backup Channels 

Backup time 

Replication Completion

TSM 

Oracle Prod1 Full 

24tb 

8

19 ‐ 20 hours

N/A

Oracle Dev1 Full 

10tb 

4

19 Hours 

N/A

Data Domain Direct 

Oracle Prod1  Full 

36tb 

64

9 hours 

Before 6am

Oracle Prod1  Full 

36tb 

20

12 hours 

Before 6am

Oracle Prod1 Incremental Merge

600gb to 1.6tb daily change

2

4 hours 

Before 6am

Oracle Dev Full 

10tb 

Oracle Dev Incremental Merge

10tb 

1

Under 1 Hour 

Full site Protection 

22%

22%

23%

24%

25%

27%

27%

29%

30%

30%

0%

10%

20%

30%

40%

Deploying a "private cloud" infrastructure

Mobile workforce enablement

Desktop virtualization

Data center consolidation

Business continuity/disaster recovery programs

Information security initiatives

Manage data growth

Major application deployments or upgrades

Increased use of server virtualization

Improve data backup and recovery

Which of the following would you consider to be your organization's most important IT priorities over the next 12-18

months? (Percent of respondents, N=614, ten responses accepted)

Top 10 IT Priorities

“Businesses go from driving 75 mph down

the freeway to a near standstill. Backup is

the bottleneck, and this must change.”

Stephen Manley, CTO, EMC Backup Recovery Systems

THE

CHALLENGE:

Ensuring Oracle Backup Isn’t A