NetApp Solution For Oracle Database

Accelerate your business in a data-driven world with efficiency and agility

The Challenge

Oracle databases facilitate business- critical applications and are key to the success of countless data-driven enterprises. Enterprise-level SLAs demand a responsive, uninterrupted experience for employees, customers, and partners who access Oracle data. In addition, deploying and supporting new infrastructure models such as cloud computing can be complicated and time-consuming. You need an infrastructure for Oracle that can deliver consistently high levels of performance, data availability, and data protection while meeting your operational cost guidelines.

Database teams need a storage infra- structure that’s responsive enough to facilitate, not inhibit, database Performance. In addition, the explosive growth of database instances and the critical data that they house creates a variety of management challenges, from provisioning and cloning to backup and disaster recovery. Without automated management tools that integrate data-bases with underlying storage, database administrators (DBAs) can’t respond to rapidly changing business needs.

Storage teams are under pressure to provide an infrastructure that exceeds user expectations while driving out complexity and capital and operating inefficiencies. The infrastructure must remain up and running, meet performance and availability SLAs, and provide ample resources to accom- modate rapidly expanding database environments without wasted capacity.

Together, IT teams need a highly efficient, integrated solution to eliminate these issues and deliver superior IT services for Oracle databases.

The Solution

The NetApp solution for Oracle Database delivers industry-leading storage, unprecedented scalability, continuous data access, and automated data management for immediate response to business opportunities.

“Since moving the Oracle database to NetApp storage, we have saved time, money, and resources while improving the site’s reliability and scalability.”

Rodrigo Benzaquen
System Administrator, MercadoLibre

NetApp has worked with Oracle for years, developing innovative, integrated solutions that reduce IT and business costs and complexity. NetApp leads the way with data storage, offering com- pelling solutions for Oracle databases.

Scalable performance

  • Get performance flexibility to match changing database needs with NetApp Data ONTAP 8.
  • Benefit from nonstop performance and availability to keep production databases up and running with Data ONTAP 8 clustering.
  • Optimize database transactions with synergy between Oracle partitions and NetApp flash storage solutions.

Efficient operations

  • Eliminate planned downtime with transparent, nondisruptive mobility of applications and data.
  • Avoid unnecessary business database outages during storage maintenance operations by using clustered Data ONTAP 8 with NetApp DataMotion™  software.
  • Match the scalability and availability characteristics of Oracle RAC at the storage layers.
  • Consolidate and reduce Oracle Database license costs.

Intelligent management

  • Provide higher data availability with simple, reliable, and much faster disk-based backup and recovery for databases.
  • Use an efficient, affordable, and proven disaster recovery (DR) and business continuity solution.
  • Double DBA productivity with superior integrated Oracle Database cloning capabilities.

Performance Agility

Storage is the most important performance factor in database environments. Ninety percent of database performance issues in both physical and virtual infrastructures can be traced to the storage tier. To avoid a business impact, your database storage must deliver sustained performance for multiple Oracle instances and quickly optimize I/O as peak workloads change.

NetApp storage scales Oracle performance nondisruptively, without limits. The NetApp FAS series with Data ONTAP 8 offers a variety of innovations designed for multiprotocol, high-performance databases. For example, NetApp collaborated with Oracle to design a Direct NFS (DNFS) connectivity solution for customers who use the NFS protocol. DNFS provides the same performance and latency characteristics of FC and FCoE for Oracle databases. As a result, you gain the flexibility to select or change your network connectivity model as your Oracle database infrastructure evolves.

NetApp Data ONTAP with DataMotion enables you to dynamically balance workloads to maintain or enhance performance to meet new database service levels. Ineffective load balancing often results in storage hotspots associated with overloaded volumes, which can dramatically affect database performance. Data ONTAP 8 clustering with DataMotion solves this issue effortlessly by transparently moving the affected volumes to different storage aggregates or nodes without affecting users or applications.

figure_01

Low storage latency is critical for high- performance OLTP workloads. NetApp storage can reduce latency by a factor of 10 or more. You can also increase I/O throughput by 78% with NetApp Flash Cache™ intelligent caching, a deduplication-aware read cache for
hot blocks of Oracle transaction data. Flash Cache provides a virtual storage tier without the increased cost and complexity of an additional physical storage tier. NetApp Flash Pool™ technology further enhances perfor- mance by enabling SSDs and HDDs  to be pooled, and it automatically optimizes I/O by moving data across multiple tiers. Finally, so that individual databases get appropriate QoS from storage resources in multi-tenancy environments, NetApp provides the FlexShare®  capability to prevent Oracle database performance from being compromised by other storage activities.

The online, nondisruptive capability of Data ONTAP 8 makes it a smart choice for a scalable storage platform for Oracle infrastructure.

Eliminate Planned Downtime with Nondisruptive  Operations

NetApp Data ONTAP 8 clustering enables nondisruptive storage opera- tions and scalability, providing an optimal 24/7 storage platform for your Oracle RAC database. The addition of transparent volume migration between clustered storage systems results in zero impact or downtime to running databases, eliminating a potential weak link in your database infrastructure.

In addition to the nondisruptive operations of Data ONTAP 8, NetApp OnCommand® Insight and OnCommand Balance products provide key perfor- mance indicators, early warning signs of storage infrastructure contention, and guidance for resolving issues to help maintain availability SLAs.

Backup, Recovery, and DR Simplicity

The time and expense related to backup and recovery in Oracle environments
are growing. The challenge to DBAs is also increasing with the growing size and complexity of databases that must be managed and recovered more quickly. To remain competitive, DBAs and storage administrators must be able to complete backups and restores more quickly and reliably.

DBAs must minimize the chance of data loss and increase the availability of Oracle systems. The NetApp Integrated Data Protection (IDP) solution, designed specifically for Oracle, can reduce  DBA time by 50%. NetApp empowers storage teams and DBAs by providing access to storage technologies and protection services that run on NetApp Snapshot™ technology, which enables fast, frequent backups and restores of large databases in a fraction of the time and space of traditional methods. NetApp IDP has become one of the fastest, easiest, and most efficient methods to back up, recover, clone, and provide DR of Oracle databases.

Achieve Your Goals with Industry- Leading Efficiency

NetApp enables maximum data storage and operational efficiencies while minimizing complexity and resources  to drive down costs. NetApp efficiency technologies are driven by innovation, including NetApp Snapshot, FlexClone®, and SnapMirror®  technologies; NetApp SnapVault®  software; Data ONTAP com- pression; NetApp FlexVol® and RAID-DP® technologies; and Flash Cache caching.

An internal study showed how Flash Cache, which decreases the number  of drives required for many workloads, achieved superior Oracle performance. Results showed 50% more available capacity, 66% less power required, and and Oracle Recovery Manager (RMAN), so you can manage your database environment with the tools that you use every day.

The ability to do so much more with so

  • Lower your risk with verification testing, documentation, and post-implementation review
  • Free up your internal resources so they can focus on other strategic
    projects

59% less rack space used, driving down the TCO of NetApp storage. much less physical storage is a strong competitive advantage that NetApp

In addition to storage efficiency, NetApp’s core technologies make Oracle data management simple and time-efficient. You can enable efficient thin provisioning and reallocation of Oracle storage with NetApp FlexVol technology. You can also leverage NetApp SnapManager®  for Oracle and FlexClone technology to simplify and automate the database cloning and refresh process—with practically no extra storage needed, no time- consuming approval loops, and in 97% less time. NetApp also integrates with Oracle products such as Oracle Multitenant, Oracle Enterprise Manager, customers are using to meet their efficiency goals with greater flexibility. Why manage complexity when you can eliminate it with NetApp?

Partner for Success

NetApp Storage Design and Implemen- tation Service for Oracle enables you to quickly and reliably achieve production readiness for your NetApp and Oracle environment. This service helps you:

  • Streamline your deployment for clustered Data ONTAP
  • Implement the solution quickly by using proven methodologies and best practices

About Greyson Technologies

Headquartered in Fort Lauderdale, FL, Greyson Technologies is an engineering firm that architects and delivers secure Collaboration and Unified Data Center solutions. Greyson designs and deploys datacenter virtualization platforms for our clients; and provide technologies that empowers their employees to collaborate more efficiently. Greyson’s experienced and local engineering resources architect and implement solutions that deliver measureable business outcomes for our clients. Greyson competencies include Collaboration and Unified Communications; converged infrastructure, storage solutions, and enterprise network platforms. Learn more at www.greyson.com; follow us on Twitter @greysontech; link to us on LinkedIn; or like us on Facebook.