expanding dr with_zfssa_110810
DESCRIPTION
TRANSCRIPT
<Insert Picture Here>
Expanding Disaster Recovery Solutions to Create
Competitive Advantage in Oracle Database and
Oracle Fusion Middleware EnvironmentsPresenter’s Name
Presenter’s Title
<Insert Picture Here>
Agenda
• Business Drivers and Challenges
• Adding Value to Data Guard
• DR for Oracle Fusion Middleware
with the ZFS Storage Appliance
• Support Services
• Next Steps
Business Drivers and Challenges
• Increasing sensitivity to downtime and data loss• Due to the cost of downtime, recovering in 48 to 72 hours and losing 8 hours or
more of critical corporate information is no longer acceptable
• Companies now measure recovery time and recovery point requirements in hours, and in some cases, minutes
• DR has expanded to ensure comprehensive IT service continuity• Disasters are not rare because most are caused by mundane events such as
power failures, IT failures, human error, and localized flooding
• Increasing pressure from internal and external stakeholders• Board members, auditors, regulatory agencies,
strategic partners, and customers demand proof of DR preparedness
• DR preparedness is now considered a fiduciary responsibility between an organization and its stakeholders
Why Organizations are focused on Disaster Recovery
Business Drivers and Challenges
• Increasing requirement to speed database application development
• Application patch releases, upgrades, and custom app development drive dev/test
work requiring deployment of new app’s in less time.
• Need to efficiently duplicate large mission critical databases to
support continuous demands for application development and test
• Multiple clones are often required for each production database in order to support
the many development and test activities associated with large production systems
• It is also important that the cloning process have zero impact to the production
database
• In many organizations, for every production OLTP database, there are
several development and test databases
Why Organizations are Focused on Database Development
and Test
Adding Value to DataGuard DR Copies
• Oracle Data Guard provides high availability and disaster protection
for mission-critical Oracle databases
• Multiple database clones are often required to support development
and test associated with large production systems
• Adding a Sun ZFS Storage Appliance to an Oracle Data Guard
configuration provides a low-cost solution for snapshots and clones
• No new licenses required for Enterprise Edition customers
• Tested, validated, and supported by Oracle
Accelerate Application Deployment with a Cost-Effective
Platform for Development, Test, and Quality Assurance
Primary site Standby site
Oracle Data Guard
Database Server
ZFS Storage Appliance
Database Server
Accelerate Dev and Test with the ZFS Storage
Appliance and Data Guard
Primary ArrayPrimary Array
NFS Share of Standby Database
Development
Database
Test
Database
Training
Database
• The ZFS Storage is simply added to the customer’s
existing Data Guard environment
• Shell scripts automate and coordinate ZFS Storage
and Data Guard failover and failback
• ZFS Storage Appliance Clones Standby Database for
Development, Test and Training
/export/dev_db/* /export/test_db/* /export/train_db/*
Using ZFS Storage Appliance Snapshot and
Clone to Copy Databases
Standby Database on
ZFS Storage Appliance
Development
Database
Test
Database
Training
Database
Reporting
Database• Snapshot capability quickly creates
multiple low-overhead Database clones for test and development
• Quick recovery from errors in test and development environments
Primary site Standby site
Oracle Data Guard
Database Server
ZFS Storage Appliance
Database Server
Standby Site Database can also be used for Reporting
Primary ArrayPrimary Array
NFS Share of Standby Database
Development
Database Server
Test
Database Server
Training
Database Server
• Offloads Primary OLTP site, allowing it to focus on
transaction processing
/export/dev_db/* /export/test_db/* /export/train_db/*
Accelerate Development and Test with the ZFS
Storage Appliance and Data Guard
Automated and implemented with minimal procedural changes
Use Snap and Clone Data Services included with ZFS Storage Appliance
Accelerate database development and test;
Offload Reporting from Primary OLTP site
Simplicity
Speed
Savings
Benefits
Oracle Fusion Middleware
• Oracle Fusion Middleware (FMW) is the foundation for the Oracle
application infrastructure, which enables business applications to be
created and run efficiently across the enterprise
• Oracle's FMW disaster recovery solution protects the infrastructure and
provides business continuity during a planned or unplanned event
DR for Fusion Middleware with ZFS Storage
Appliance
• The ZFS Storage Appliance compliments the DR capabilities of Data Guard for the Oracle Database
• The ZFS Storage Appliance easily administers replication for Fusion Middleware data stored outside of the Oracle Database
• Hardware and Software
• Engineered to Work together
• Tested, validated, and supported by Oracle
The Sun ZFS Storage Appliance
• Combines multiple protocol connectivity, data services for business
continuity, and ease of management into a single appliance
• Comes with a license-free model for all protocols and data services
Remote replication, snapshots and cloning enable complete disaster
recovery (DR) and business continuity
• Remote Replication
Data is replicated from the primary to the standby site, with data
blocks asynchronously streamed to the remote storage appliance
Scheduled Replication - The user can define a schedule for the
replication to occur automatically
Continuous Replication - The replication process
happens continuously without intervention
DR for Fusion Middleware with ZFS Storage
ApplianceSolution Description
• The ZFS Storage is simply added to the customer’s existing
environment
• Shell scripts automate and coordinate ZFS Storage and Data Guard
failover and failback
Primary site Secondary site
Oracle Data Guard
Replication of binaries,
configuration data,
metadata
10GbE
Web Server
Application
Servers
Database Server
ZFS Storage
Appliance
10GbE
Web Server
Application
Servers
Database Server
ZFS Storage
Appliance
Oracle Fusion Middleware Disaster Recovery
ArchitectureThe entire Oracle FMW infrastructure is replicated to a remote site, using
Data Guard for the Database and the ZFS Storage Appliance for all other data
Primary Array Primary Array
DR for Fusion Middleware
Oracle Data Guard
• Fusion Middleware stops
• Failover to 2nd ZFS Storage appliance
Primary site
10GbE
Web Server
Database Server
ZFS Storage
Appliance
Primary Array
Secondary site
Web Server
Application
Servers
Database Server
ZFS Storage
Appliance
10GbE
Primary Array
Application
Servers
Replication of binaries,
configuration data,
metadata
DR for Fusion Middleware
Oracle Data Guard
Primary site
10GbE
Web Server
Database Server
ZFS Storage
Appliance
Primary Array
Secondary site
Web Server
Application
Servers
Database Server
ZFS Storage
Appliance
10GbE
Primary Array
Application
Servers
• Role Reversal
• Clients access secondary site
Replication of binaries,
configuration data,
metadata
DR for Fusion Middleware
• Failback: Primary site becomes active again
• Clients access primary site
Primary site Secondary site
Oracle Data Guard
Replication of binaries,
configuration data,
metadata
10GbE
Web Server
Application
Servers
Database Server
ZFS Storage
Appliance
10GbE
Web Server
Application
Servers
Database Server
ZFS Storage
Appliance
Primary Array Primary Array
• Use Sun ZFS Storage Appliance to replicate all non-database content to
ensure brief RTO and aggressive RPO for the Oracle Fusion Middleware
environment
• For high availability, deploy clustered Sun ZFS Storage Appliances
• NFS protocol is preferred for the FMW deployments for the ease of
deployment and maintenance
• Store all the non-database FMW infrastructure within a project and
replicate the project
Oracle Maximum Availability Architecture MAA Best
Practices for Oracle FMW DR Configuration and
Deployment
Oracle Maximum Availability Architecture MAA Best
Practices for Oracle FMW DR Configuration and
Deployment
• Use the Scheduled mode of replication for a typical Oracle FMW DR
deployment
• Use the Continuous mode of replication if the standby site is required to be
up-to-date irrespective of whatever the rate of change at the primary site
• Snapshots and clones can be used at the target site to offload backup,
test, and development types of environment
• Configure Oracle Data Guard with the “Maximum Availability” option, to
enable the standby database to be almost synchronized with the primary
DR for Fusion Middleware with ZFS Storage Appliance
Automated and coordinated with Data Guard
Protect the whole business process
Tested, validated, and supported by Oracle
Save tens of thousands of $ on data services
Simplicity
Savings
Reduced Risk
Benefits
DR for Fusion Middleware with ZFS Storage Appliance
Savings
• All data services (snaps, clones, replication, compression, thin
provisioning, etc.) are included in the ZFS Storage Appliance at no cost
• With Oracle Database 11g Enterprise Edition, no additional database
software licenses are required
• High capacity disk drives in a densely populated configuration enable a
low cost solution with a small footprint and lower energy costs
• ZFS data compression improves storage efficiency and thus reduce
capital expenditures by reducing storage capacity requirements
1/3 lower TCO than
EMC and NetApp
DR for Fusion Middleware with ZFS Storage Appliance
Simplicity
• The intuitive BUI management interface and simplified administrative procedures reduce operations costs by reducing administration time
• Predefined scripts automate and coordinate the process between ZFS Storage Appliance and Data Guard further simplifying management of the DR environment
• Fast provisioning and configuration helps reduce initial setup costs
Edison Group Usability Study
Simplicity
• 34% less time required to provision and configure the storage
and its connectivity
• 31% less time for maintenance and typical configuration changes
• 44% less time spent troubleshooting
Shows that the ZFS Storage Appliance can be managed
more efficiently than a comparable NetApp system
DR for Fusion Middleware with ZFS Storage Appliance
Simplicity
• Having too many vendors on hand can dramatically increase cost of management and reduce overall environment efficiency
Oracle Hardware and Software
Engineered to Work together
• Engineered to work together
• Tested together
• Certified together
• Packaged together
• Deployed together
• Upgraded together
• Managed together
• Supported together
Simplicity
DR for Fusion Middleware with ZFS Storage Appliance
Reduced Risk
• Provides full redundancy for both the Oracle database and the Oracle Fusion Middleware infrastructure
• End-to-end checksums in the ZFS Storage Appliance help prevent data corruption
• Self-healing features of the ZFS Storage Appliance help avoid service interruptions
• DTrace Analytics helps reduce the risk of downtime by making it easier to find and fix performance issues
Complete Oracle Support for the
Sun ZFS Storage Appliance
Oracle provides world-class technical assistance and comprehensive global
services to help you maximize the return on your IT investment and minimize risk
• Get immediate access to deep expertise so your staff can focus and be
more productive
• Take the risk out of your IT environment. Unlimited, 24/7 access to
systems specialists and online technical resources help you proactively
avoid business interruptions and enhance security
• Expect maximum performance. Optimize your IT environment with total-
system server support featuring fully-integrated hardware and OS coverage
• Maintain uninterrupted data availability. Enterprise storage system
support protects your data so you get the highest business value from your
technology
Oracle Customer Services storage experts utilize Oracle’s innovative storage technologies to drive efficiencies and
maximize business value of storage infrastructures
Maximize Availability with Oracle’s Service
Expertise
Readiness Services
Oracle storage experts
configure, integrate
and test storage
products and bring
them into production.
Storage experts safely
test and migrate data
and applications to new
environment and
provide knowledge
transfer to staff.
Data MigrationServices
Proven back up
monitoring and
management as well
as restore services that
deliver SLA based data
protection.
Operations Management
Complete system
coverage for embedded
system software
delivered together with
system support as a
single service solution.
Support
Oracle University offers
comprehensive training
for Storage
Administration,
including disk storage,
SAN, Tape, and NAS.
Learning
Summary
The ZFS Storage Appliance compliments the disaster
recovery capabilities of Oracle Data Guard to fully
protect the Oracle Fusion Middleware infrastructure
• Oracle MAA tested and certified solution
• Simplify disaster recovery procedures
• Lower total cost of ownership
• Reduce risk
• Engineered and serviced by Oracle
• Hardware and Software
• Engineered to Work together
Next Steps
• For more information about Oracle Data Guard
http://www.oracle.com/technetwork/database/features/availability/
data-guard-documentation-152848.html
• For more information about Oracle Fusion Middleware
http://www.oracle.com/technetwork/middleware/fusion-
middleware/overview/index.html
• For additional information about the ZFS Storage Appliance
http://www.oracle.com/us/products/servers-storage/
• For additional information about the Data Guard solution
http://www.oracle.com/goto/zfs-data-guard
• For additional information about the Oracle Fusion Middleware
solution: http://www.oracle.com/goto/zfs-middleware