- oracle...sustained throughput disk write: 5,200 mb/s (per controller) database consolidation ssd,...
TRANSCRIPT
1
<Insert Picture Here>
Refreshing Your Data Protection Environment
with Next-Generation Architectures
Dale Rhine, Principal Sales Consultant
Kelly Boeckman, Product Marketing Analyst
3
Program Agenda
Storage challenges
Key enabling technologies
Oracle solutions and value
Reference architecture
Summary
4
IT Storage Challenges Have Not SlowedIncreasing Demand for Storage Capacity
Source: IDC, White Paper Sponsored by EMC, The Digital Universe
Decade - Are You Ready? Doc.# IDC_925, May 2010
5
Current IT Storage Challenges
Uncontrollable data growth
On average companies are doubling their data every two
years
Approximately 20% is structured data and typically
“Business Critical” – database backups
Approximately 80% is unstructured data – file systems
backup
Budget restrictions
Whether decreasing, flat, or increasing budgets are not
keeping pace
Energy, cooling, and space issues within the data center
6
Current IT Storage Challenges
Rigorous Service Level Agreements (SLAs) − Data
growth, economic pressures, and competitiveness in
the global market are causing:
Crushing backup windows
Driving shorter Recovery Time Objectives (RTO) and
aggressive Recovery Point Objectives (RPO)
24x7x365 access to data
Greater regulation
Legal, compliance, and regulatory issues are forcing
“keep it forever” retention timeframes
7
Why is Data Protection So Important?Top Data Protection Issues for Companies of All Sizes
• Safeguard corporate information
• Maintain efficient business operations
• Conformance with SLAs and regulations
• Recovery time and recovery point focused
• Drive out costs - efficiency
• Shrink the backup window
• Simplified, automated management
8
The Availability Continuum
Data Protection - Backup & Restore
Data Availability / Mirroring
Clustering
Disaster Recovery for DataReplication
Global Clustering
INVESTMENT
Disaster Recovery for Application
High Availability for Application
High Availability for Data
Backups
Backup & Restore is the FOUNDATION of data protection!!
AV
AIL
AB
ILIT
Y
9
Traditional Database Backup and RecoverySlow and Inefficient
LAN
BackupServerDatabase
Server
DatabaseServer
BackupMaster
TapeLibrary
DedupeAppliance
Disk to Disk
Disk to Tape
10
File System Backup RealitiesTape vs. Disk
Disk to Tape
Disk to Deduplicated Disk
Access Retention TCO
Low
Medium
High
Access Retention TCO
Low
Medium
High
11
Storage challenges
Key enabling technologies
Oracle solutions and value
Reference architecture
Summary
Program Agenda
12
Data Deduplication Changing BackupData Deduplication Benefits
SMALL FOOTPRINT DATA CENTRALIZATION OFF-SITE REPLICATION
• Optimized capacity
• Store more data for a longer period of time
• Reduced management
• Reduced bandwidth requirements
• Centralized data protection and management
• Mitigate security risk of lost media
• Improved Recovery Point Objective (RPO)
13
Deduplication for Backup − Choices
Clients Based Deduplication
Source based deduplication
Backup Software with Deduplication
Target based deduplication
Backup Server
Backup Server
Deduplication Appliance
Device based deduplication
Hybrid Based Software Deduplication
Target based deduplication
Backup Server
14
Backup Software Deduplication Benefits
Reduce Costs
Leverage current backup
software
“Inexpensive” and high
performance Sun servers
Shrink backup window by up
to 90% (client dedupe)
Flexibility
Deduplication at the client, backup server, neither, or both
Deduplicate by data type – eliminates “all or nothing” approach
Reduce Risk
No hardware vendor lock-in
Regular disk and tape storage – taking advantage of compression
and encryption
Possible tape deduplication
15
Oracle Recovery Manager (RMAN)Simplified Logical And Physical Recovery
RMAN
Intrinsic knowledge of
database file formats and
recovery procedures
Fast Recovery Area
Fast incremental backups
Backs up only changed
blocks
Image copy backup rolled
forward with incremental
backup
No need to do full backups
Tape Library
Long term backup storage
Eco-friendly
Oracle Enterprise Manager
RMAN
Database
Fast Recovery Area
Tape Library
Oracle Secure Backup
16
Disk-to-Disk-to-Tape With DeduplicationTiered Storage Economics and Scalability
0 7 30 60 90 365 Infinite
Days since backup
Pro
bab
ilit
y o
f re
call
Backup Server
Clients
Oracle Database Machine
Oracle Secure Backup
17
Leveraging The TCO of Tiered Storage
Access Retention TCO
Low
Medium
High
18
Program Agenda
Storage challenges
Key enabling technologies
Oracle solutions and value
Reference architecture
Summary
19
Disk-to-Disk-to-Tape with DeduplicationData Protection Architecture
Infinite storage scalability
Lowest total cost of
ownership
Deduplication flexibility
“Right” sizing
The “right” storage
The “right” capacity
The “right” access
The “right” throughput performance
For the “right” price
Secured, long term access to ALL your data
20
The Changing Role of Tape in Open Systems Backup
Paraphrasing Mark Twain…
“The reports of Tape’s death have been
greatly exaggerated.”
Tape is the only cost effective, long-term storage
medium
Focus on weekly, monthly, quarterly, and yearly full backups
Reliability – 15 to 30 year shelf life
Drive and media generational compatibility
Secured encrypted data – Lost tape? Who cares.
Tape Libraries – shared, consolidation resource
21
The Changing Role of Tape in Open Systems Backup
High speed, linear scalable performance
Economical “green” storage – ultimate in data at rest
storage
Data growth make disk too costly and too risky – even
with deduplication
Tape is 100,000 time more reliable then disk (bit error rate of
1014 vs. 1019)
RAID only makes this worse – more components to fail
Tape provides the maximum in
Portability
Capacity
Security
22
Oracle Recovery Manager (RMAN)Backup To The Fast Recovery Area
Simplifies all recovery processes
That’s why you backup in the first
place
Logical and physical
Shrink the backup window
Incremental backups
Changed blocks only
Image copy backup rolled forward
with incremental backup
Default disk location for all recovery-related files
High performance backup to Tape
Tiered storage economics
Secure, long-term Tape storage
23
Program Agenda
Storage challenges
Key enabling technologies
Oracle solutions and value
Reference architecture
Summary
24
Database Backup ArchitecturesPerformance, Scalability, Reliability
Reference Architecture:
Exadata and Database Backup1
Reference Architecture:
File System Backup,
Disk-to-Disk-to-Tape with Deduplication
2
25
Exadata and Database
Backup to Tape
26
Oracle Secure Backup (OSB)Enterprise Tape Backup Management – Database Backup
Oracle Database
RMAN Integration
Oracle Secure Backup
Tape
Library
Virtual
Tape
Library
(VTL)
File System Data
Oracle Enterprise Manager
• Oracle database backup / recovery management
– Utilize RMAN command line restoring to original or alternate location
• Provides media management layer for RMAN
– Built-in integration – No additional licensing costs
– Exclusive performance optimizations
– Achieving 25 – 40% faster backup to tape than comparable products
• More than 75% less expensive than comparable products
27
Sun Oracle Database Machine
Sun Oracle Database Machine – Backup To DiskInternal Fast Recovery Area
Full Database Backup to Disk
1 instance, 2 RMAN channels:
3.4 TB/Hr
2 instances, 2 RMAN channels/instance:
5.1 to 6.5 TB/Hr
2 instances, 4 RMAN channels/instance:
5.4 to 7.1 TB/Hr
Full Database Restore from Disk
All instances, 2 RMAN channels/instance:
Quarter Rack: 5.6 TB/Hr
Half Rack: 13.7 TB/Hr
Full Rack: 24 TB/Hr
Fast Recovery Area
28
Sun Oracle Database Machine
Infiniband Quad Data
Rate Network
OSB client transmits RMAN
backup data streams via TCP/IP
over IB
Sun Oracle Database Machine – Backup To TapeInternal Fast Recovery Area
StorageTek SL500
Brocade 5100 8GB FC SAN
OSB associates each backup data stream to a tape
drive
Sun Fire X4170
Oracle Secure Backup Administrative Server
Two Sun Fire x4275
Oracle Secure Media Servers
OSB media server writes backup data
to tape
Fast Recovery Area
29
Proof of Concept Summary
Full Database Backup to Tape - all instances, 14
tape drives, one RMAN channel per drive: 8.6 TB/Hr
Full Database Restore from Tape - all instances, 14
tape drives, one RMAN channel per drive
Quarter Rack: 6.1 TB/Hr
Half Rack or Full Rack: 7.8 TB/Hr
Servers
Sun Fire 4170 Oracle Secure Backup administrative server
Sun Fire 4275 Oracle Secure Backup media servers with
Infiniband QDR adapters
StorageTek SL500 with 14 LTO4 drives through a
Brocade 8GB 5100 Fiber Channel switch.
30
Oracle DatabaseSun Storage 6000 Series Fast Recovery Area
Oracle Database
Sun Storage6000 Series
RMAN backups, archived redo logs
stored in Fast Recovery Area
SATA Disk
Fast Recovery Area
FC Disk
Indexes, Tables,Redo logs
SSD
Indexes, Tables, Temp, Undo, Redo logs
Media Manager
StorageTek Tape Storage
Media manager backs up recovery area files to tape for longer-term
storage
31
Solution Highlights
Leveraging Fast Recovery Area for simplified and high performance
physical and logical data recovery and Tape for long-term storage
Sustained throughput disk read: 6,400 MB/s (per controller)
Sustained throughput disk write: 5,200 MB/s (per controller)
Database consolidation
SSD, Fibre Channel, and SATA disk – best price per performance (IOPS and
MB/s)
Automatic Storage Management and Partitioning – simplifying management
Driving down the cost of online storage
Enterprise capabilities and reliability at modular disk costs
Configuration flexibility – IOPS – throughput – both!
On the fly dynamic reconfiguration
Product line scalability
Oracle Red Stack solution and support
32
Infinite Disk Repository
Shared
infrastructure
Each database
instance has it’s
own “virtualized”
disk
Tiered Disk and
Tape
Policy based data
movement
Data read direct
from storage
Oracle 10g/11g Database Server
Sun Storage Archive ManagerMetadata Server
Individual Fast Recovery Areas
Sun Storage Archive Manager Infrastructure
Tier 1 –Sun
Storage 6000 or
7000 Series
$$
Tier 2 –Sun
Storage7000
Series
$
Tier 3 –StorageTek
Tape Storage
$$$
33
Infinite Disk Repository and Sun Storage
Archive Manager
Infinite Disk Repository for each Oracle instance
All Data Protection data looks like it resides on disk
Faster recovery time objectives and better recovery
point objectives
Mitigates need for redundant backup application
Retention policies in database control
Provides continuous fast direct access to the data
Transparent migration of files
34
File System Backup:
D2D2T with Dedupe
35
Oracle's Reference Architecture for Next-Generation
Data Backup
Oracle
Solaris
Backup
Clients
AIX
Backup
Clients
HP/UX
Backup
Clients
Linux
Backup
Clients
Windows
Backup
Clients
10Gb and 1Gb Ethernet Client Network / VLAN
Infiniband Fabric 10Gb Ethernet Data Network 8Gb Fibre Channel SAN
PureDisk Server Options Master / Media Server Options
Sun Blade 6000 Chassis
Sun Blade X6270Sun Fire
X4170 ServerSun SPARC Enterprise
T5120 ServerSun SPARC Enterprise
T5220 ServerSun SPARC Enterprise
T5240 Server
Sun Blade 6000 Chassis
Sun Blade T6320/T6340
Converged Network
BackupsSun Datacenter Gateway
Disk PoolsSun Storage 7000
Unified Storage Systems
Fibre Transport
Media ServerSun SPARC Enterprise
T5240 Server
Disk PoolsSun StorageTek 6180
Tape DrivesSun StorageTek
T10000B
And LTO4
Tape LibrariesSun StorageTek SL500,
SL3000 and SL8500
36
Backup Performance to Build On
Equates to performance of 5 to 52 TB/hr.
ServerNumber of
10 GB Ports
Number
of Threads
Maximum
Network Backup
Sun SPARC Enterprise T5120
Server2 16 1.4 GB/sec
Sun SPARC Enterprise T5220
Server2 16 1.4 GB/sec
Sun SPARC Enterprise T5240
Server4 32 2.8 GB/sec
Sun Blade 6000 Chassis with
10 Sun Blade T6320 Server
Modules*
20 160 14.4 GB/sec
*These results are possible only with 10 Sun Blade T6320 server modules configured as NetBackup media servers.
37
Backup Architecture Highlights
Multitier architecture including backup clients, media
and master servers, and a wide variety of disk and
tape devices
Highly flexible
Virtually unlimited scalability
Real world performance results
Oracle optimized, tested and validated solution
38
Program Agenda
Storage challenges
Key enabling technologies
Oracle solutions and value
Reference architecture
Summary
39
Summary
Reduced operational costs:
Complete solution - tested architectures
Leverage existing knowledge base in backup/recovery software
Automation throughout the software and hardware solution
ECO-friendly - Servers, Deduplication, Disk, and Tape
Right-size the backup processes
Deduplication where, when and if it is needed
Tiered storage economics and scalability
Meet future requirements simply, easily, and cost effectively
Achieve SLAs - meet and exceed Recovery Time Objectives
(RTO)
Highest performing servers, disk, and tape
From the trusted backup expert – Oracle
30 plus years of backup hardware and software experience
40
Additional Resources
Oracle Database High Availability
http://www.oracle.com/technetwork/database/features/availability/index-087701.html
Oracle Maximum Availability Architecture
http://www.oracle.com/technetwork/database/features/availability/maa-096107.html
Oracle Exadata
http://www.oracle.com/us/products/database/exadata/index.html
Sun Oracle Database Machine
http://www.oracle.com/us/products/database/database-machine/index.html
Oracle Recovery Manager
http://www.oracle.com/technetwork/database/features/availability/rman-overview-
094650.html
Oracle Secure Backup
http://www.oracle.com/technetwork/database/secure-backup/overview/index.html
Sun Storage Archive Manager
http://www.oracle.com/us/products/servers-storage/storage/storage-
software/031715.htm
Oracle Tiered Storage Portfolio
http://landingpad.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=9
217710&src=7011670&Act=20
41