data protection strategies - conres · • oracle recovery manager (rman) ... – 40% faster than...
TRANSCRIPT
2 | © 2011 Oracle Corporation – Proprietary and Confidential
Oracle Database Appliance
Data Protection Strategies
3 | © 2011 Oracle Corporation – Proprietary and Confidential
Oracle Database Appliance Value PropositionSimple High Availability Database
• Easy to Implement
– One Box: server, storage, networking
– One Button Install of SW
• Easy to manage & maintain
– One button patching
– Self-managing storage
– Auto-detects and auto-corrects
• Easy to diagnose and support
– Automated Service Request filing (phone home)
– Relevant logs gathered and packaged for support
4 | © 2011 Oracle Corporation – Proprietary and Confidential
Typical Oracle Database Appliance Use Cases
• Database(s) up to a maximum of 4 TB of data
• Fast, efficient replacement of aging servers
• Higher availability for application databases
• High availability for remote/distributed sites
• Migrate and consolidate databases
• Pay-as-you-grow IT projects
SMBs and Departmental Systems
5 | © 2011 Oracle Corporation – Proprietary and Confidential
Why Oracle Database Appliance Storage Attach?
• DB Data files should stay on Oracle Database Appliance internal storage : Customers need better
space utilization of the internal, high-perf, highly available disk capacity (of 4TB) for the live
production database(s)
• Physical backup & recovery for Oracle Database Appliance and other servers/clients in the
infrastructure
• Central file store repository for Oracle Database Appliance and other servers/clients in the
infrastructure
• Create duplicate database store for reporting, DB/app testing, standby database, migration,
integrity testing, ...
• Database operational data store for database and partial exports, database uploads, ETL, and
similar
Oracle on Oracle
Oracle Database Appliance Supports 1GigE and 10GigE IP (NAS) Storage Connectivity Only
6 | © 2011 Oracle Corporation – Proprietary and Confidential
Technology Highlight
• Unified Storage Platform with wide range of connectivity options and data
protocol support – easy to integrate to cloud, virtualization infrastructures or
heteregenous datacenters.
• Full suite of advanced data and management services :
– Snapshot and clones, Data replication, Compression and deduplication, HCC, Thin provisioning,
Storage Analytics and many more...
• Performance and power consumption optimization through transparent use of
Flash technology with Hybrid Storage Pools – lower costs
• Unmatched ‘data integrity’ with ZFS checksum feature – ensure data integrity
and failure recovery for large online archives and backups
• Management simplicity with Analytics software (bundled)
• Applications-to-disk management integration with Oracle Enterprise Manager
ZFS Storage Appliance
7 | © 2011 Oracle Corporation – Proprietary and Confidential
Sun ZFS Storage Appliance
Oracle Database Appliance Data Protection & Availability
• Oracle Recovery Manager (RMAN) is the Oracle-
preferred method for efficiently backing up and
recovering Oracle databases
– Reduces exposure of data loss
– Ensures advanced data recovery and RTO/RPO
objectives
– RMAN backup to disk is preferred over tape where fast
restore is required
• ZFSSA is the ideal target for RMAN backups
– Ensures data integrity on disk by end-to-end checksums
– Enables dNFS DB Cloning for
test/development/reporting purposes
– Full suite of data services and capabilities to build
advanced consolidation, disaster recovery, backup &
recovery, development/test storage
RMAN
Oracle Database Appliance
RMAN
8 | © 2011 Oracle Corporation – Proprietary and Confidential
StorageTekTape Library
Oracle Database Appliance Data Protection & Availability
• Tape Based Backup delivers :
– Long term data archival & preservation
– Off-site physical data storage
– Legal compliance requirements
• OSB solution delivers unique to Oracle on Oracle :
– 40% faster than competition through tight technology
integration of RMAN and OSB
– 75% less cost, primarily through OSB software licensing
– Better media management and tape vaulting options,
integrated with RMAN
– Ease of use – single integrated solution from single vendor
RMAN & Oracle Secure Backup
Oracle Database Appliance
OSB Media&Admin Server(s)
9 | © 2011 Oracle Corporation – Proprietary and Confidential
Oracle Database Appliance Data Protection & Availability
• Oracle Data Guard provides :
– Disaster recovery and high availability
– Site-level redundancy and data protection
– Native and transparent
– Enable infrastructure for planned downtime and rolling
upgrades
– Secondary site can perform reporting and similar tasks
DataGuard
Oracle Database Appliance
DataGuard
Oracle Database Appliance
Network
10 | © 2011 Oracle Corporation – Proprietary and Confidential
Summary of Data Protection Options
Backup to InternalStorage (FRA)
Backup to ZFSSA (RMAN) Backup to Tape (RMAN and OSB)
Replicate to Remote Database Appliance(ADG)
Primarily protect against Logical corruption
Protect against Physical and Logical Corruption
Protection against Physical, Logical corruption and site-
failure.
Primarily protection against physical corruption and site
failure
Fastest data protection -Immediate Backup & Restore
Fast and Most Flexible External Backup Option
Advanced ZFS Data Services
Most economical Fastest in site failures
Short-term protection of data Short and medium term protection
Focus on long-term protection, archival of
multiple instances of data
Short-term protection of fresh data and transactions
Best efficiency and reduced costs - no 3rd party costs, implementation or integration risksDatacenter best practices by Oracle on Oracle – easy to implement and manage
11 | © 2011 Oracle Corporation – Proprietary and Confidential
Putting it All Together
• Customer infrastructure requirements may require a mix
of different backup solutions, such as :
– Replicate to remote site by DataGuard and off-load data to tape
on the remote site
– Backup to ZFSSA first and off-load to Tape with NDMP
– Backup to ZFSSA and replicate to remote site for disaster
recovery
– RMAN Backup stream to both ZFSSA and Tape
12 | © 2011 Oracle Corporation – Proprietary and Confidential
Putting it All TogetherDeployment Scenarios for Data Protection
• Backup to ZFSSA for fast recovery and DB Cloning
• Copy on Remote site by ZFSSA Replication
• Backup to Tape for long term archival and off-site storage
• End-to-end Oracle Stack for efficiency, performance and integrity
• Can chose any mix depending on requirements
ZFSSA
RMAN
ZFSSA Replication
Tape Backup
Oracle Database Appliance
Network
ZFSSA
OSB Server
13 | © 2011 Oracle Corporation – Proprietary and Confidential
Unleashing the Full Power of ZFSSAZFSSA Data Services for Database Duplication
• RMAN Copy to ZFSSA
• Multiple copies of RMAN data with ZFSSA Snapshot and Clones
• DbClone feature with 11gR2 enables fast and efficient access to RMAN data - ready
to play without database upload cycle
ZFSSA
RMAN
Oracle Database Appliance
DB Snapshot
DevelopmentClone
TestClone
Reporting Clone
14 | © 2011 Oracle Corporation – Proprietary and Confidential
Unleashing the Full Power of ZFSSAStorage Consolidation on ZFSSA
• Consolidate Storage Assets on ZFSSA
• Multi-protocol support for FC, NFS, CIFS, iSCSI, WebDav, ftp,....
• Multi-fabric including 1GigE, 10GigE, FC, Infiniband
• Centralized and consolidated data management provides higher efficiency and lower cost
ZFSSA
RMAN
Development,Test, Reporting
Databases
Oracle Database Appliance
Application Server
Infrastructure Servers (mail, web, security..)
VDI and other Desktop
15 | © 2011 Oracle Corporation – Proprietary and Confidential
New benefits
15,000 RPM HDDs now available- advantageous for specific high I/O use cases.
Continued software improvements resulting in better availability and performance.
Clients and applications (all models)
Oracle Solaris • Oracle Linux
Oracle database, middleware, and applications
Oracle VM • VMware • Windows
More than 50 business applications supported
S7420
S7320S7120
S7420
Standard features (all models)
All data protocols: FC, iSCSI, IB, NFS, CIFS, WebDAV, etc.
Advanced data services*: Snap, dedup., compression, analytics, etc.
* Replication and Clones are separately licensed features
7120
Best value Full suite of data services
7320
Best flexibilitySingle or dual controllers
7420
Best scalabilityHigh Availability Environments
ZFS Storage Appliances
16 | © 2011 Oracle Corporation – Proprietary and Confidential