exadata backup
DESCRIPTION
TRANSCRIPT
Backup & Recovery for Exadata
Fran NavarroPrincipal Sales Consultant
Feb 2012
Agenda
• Backup & Recovery Fundamentals• Oracle Backup Tools• Backup Strategies for Exadata
• Data loss exposure ESG estimates that 1 in 7 (14%) backups and 1 in 6 (17%)
restores fail.*
• Meeting SLA’s Shrinking backup windows; slow recovery processes
• Reducing costs Reducing both CAPEX & OPEX while improving staff efficiency
• Complexity Complexity of BU&R process and the storage environment
• Data growth Compounding year over year
Business Drivers Behind BackupWhat keeps our customers awake at night…
*Enterprise Strategy Group 2008
Fundamental Data ProtectionRule of 3
• 1st Line of Defense (Applications, Systems)– Typically data deletion, logical corruption or a virus– Look at the RPO. The majority of critical application recovery is likely to
come from the snapshot on the same tier of storage
• 2nd Line of Defense (Building, Site, Region)– HW failure & Disaster Recovery - failover to a remote site– Circumstances will dictate whether it should be disk and/or tape– Remote disk mirroring provides a physical copy of the data, but does not
provide logical data protection (it replicates corruption immediately!)
• Last Line of Defense – TAPE!– The last chance to avoid permanent data loss– Data preservation much more important than recovery time
“3 Copies of the Data on 2 different medias with 1 offsite”
Fundamental Backup and Recovery
Data Loss(Recovery Point Objective)
Downtime(Recovery Time Objective)
Hrs Mins SecsWks Days HrsMinsSecs WksDays
Flashback Database
Fast point-in-time recovery strategy
Eliminate the need to restore a whole database backup
Continuous data protection for databaseOptimized, before-change block loggingRestores just changed blocksReplay log to restore DB to desired time
It’s fast - recover in minutes, not hours
It’s easy - single command restoreFlashback Database to ‘2:05 PM’`
“Rewind” button for the Database“Rewind” button for the DatabaseData Files FlashbackLog
NewBlock
Version
Write
OldBlockVersion
Database
Instance
Database
Instance
Oracle Recovery Manager (RMAN)Oracle-integrated Backup & Recovery Engine
• Intimate knowledge of database file formats and recovery procedures
• Manages and automates the backup, restore, and recovery policies and process
• Catalog all backup and recovery activities
• Operates online and in parallel for fast processing
• Corrupt block detection during backup and restore with the ability to validate backups
• Integrated with Enterprise Manager, Oracle Secure Backup, and third party backup products
Oracle Enterprise Manager
RMAN
Database
Fast Recovery Area
Tape Drives
OracleSecure Backup
Oracle Secure Backup (OSB) Enterprise Tape Backup Management
Protects Entire IT Environment
• Built-in Oracle Integration
• 25 – 40% faster than leading competition
• 4X less expensive than comparable products
• Supports Oracle Database 11g through Oracle 9i
Oracle Database
RMAN Integration
Oracle Secure BackupFile System Data
OracleEnterprise Manager
Tape Library
Virtual TapeLibrary
Centralized Tape Backup Management
Exadata BackupBackup Options for Exadata
Exadata Database Machine
Exadata Expansion
Oracle Sun StorageTek
Tape Library
ZFSStorage
Appliance(ZFS-SA)
Exadata Backup (Fastest)• RTO: Immediate• RPO: Lossless• Fastest option using Inifiniband to another Exadata machine
ZFS Storage Appliance Backup (Most Flexible)• RTO: Next to Immediate• RPO: Last transaction• Multiple network connectivity & data service options
Tape Backup (Most Economical)• RTO: Hours• RPO: Last Transaction Backup • Best economics on cost/GB and offers removable offsite
capability
Backup Options for ExadataCustomer choice depending upon objectives & budget
InfiniBand Network
Oracle ExadataStorage Cells
Oracle Exadata Database Machine
Exa-Backup with ExadataUsing additional Storage Cells - Highest Performance
• Requirements for immediate data restore capabilities and reduced backup windows
• Primarily data protection against user/logical errors (Flashback)
• Allocate additional 2TB HDD Exadata Storage Servers for a dedicated Fast Recovery Area
• Additional Exadata Storage Servers must be installed in another rack
• External backup still recommended
FC
Quarter* Half* Full**
Backup Rate
8.5 TB/hr
18.5 TB/hr
27.0 TB/hr
Restore Rate
18.0 TB/hr
28.5 TB/hr
28.5 TB/hr
* Full Exadata Rack to a Quarter, Half Storage Expansion Rack** Estimated rate Full Exadata to Full Storage Expansion Rack
Sun ZFS Storage Appliance
Exa-Backup and ZFS Storage ApplianceMost Flexible
• Various Connectivity Options 1 GigE, 10 GigE, IB!!
• ZFS works with RMAN to secure against data corruption RMAN ensures that backups are not
corrupt, ZFS ensures they stay that way
• Enables ZFS Snapshot and RMAN incremental backup strategy
• Leveraging ZFS Storage data services and capabilities Thin provisioning Compression Snapshot and cloning Replication Performance Analytics
Oracle Exadata Database Machine
RMAN
IB / 10Gig ENetwork
Image Copies
Incremental Backups*
Backup Rate 6.5 TB/hr 42.0 TB/hr
Restore Rate 6.2 TB/hr 7.0 TB/hr
*Effective Rate = Rate * Change Rate Backup = 8.5 TB/hr * 20% Change = 42 TB/hr
Oracle Exadata Database Machine
• High efficiency Exadata protection
• Scalable – capacity and performance
• Simplified data recovery
Oracle Secure Backup (OSB)
StorageTek Tape Library
Exa-Backup to TapeMost Economical Backup Option
FC / SAS
Network
IB / 10Gb E
Network
6 x LTO4 6 x LTO5
Backup Rate 4.7 TB/hr 5.7 TB/hr
Restore Rate 4.8 TB/hr 5.7 TB/hr
SL3000 up to 24 drive base (up to 56 drives with expansion for LTO or Enterprise T10K and 200 to over 5000 slots) SL8500 up to 64 drive base (up to 640 drives LTO or Enterprise T10K drives and from 1500 to over 100,000 slots)
ZFS Storage Appliance
OSB or other, 3rd Party, Backup
Admin.
StorageTek Tape Storage
RMANBackups
Exadata BackupPutting it all together
Oracle ExadataStorage Cells
Oracle Exadata Database Machine
Backup Area
16
Some performance numbersDisk and Tape
• Exadata for the most demanding RPO/RTO– Backup up to 18TB/hr (full rack), 20-50TB/hr for incrementals– Restore 18-24 TB/hr (full rack)
• ZFS Storage Appliance Beats NetApp and EMC Data Domain!– Over 3x the backup throughput of NetApp– Up to 1.3x the restore throughput of NetApp– Over 3x the backup throughput of Data Domain– Over 3x the restore throughput of Data Domain
• T10000C and Oracle Storagetek Libraries beat IBM !– T1000C 25% greater capacity, 33% lower TCO, and 50% less
floor space
Backup and Restore for ExadataValue Proposition
Speed: Complete backups within shorter windows Faster backup and recovery (flashback and incremental forever RMAN strategy) Speedy Implementation Leverages Exadata's internal IB network for extreme performance Already tested, validated and supported by Oracle
Simplicity: Avoiding complexity• No third party SW backup to manage required for disk backup• Preserves incremental backups optimizing Database and network performance• ZFS Storage Appliance 30% easier to manage than third party vendors
Savings: Reduced Capex and Opex• Simple architecture reduces costs• No backup and recovery license fees and no media server for disk-based backup• Storage hierarchy that balances cost and performance• T1000C 25% greater capacity, 33% lower TCO, and 50% less floor space
Exadata Backup (Fastest)
Immediate Restore
ZFS Storage Appliance Backup (Most Flexible)Easier integration
Tape Backup (Most Economical)
Who better than Oracle to protect OracleThree different ways to protect Exadata
Oracle/StorageTek is #1 in tape
ProsFaster recovery from up-to-date image copyLess data to backup = shortened backup windows
Database
Day 1
Level 0 IMAGE backup
Day 2
Level 1 incremental backupApplied
Day 3
Backups
ConsCan not recover data older than 24 hours
Exa-Backup and ZFS Storage ApplianceMost Flexible
Database
Day 1
Level 0 IMAGE backup
Day 2
Level 1 incremental
backupApplied
Day 3
Backups
Exa-Backup and ZFS Storage ApplianceLeveraging the ZFS Storage Appliance’s SnapShot
SnapShot