Transcript Solution Set - Oracle Software Downloads

Raj Gulati
NetApp Alliances, Oracle
Network Appliance
Paul Veilleux
Advanced Technical Services
Oracle Corporation
Oracle and NetApp
Center of Excellence
Agenda…





What’s a COE? Why?
What do we do? What can we do for you?
Architecture benefits
ON Services
Who’s using this stuff? Why?
“Knowledge is experience. Everything else is
just information”
Albert Einstein
Why?
• Support our Customers
• Reflect on experiences / lessons learnt
• Embed knowledge sharing into routine work
• Develop communities committed to dialogue and collaboration
• Share knowledge that is important to the business.
• Turn knowledge into solutions and innovation
Center of Excellence
Teams
Teams
Competency Center
Consulting
Teams
Training
Solution sets, blueprints, best practices
Center of Excellence – Benefits
Customers
Do More with Less
Create, Share and Deliver Knowledge
Knowledge repositories, best practices , “yellow pages”,
learning and knowledge sharing
Teams
Teams
Competency Center
Consulting
Teams
Training
Solution sets, blueprints, best practices
Customers
Doing More with Less
Typical Big Ticket IT Costs
Maintenance
22% of IT Budget
Implementation
41% of IT Budget
Software
17% of IT Budget
Hardware
20% of IT Budget
Source: Gartner, 2001
Oracle and NetApp: helping customers
Doing More with Less
Maintenance
Savings
Maintenance
IT
Infrastructure
Customer IT
Budget Today
Deployments
IT
Infrastructure
Oracle and NetApp
Value Proposition
Deployments – Apps
Infrastructure
Lowering Infrastructure, deployments costs
Scalable, Modular Architecture
Hardware
• Unbreakable Linux/NetApp
Software
Savings
• Oracle Databases
• E-business suite
• Collaboration Suite
Accelerated Deployments
Oracle and NetApp
Value Proposition
•
•
•
•
•
Database Consolidation
Data Protection
High Availability (Oracle 9iRAC)
Disaster Recovery
E-Business Suite*, Collaboration Suite*
Joint Support
• Escalation teams
Data Consolidation – Solution Set
Multiple Database Servers with NetApp Networked Storage
Oracle DB Server1
Oracle DB Server2
Oracle DB Server3
Solution Sets
Switch
NetApp Storage Appliance:
- Network Attached Storage (NAS) or
- Storage Area Network (SAN)
 Multiple databases distributed across multiple servers each
with its database on a networked storage appliance from
NetApp.
–
–
Low TCO and with simplified ease of maintenance
Almost no database application or server downtime for scheduled
and unscheduled maintenance
Data Protection – Solution Set
RAC DB Server
9i RAC
Database
GigE / FCP
GigE Ethernet /
FCP Switch
GigE / FCP
Storage
Interconnect
SnapVault
Up to 256 Volumelevel Snapshots
NDMP Tape
Backup
Client
™
NetApp NAS/SAN
Storage Appliance
NearStore™
Tape
Archive
R100/R150 Disk-Based Storage
• Snapshot™ software can be scheduled and managed with SnapManager® tool. SnapVault is a tool that will
then take these Volume level Snapshots and move them to disk based storage on the NetApp
R100/R150 line of NearStore™ filers.
High Availability - Oracle9iRAC on NetApp
Oracle9i RAC on Oracle Clusters on Linux with NetApp NFS Storage
Public Network
Node 1
RAC Server
Oracm on
Linux Intel
Ethernet
Switch
Public Network
Cluster Interconnect Heartbeat. GigE
GigE
GigE
Storage Interconnect
Multi Path – dual redundant NICs,
switches and interconnects for no
single point of failure assumed
Also, a clustered filer pair is
needed for SPOF
GigE
Switches
NetApp Storage Filer(s)
RAC Shared Disk
Subsystem
Node 2
RAC Server
Oracm on Linux
Intel
Disaster Recovery - Solution Set
Primary Site
NetApp
NAS/SAN
Storage
Appliance
Standby Site
NetApp
NAS/SAN
Storage
Appliance
NetApp Asynchronous
Disk-based Replication
GigE / FCP
/vol/Oracle
Data, Log &
Cntrl files
GigE / FCP
NetApp Asynchronous SnapMirror
Changed blocks are
shipped to the
target mirrored
volume
®
/vol/Oracle
Mirrored Data,
Log and
Cntrl files
• Oracle DB volumes on primary and standby site are SnapMirrored
• Remote site’s Oracle DB is kept in recovery mode
• When disaster strikes primary site, it’s a matter of breaking the SnapMirror and bringing up the remote
standby site’s Oracle DB in query/update mode
Disaster Recovery – Solution Set
Oracle Data Guard Approach
for Oracle Disaster Recovery
Archived
Redo Logs
Physical
Standby
Database
Apply logs
Log data
Managed
Recovery
Primary
Database
Archived
Redo Logs
Log data
Transform
log files to
SQL statements
Logical
Standby
Database
Apply SQL
statements
Read/Write
Consulting
Lowering
Implementation
Cost
Oracle Strategy:
Low Cost Rapid Implementation
Typical Implementation
Oracle’s Strategy
 Scope Creep
 Focused on Specific Objectives
 Surprise Costs
 Fixed Price, Scope
 Mimic Existing Practices
 Incorporate Best Practices
 Unique by customer
 Repeatable Formula
 Physical presence
 Online Effort
Success Based on
Luck, not Experience
Lower Risk
Measurable Results
Business Flow Accelerators
Old
World
New
World
Time
Design
Assemble
Deploy
Operate
Conference
Room Pilot
In 3 Months
Customize
Consultants
On-Site
IT
Oracle
Department
Conference
Consultants
Room
Configure
On-line
Pilot on
Day 1
BOL
E-Business
Suite
Outsourcing
66% Less Time
33% Lower Cost
Best Practices
JET
Foreword
Storage Challenges
Storage Architectures
NAS
SAN
Unified
NetApp® Technology
Hardware
Software
Architectural benefits for running Databases on Filers
Example Oracle® deployments
Solution Sets for Oracle on NetApp
Backup and Recovery
Disaster Recovery
High Availability for RAC – OLTP and DSS
Acceleration
Collaboration Suite
E-Business Suite or Applications
Competitive Advantage of Filers
Lowest TCO for Databases
Contacts at Network Appliance
Reference Technical Reports
Case Studies
Videos
ON Training
Best Practices document highlighting:
• Design Considerations
- Reference Topology
- Ideal Product Stack
• Deployment guidelines
- Database Architecture
- Performance Management
• On-going management tips
- Backup and Recovery Procedures
- Implementing Disaster Recovery Plans
- High Availability
Oracle/NetApp Strategy:
Low Cost Rapid Implementation
Current Portfolio
Fixed cost, Fixed Scope
Accelerators
Lower Risk
Measurable Results
•
•
•
•
•
Storage Assessment
ON Deployments (SAN/NAS)
High availability
Disaster recovery
Capacity/Performance
Tuning
Planned Additions
 E-Business Suite/Apps
– Cloning, Migration
 Collaboration Suite
ON Services – ON Accelerator
Purpose: Jumpstart customer’s Oracle on
NetApp environment
–
–
–
7 days (or more)
Variants for NFS, SAN, VLD, DAFS
implementations
Design database layout, migration,
backup/recovery for customer’s NetApp
environment
Framework for Joint Services Offering
• NetApp sells, Oracle and NetApp deliver
• Quick install of Oracle database on NetApp
• Transition services of database storage from direct
attached to NetApp filers
• Documentation with best practices
• Training and Transfer of Information to DBAs and
Sys Admins, as appropriate
Some customers
Customer Benefits
• Services delivered in just
7 days!
• Time savings of over
50%!
• Best practices install
minimizes post-sale
support issues
• PEACE OF MIND with
professional guarantee
from Oracle Consulting
Case Study – Southwest
Airlines
Application:
• Southwest Airlines Rapid Rewards Systems
Requirements:
• High-Availability
• Scalable
• Reduce Complexity
• Lower TCO
Solution:
• 9iRAC on Sun-Solaris Servers with NetApp
Filers
• 9iRAC – 2week accelerator
Case Study – Statue of Liberty
Ellis Island Foundation
Application:
American Family Immigration History Center (AFIHC)
•
•
•
•
•
Located on the World Wide Web
One of largest Genealogical databases
Records immigrant arrival records (100 M+)
Averages 120 million hits per month
E-Commerce shopping site
Requirements:
• Low TCO
• High-Performance
• High-Availability, Redundancy
• Load Balancing
NetApp Filer
Solution:
• 9iRAC on Redhat Linux Server with NetApp Filers
• 9iRAC – 2week accelerator
Case Study: MercadoLibre
Before:
 Latin American affiliate of
eBay
 Sun E-class and T3
 Rapid growth of storage
causing too much
downtime
 Mediocre IO performance
(even after tuning)
After:
 Replaced T3 arrays with
single Filer
 Ability to grow storage with
no down time
 6% greater read
throughput
 15% greater write
throughput
Oracle and NetApp: helping customers
Doing More with Less
Maintenance
Savings
Maintenance
IT
Infrastructure
Customer IT
Budget Today
Deployments
IT
Infrastructure
Oracle and NetApp
Value Proposition
Deployments – Apps
Infrastructure
Center of Excellence – Here to serve you
Customers
Do more with less
Create, Share and Deliver Knowledge
Knowledge repositories, best practices , “yellow pages”,
learning and knowledge sharing
Teams
Teams
Competency Center
Consulting
Teams
Training
Solution sets, blueprints, best practices
QUESTIONS
ANSWERS