Cor Beumer
Storage Sales Specialist – Oracle Nederland
Recovery Point and Recovery Time
Data Loss
(Recovery Point Objective)
Downtime
(Recovery Time Objective)
Hrs Mins Secs
Wks Days Secs Mins Hrs Days Wks
Value of Data
The Business value of data is rarely understood
Recovery Point Objective
The shorter the Recovery Point Objective (RPO) the
more current the data
Recovery Time Objective
The shorter the Recovery Time Objective (RTO) the quicker you
get back to business
Backup Window
Static, but needing to accommodate an ever increasing amount of data
Backup & Recovery
Recovery Time Objective (RTO)
Oracle Data Protection Solutions
Disaster Recovery
Recovery Time Objective (RTO)
Physical Data Protection
• Active Data Guard Seconds/Minutes
Physical Data Protection
• Recovery Manager (RMAN) • Oracle Secure Backup (OSB)
Minutes/Hours/Days
Logical Data Protection
• Flashback Technologies
Fundamental Backup and Recovery
Data Loss
(Recovery Point Objective)
Downtime
(Recovery Time Objective)
Hrs Mins Secs
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 Oracle Enterprise Manager
RMAN
Oracle Secure Backup* 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
RMAN
Database Fast Recovery Area Tape Drives CloudFlashback Database
•
Fast point-in-time recovery strategy
•
Eliminate the need to restore a whole
database backup
•
Continuous data protection for database
• Optimized, before-change block logging WriteDatabase
Instance
Database
Instance
• Restores just changed blocks
• Replay log to restore DB to desired time
•
It’s
fast
- recover in minutes, not hours
•
It’s
easy
- single command restore
• Flashback Database to ‘2:05 PM’`“Rewind” button for the Database
Data Files Flashback Log New Block Version Old Block Version
Exadata Backup (Fastest)
o RTO: Immediate o RPO: Lossless
o Fastest option using Inifiniband to another Exadata machine
ZFS Storage Appliance Backup (Most Flexible)
o RTO: Next to Immediate
Backup Options for Exadata
Customer choice depending upon objectives & budget
o RPO: Last transaction
o Multiple network connectivity & data service options
Tape Backup (Most Economical)
o RTO: Hours
o RPO: Last Transaction Backup
o Best economics on cost/GB and offers removable offsite capability
HIGHEST PERFORMANCE:
Exadata Backup (Fastest)
o RTO: Immediate o RPO: Lossless
o Fastest option using Inifiniband to another Exadata machine
HIGHEST PERFORMANCE:
BACKUP TO EXADATA
InfiniBand
Oracle Exadata Storage Cells Oracle Exadata
Database Machine
Exadata - Backup and Recovery
Using additional Storage Cells
•
Allocate additional 2TB
Exadata Storage Servers for a
dedicated Fast Recovery Area
•
Additional Exadata Storage
Servers must be installed in
another rack
MA
A
MA
A
MAA Best Practice InfiniBand Networkanother rack
•
Key Benefits
• Better failure isolation when using separate backup hardware
• Allows use of lower cost space for backups
•
Only for data protection –
unbalanced configuration
Fast Recovery
Exadata - Backup and Recovery
…Performance
•
Backup rates:
•
17 TB/hr for Full Rack configurations (full image
copies)
•
Effectively 20-50 TB/Hr for incremental backups
MA
A
MA
A
MAA Best Practice•
Restore rates into existing files
•
14 – 17 TB/hr for Full Rack Configuration
•
Database redo apply rates
•
2.1 TB/hour (637 MB/sec)
MOST FLEXIBLE:
BACKUP TO ZFS STORAGE
APPLIANCE
ZFS Storage Appliance Backup (Most Flexible)
o RTO: Next to Immediate o RPO: Last transaction
Sun ZFS Storage Appliance
Exadata and the Sun ZFS Appliance
RMAN Disk Target
•
Various Connectivity Options
• 1Gbe, 10Gbe, Infiniband•
ZFS
works with RMAN to secure
against data corruption
• RMAN ensures that backups are not corrupt, ZFS ensures they stay that way
•
Enables dNFS DB Cloning*
1Gbe 10GBe
Infiniband
•
Enables dNFS DB Cloning*
•
Leveraging ZFS Storage data
services and capabilities
• Thin provisioning • Compression
• Snapshot and Cloning • Replication
• Performance Analytics
Fast Recovery
Area
* EHCC can not be used outside of storage cells to support cloning Infiniband
BEST SCALABILITY ACTIVE-ACTIVE CONTROLLERS BEST VALUE FULL SUITE OF DATA SERVICES
STANDARD FEATURES (ALL MODELS)
All Data Protocols: FC, iSCSI, IB, NFS, CIFS, WebDAV, etc. Advanced Data Services: Snap, dedup., compression, replication, etc.
ZFS Storage Appliances
Second Generation Systems
BEST FLEXIBILITY SINGLE OR DUAL CONTROLLERS BEST DENSITY ACTIVE-ACTIVE CONTROLLERS NEW BENEFITS
Best Density and Scale: Industry-leading density, scale up to 1PB for Consolidation Flash Everywhere and More Of It: Industry-leading flash capacity for Application Performance
Doubled the Processing Power: Performance to drive enterprise Data Protection Advanced Data Services: Snap, dedup., compression, replication, etc.
CLIENTS AND APPLICATIONS (ALL MODELS)
Oracle Solaris • Oracle Linux
Oracle Database, Middleware, and Applications Oracle VM • VMware • Windows
More than 50 business applications supported
Oracle Suggested Backup Strategy
Database
Day 1
Level 0 IMAGE
backup
Day 2
Level 1 incremental
backup
Backups
•
Pros
• Faster recovery from up-to-date image copy
• Less data to backup =
shortened backup windows
Day 2
Day 3
Level 1 incremental backup•
Cons
• Can not recover data older than 24 hours
• Image copy can not be compressed by RMAN
Oracle Suggested Backup Strategy
Leveraging the ZFS Storage Appliance’s SnapShot
Database
Day 1
Level 0 IMAGE
backup
Level 1
Backups
Day 2
Level 1
incremental
backup
Day 3
Level 1 incremental backup SnapShotBenefits of the ZFS Storage
Appliance
•
Recovery of image backups older than 24 hours
•
Database cloning
•
Provides compression for RMAN image backups
• Remember!!! Image copy backups are EXACT byte-for-byte copies of database files
of database files
•
Replication of RMAN disk backup to remote destination
•
Data movement to Tape
• RMAN Archive to tape – managed and tracked by RMAN • NDMP direct to FC tape – no database server resources
RMAN backup and restore throughput
FOR A SUN ZFS STORAGE APPLIANCE
WITH 1 HEAD, 4 TRAYS, 2 POOLS, AND 16 SHARES
# active channels Backup throughput (TB/HR) Restore throughput (TB/HR) 4 4.8 1.4 8 5.1 1.9 8 5.1 1.9 16 5.5 1.4 32 4.5 1.0
RMAN backup and restore throughput
FOR A SUN ZFS STORAGE APPLIANCE
WITH 2 HEADS, 4 TRAYS, 2 POOLS, AND 16 SHARES
# active channels Backup throughput (TB/HR) Restore throughput (TB/HR) 4 5.5 2.7 8 6.9 3.3 8 6.9 3.3 16 8.9 2.2 32 6.9 1.8
LOWEST COST:
LOWEST COST:
TAPE BACKUP
Tape Backup (Most Economical)
o RTO: Hours
o RPO: Last Transaction Backup
o Best economics on cost/GB and offers removable offsite capability
Oracle Secure Backup (OSB)
Enterprise Tape Backup Management
Protects Entire IT
Environment
•
Built-in Oracle Integration
•
25 – 40% faster than
leading competition
Oracle Database Oracle Database
Oracle Secure Backup
File System Data File System Data
Oracle Enterprise Manager
leading competition
•
4X less expensive than
comparable products
•
Supports Oracle
Database 11g through
Oracle 9i
RMAN Integration
File System Data File System Data
Tape Library
Virtual Tape Library
Oracle Exadata Database Machine
•
High performance Exadata
protection (disk and tape)
• Backups: 7 to 8 TB/hr • Restore: 7 to 24 TB/hr
•
Scalable – capacity and
performance
Fast
StorageTek Tape Storage
Oracle Exadata Database Machine
Backup To Disk and Tape
MAA Best Practice
MA
A
MA
A
MAA Best Practiceperformance
•
Simplified data recovery
FastRecovery Area
Oracle Secure Backup
Oracle Database ZFS Storage Appliance OSB or 3rd Party Backup Admin. StorageTek Tape Storage
Oracle Database
ZFS Storage Appliance – RMAN Backup protection
RMAN Backups
• Also works with your customer’s third party backup applications
• Symantec NetBackup and Backup Exec
• EMC NetWorker
• IBM Tivoli Storage Manager
• CommVault Simpana • Etc… Fast Recovery Area Oracle Secure Backup Admin.
ZFS Storage
Appliances StorageTek Tape Storage
Geographic RMAN data protection
ZFS Storage Appliance
• Replication • Compression
• Snapshots (read only) • Cloning (read/write) • Thin Provisioning Fast Recovery RMAN Backups Secondary Location Automated Tape
• Long term data retention • Secure encrypted tape
• Green, economical storage • Portability
• Lowest cost / Maximum capacity
Recovery Area
RMAN Backups
Fastest Time to Restore
RMAN Backup Targets for Exadata
Database Machine Exadata Expansion Tape Library ZFS Storage Appliance RMAN backups
Putting It All Together..
Customer Example
Requirement Service Level Agreement
RPO RTO
•Tier 3
•Tier 2
Oracle Solution
Archived Log Mode
RMAN, OSB, NBU, etc..
Flashback Table
Flashback Database
Any point in time within recovery window
• <1 hour for tablespace/datafile recovery <3 hours for full database recovery
• <30 min for row/table recovery (within last 3 hrs)
<1 hour for database recovery from logical
•Tier 1 Disaster Recovery Retention Policy Backup Redundancy Flashback Database Data Guard Data Guard OSB, RMAN
Fast Recovery Area,
OSB, NBU, etc..
OSB, NBU, etc..
<1 hour for database recovery from logical errors (within last 2 hrs)
• <15 min for any database outage
Failover to standby database at secondary site Backups sent offsite
Onsite backups - 3 day recovery window Offsite backups - 1 year tape retention Two backup copies on tape
To Find out More
•
Protecting Exadata with the Sun ZFS Storage appliance
Capacity Planning Guidelines and Configuration Best
Practices Whitepaper
www.oracle.com/technetwork/server-storage/sun-unified-storage/overview/index.html
•
MAA Guides
www.oracle.com/technetwork/database/features/availability/exadata-maa-best-practices-155385.html
•
Oracle Recovery Manager
www.oracle.com/technology/deploy/availability/htdocs/RMAN_Overview.htm
•
Sun ZFS Storage Appliance
www.oracle.com/us/products/servers-storage/storage/unified-storage