Skip navigation
1 2 3 Previous Next

Oracle

31 posts

Hitachi Solution for Databases, with XaaS cloud foundation for Oracle Database, powered by Oracle VM and Oracle Linux Validated Configurations provide and application-ready, high performance and resilient cloud platform for easier, faster, and lower-cost deployment of Oracle Database and applications in your enterprise.

 

Oracle VM and Oracle Linux Validated Configuration program offers pre-tested, validated configurations—including software, hardware, storage, and network components—along with documented deployment guides. Hardware Solution vendors participating in this program perform thorough testing of the hardware in real-world configurations with Oracle Linux and Oracle VM. The result: Improved performance and reliability of Oracle Linux and Oracle VM solutions, with faster, lower-cost implementations.

 

Validated configuration is tested on Hitachi XaaS Cloud Foundation for Oracle Databases.

 

The high-level storage configuration diagram for this solution is shown here:

 

 

Hitachi’s Validated configuration direct link: https://linux.oracle.com/pls/apex/f?p=102:2:::NO::P2_VC_ID,P2_VERSION:701,1.0

 

For more information on Hitachi Xaas Foundation for Oracle Database See Reference Architecture white paper : https://www.hitachivantara.com/en-us/pdfd/architecture-guide/hitachi-solution-databases-reference-architecture-oracle-xaas-cloud-foundation.pdf

 

For more details on Oracle’s Validated configurations program: http://www.oracle.com/technetwork/server-storage/linux/validated-configurations-085828.html

          Use Hitachi Solution for Databases - Oracle XaaS Cloud Foundation to provide reliability, high availability, scalability, and performance while processing small to large Oracle workloads. This reference architecture is a validated cloud solution for Oracle Database 12c running on Oracle VM 3.4.4, with virtual machines using Oracle Linux 7.3.

Oracle XaaS Cloud Foundation is fast, agile, and aims to be a more efficient use of resources. Cloud deployment aims for IT transformation. You want a fast and flexible journey to reduce cost, quickly scale up or down, and—most importantly—be easy and intuitive.

          This solution integrates many innovative technologies from Hitachi Vantara and Oracle. To create an Oracle database cloud service, this environment uses Hitachi Unified Compute Platform CI with Oracle Virtual Machine and Oracle Enterprise Manager (OEM) Cloud Control 13c. Unified Compute Platform CI includes Hitachi Virtual Storage Platform G800 (VSP G800), Hitachi Advanced Server DS220 with Intel Xeon Gold 6140 processors for storage and computing resources, and Hitachi Advanced Server DS120 with Intel Xeon Silver 4110 processors for the management servers. It provides a base of the following to migrate to Oracle database cloud service:

  • Quick database deployment in the cloud
  • Validation of virtual machine configurations
  • Central monitoring of Hitachi storage and servers, virtual machines, database, and applications

This solution provides the flexibility to select storage and compute resources based on unique requirements. Deploy small databases as well as huge databases, depending on resource availability.

As a cloud solution, this environment provides simple provisioning, chargeback/showback, and a centralized user interface using Oracle Enterprise Manager Cloud Control 13c.    

Business Benefits

Oracle VM provides the foundation for the cloud infrastructure. It provides fully integrated enterprise management from disk to applications to cloud. It provides rapid enterprise application deployment with Oracle VM templates.

This solution uses an Oracle VM server pool created with multiple Hitachi Advanced Server DS220 servers to deploy virtual machines for an Oracle RAC database. Oracle XaaS Cloud Foundation provides the flexibility to add or remove servers in the Oracle VM server pool based on business requirements.

Configure Oracle Enterprise Manager Cloud Control 13c to self-provision and administer the integrated technology stack, including storage, Oracle virtual machines (VMs), and Oracle databases.

Hitachi Advanced Server DS120 uses VMware ESXi to deploy virtual machines for the management servers. The management servers include the following:

  • Oracle VM Manager
  • Oracle Enterprise Manager
  • Manager for Hitachi adapters for Oracle Database
  • Hitachi Infrastructure Analytics Advisor

You can deploy the manager for Hitachi adapters for Oracle Database as a virtual appliance in VMware ESXi and Oracle VM. Additional management server VMs can be deployed if needed.

Storage Configuration

The configuration takes into consideration Hitachi Vantara for Hitachi Virtual Storage Platform and Oracle recommended practices for the design and deployment of database storage.

  The high-level storage configuration diagram for this solution is shown here:

 

 

Test Results

These are the performance test results

Oracle Orion Test Results

 

Peakmarks Test Results

Peakmarks Test Results for Scaling up Database from 2 TB, 4 TB, or 8 TB

Click Here to get Hitachi Solution for Databases Reference Architecture for Oracle XaaS Cloud Foundation

Business Problem Statement

Today we live in a world that new and creative business models are driven by technology advancement. The need for Digital Transformation to create new revenue streams, reduce costs, streamline operations, increase speed to market, and allow internal collaborations has become ever more paramount, and the result of that intensifies the pressure on IT organizations to come up with the right and modern design of “Digital Foundation”, an IT infrastructure that is integrated, secured, salable and cost-optimized, to set enterprises up for business success.

The fact that IT as well as data demands grow by multiples on an annual basis, IT spends a tremendous amount of time and resources evaluating, installing and stacking up disparate hardware components, not to mention the challenge to integrate servers, storage and networking infrastructure for the building of a virtualization layer on which they can finally place and enable application software. Furthermore, the lack of a unified management framework, and the need for highly specialized individuals who can design, configure, optimize, test and manage each component increases cost, complexity and risk. This deficiency often results in additional costs that exceed an organization’s business plan prediction, cannibalizing the investment in other value-creation initiatives, such as cloud, Big Data, and IoT.

 

Business benefit and Solution Value Propositions

The answer to these problems is Hitachi Solution for Oracle Real Application Clusters Database 12c.

Hitachi Solution for Oracle Real Application Clusters Database 12c is engineered, pre-configured, pre-tested, and qualified to provide predictable performance and the highest reliability in demanding, dynamic Oracle environments. This solution is validated to ensure consistent, predictable results.

Hitachi Solution for Oracle Real Application Clusters Database 12c offer integrated computing options, simplified management and improved utilization that cut total cost of ownership.

This proven solution to optimize your Oracle database environment integrates servers, storage systems, and networks. The environment provides reliability, high availability, scalability, and performance while processing small-scale to large-scale on-line transaction processing (OLTP) and online analytical processing (OLAP) workloads.

 

Overview

This blog describes Oracle Orion and Peakmarks performance results with Hitachi Solution for Databases Reference Architecture for Oracle Real Application Clusters Database 12c

The environment uses Hitachi Virtual Storage Platform G800 (VSP G800), Hitachi Advanced Server DS220 with Intel Xeon Gold 6140 processors, and Hitachi Advanced Server DS120 Servers with Intel Xeon Silver 4110 processors.

 

Storage Architecture

Below is the storage architecture used for the testing.

Test Results

These are the test results.

 

Oracle Orion Test Results

 

Test Case

Test / Workload type

Metric

Value

1

Storage performance -

100% OLTP Random Read (8k)

Max. IO/s

601,499

Avg. RT

1.07 ms

2Storage performance -100% OLTP Random Writes (8k)Max. IO/s

159,307

Avg. RT

1.1 ms

3Storage performance -100% OLAP Sequential Reads (1024K)Max. Throughput

12.21 GB/sec

4Storage performance -100% OLAP Sequential Writes (1024K)Max. Throughput

7.3 GB/sec

 

Peakmarks Test Results

 

Test CaseTest / Workload typeMetricValue
1Storage performance random read (STO-RR)Max. IO/s

400,041

Avg. RT

1.07 ms

2Storage performance random write (STO-RWF)Max. IO/s200,094
Avg. RT

1.02 ms

3Storage performance sequential read (STO-SR)Max. Throughput

10.58 GB/s

4Storage mixed random read write (STO-MIX 20% update ratio)Max. IO/s261,134
Avg. RT1 ms
5Database medium OLTP select performance - 25 rows per transaction (DBX-S25)Throughput in transactions per second25,388
Throughput in rows per second634,694
Avg. RT for SQL statement

1.1 ms

6Server performance test - OLTP 25 rows per transaction(SRV-S25)Throughput in transactions per second17,950
Throughput in rows per second1,292,394
Throughput in logical buffer reads per second33,731,989
Avg. RT for SQL statement

0.1

7

CPU processor performance test - Arithmetic ADD operation (CP2-SA)

Throughput in operations per second

165,090,903,205

 

Click here to get Hitachi Solution for Databases Reference Architecture for Oracle Real Application Clusters Database 12c

    A large bank customer was looking for high performance Oracle database solutions to upgrade their current production environments in multiple locations. They had tested Oracle "Engineered System" Exadata, and inquired a high end storage vendor for array performance, and then came to us for a PoC in early July this year. We proved to the customer that a small system configuration of G1500 with 32 x 7TB high-density Flash Module Drives, and two small half width CB2500 520H B4 blades and two PCIe expansion blades can far exceed their performance criteria and meet the budget requirement.

    By comparing results, according to the customer, the large single instance Oracle database running on our PoC environment outperformed the Oracle Exadata system by 41% with OLAP workloads.

    For OLTP workloads, the Hitachi solution achieved significant better results than  Oracle Exadata X6-2's.

 

     Peakmarks results for Oracle Exadata X6-2 can be found here.

 

    We got a feedback from a vendor of commercial performance benchmarking product when we're preparing and testing Oracle solution with the small VSP G1500 - "If you really loaded 2 x 8 TByte in less than 90 minutes, you are using an extreme fast system. I have never seen such a load rate before!"The vendor started to believe the fact when we shared event logs and performance test results. That benchmarking product is being used by many enterprise storage, server, or solution appliance vendors around the globe including Oracle Corporation. Hitachi VSP G1500 All Flash configuration is the true performance king of All Flash Arrays (AFA)!!!

 

    Unlike an "Engineered System", VSP G1500 used in the Hitachi solution has many proven array based software features for mission critical database applications,  i.e. 3-DC Business Continuity and Disaster Recovery. 3-DC with GAD (Global-Active Device) is a great fit for Oracle RAC on extended distance cluster deployment.

 

  To design a high performance Oracle solution under budget for mission critical application has never been easier than before if you choose Hitachi VSP G1500 All Flash configurations. For more information for Hitachi UCP for Oracle RAC with G1500 and two half width blades, please visit blog post and reference architecture.

      You can also visit blog post for more details of the PoC and tech note if you are on Hitachi Corp network.

Use Hitachi unified Compute Platform (UCP) 6000 for Oracle Real Application Cluster with two two-way symmetrical multi-processing (SMP) nodes and G1500 storage that provide high performance, high availability and highly scalable converged solution for Oracle databases.

 

This solution uses 4 Hitachi CB2500 520X B3 full width blades for two 2-way SMP nodes with 88 CPU cores per SMP node, a single controller Hitachi Virtual Storage Platform G1500 with 48x 1.6 TB FMDs, two Brocade G620 Fibre Channel switches and 4 16Gb/s HBAs with 8 ports on each SMP node.

 

Hitachi Virtual Storage Platform G1500 is flash-optimized virtual storage platforms that deliver up to 4M IOPS of performance and offer the industry's only 100% data-availability guarantee. Hitachi Virtual Storage Platform G1500 uses virtual storage directors (VSDs) that are shared across the cache, front-end directors (FEDs), and back-end directors (BEDs), providing immediate processing power without wait time of interruption to maximize I/O
throughput.

 

The storage systems provide a highly granular upgrade path, allowing the addition of drives to the drive chassis and components such as FEDs to the controller chassis as storage and processing needs increase. Hitachi Storage Virtualization Operating System (SVOS) provides storage virtualization, high availability, superior performance, and advanced data protection for all Virtual Storage Platform. This proven, mature software provides common features to consolidate assets, reclaim space, extend life, and reduce migration effort.

 

For more information, please visit the Reference
Architecture of Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters with SMP Server Blades and Hitachi Virtual Storage Platform G1500

     A single Oracle 12c RAC database running on two small blades servers can perform more than 2 million IOPS at 1ms or lower latency. This is a great news to many enterprise customers - not only to support their heavy day-to-day database workloads, but also to handle large monthly or quarterly batch jobs. Many mission critical databases often get workload spikes once or a few times a year, i.e. during holiday shopping seasons for online retailers.  Spare performance capability of IT infrastructure becomes a huge burden. With this Hitachi UCP 6000 for Oracle solution, customers do not need to spend extra for standby infrastructure.

   

    This solution uses two Hitachi CB2500 520H B4 half width blades, two PCIe expansion blades for extra HBAs, two Brocade G620 switches, a single controller G1500 with 34x 7TB high density FMDs. A total 88 physical CPU cores are used on the blade servers.

 

For comparison the Cisco/Pure FlashStack 8-node Oracle RAC solution uses 8 Cisco UCS B-series B200 M4 blades servers and a total of 224 physical CPU cores.

  

    Based on the Oracle Technology Global Price List released on June 1, 2017, the Hitachi solution can save more than 9.5 millions US dollars Oracle licensing cost on "Enterprise Edition" and "Real Application Cluster" option over Cisco/Pure solution!!

  

    The Hitachi solution can also perform 4x or higher IOPS with 1ms or lower latency-

   oracle_cal_io.PNG

hitachi_slob_results.PNG

hitachi_slob_iops.PNG

hitachi_slob_rt.PNG

    For the Hitachi solution, there is room to grow as the size of the G1500 used is about 25% of the maximum VSP G1500 configuration.A CB2500 blade server chassis can have up to eight 520H B4 blades with 8 PCIe expansion blades.

 

 

Slob performance results from Cisco/Pure Solution -

Cisco/Pure 8-node Oracle RAC solution can only scale up to 64 SLOB users, beyond that latency increases quickly.

Cisco_pure_iops.PNG

 

Cisco_pure_rt.PNG

 

   For more information, please visit the RAhttps://www.hds.com/en-us/pdf/architecture-guide/hitachi-whitepaper-ucp-6000-for-oracle-rac-using-vsp-g1500-haf-cb-2500-with-intel-xeon-2699v4-processors.pdfof Hitachi UCP 6000 for Oracle RAC using VSP G1500, HAF, and Hitachi CB2500 520H B4 blades.

Business Problem Statement

In today’s fast-paced world, organizations that depend on technology to drive business innovation are intensifying the pressure on IT to deliver services faster and more cost-effectively than ever before. IT spends lot of their time and resources evaluating and installing increasingly disparate hardware components. To solve this problem, organizations should evaluate converged infrastructure solutions.

These are the top priorities of today’s businesses to keep their business up and running, securely and to balance IT supply (resources and skills) with IT demand and to increase agility to quickly respond to new business requirements.

 

Business benefit and Solution Value Propositions

The answer to this problem is Hitachi Unified Compute Platform for Oracle Real Application Clusters Database 12c using Hitachi Virtual Storage Platform G200.

 

Hitachi Unified Compute Platform for Oracle Database is engineered, pre-tested, and qualified to provide predictable performance and the highest reliability in demanding, dynamic Oracle environments. This solution is validated to ensure consistent, predictable results.

Hitachi Unified Compute Platform converged infrastructure solutions offer integrated computing options, simplified management and improved utilization that cut total cost of ownership.

This proven solution to optimize your Oracle database environment integrates servers, storage systems, and networks. The environment provides reliability, high availability, scalability, and performance while processing small-scale to large-scale on-line transaction processing (OLTP) and online analytical processing (OLAP) workloads.

 

This solution will help Hitachi friendly customers who are looking for converged Oracle solutions which are not covered by UCP 6000 for Oracle RAC.

 

Overview

This blog describes Oracle Orion and Peakmarks performance results with Hitachi Unified Compute Platform for Oracle Real Application Clusters Database 12c using Hitachi Virtual Storage Platform G200

Storage Architecture

Below is the storage architecture used for the testing.

 

  

Test Results

These are the test results.

Oracle Orion Test Results

Peakmarks Test Results

Click here to get Hitachi Unified Compute Platform reference architecture guide for Oracle Real Application Clusters Database 12c using Hitachi Virtual Storage Platform G200

There are a number of white papers available to assist you with protecting the data in your Oracle environments. For reference here are links to collaterals documenting solutions for protecting Oracle environments. Since Data Protection principles apply primarily to storage, the same principles can be applied to both Compute Blade as well as Rack Mount based environments.

 

Hitachi Xaas Foundation for Oracle Databases, powered by Oracle VM and Oracle Linux Validated Configurations provide and application-ready, high performance and resilient cloud platform for easier, faster, and lower-cost deployment of Oracle Database and applications in your enterprise.

 

Oracle VM and Oracle Linux Validated Configuration program offers pre-tested, validated configurations—including software, hardware, storage, and network components—along with documented deployment guides. Hardware Solution vendors participating in this program perform thorough testing of the hardware in real-world configurations with Oracle Linux and Oracle VM. The result: Improved performance and reliability of Oracle Linux and Oracle VM solutions, with faster, lower-cost implementations.

 

For more information on Hitachi Xaas Foundation for Oracle Database See Reference Architecture white paper : https://www.hds.com/en-us/pdf/best-practices/hitachi-cloud-foundation-for-oracle-database.pdf

 

To review the Oracle  website for Validated configurations: http://www.oracle.com/technetwork/server-storage/linux/validated-configurations-085828.html

 

Hitachi’s Validated configuration direct link:  https://linux.oracle.com/pls/apex/f?p=102:2:::NO::P2_VC_ID,P2_VERSION:694,1.0

 

Hitachi Validated configuration is tested on Hitachi Xaas Foundation for Oracle Databases.

This Hitachi cloud solution for Oracle provides flexibility to deploy storage and compute resources based on your unique business requirements. This cloud solution features simple provisioning, chargeback/showback, and a centralized user interface using Oracle Enterprise Manager (OEM) Cloud Control 13c. Cloud Foundation provides reliability, high availability, scalability, and performance while processing small-scale to largescale Oracle E-Business Suite (EBS) workloads. The database and application servers E-Business Suite run on Oracle VM 3.4.1. The operating system for the virtual machines is Oracle Linux 7.2. The Oracle E-Business Suite version is 12.2.6, which also includes Oracle Database 12c R1.

 

This provides rapid deployment of E-Business Suite applications from a basic configuration of a single node to a complex multi node application with Oracle RAC. The following are the highlights of this E-Business Suite solution:

  • Single node E-Business Suite application and database for development and test environments
  • Provision of Oracle RAC (including Cluster) database
  • Provision of multi-node application tiers for production and user acceptance testing environments
  • The ability to configure a load balancer in multi-node environments
  • The ability to configure parallel concurrent processing
  • Additional managed servers to support, based on instance sizing (small, medium, and large)

 

Achieve rapid provisioning of Oracle E-Business Suite using Oracle Enterprise Manager Cloud Control 13c by leveraging deployment procedures with the following:

  • A preconfigured database template, including gold images of grid home, database home, and database files
  • 12.2.6 application templates uploaded to the Oracle Enterprise Manager software library Use Oracle Enterprise Manager Cloud Control 13c self service portal for provisioning a virtual machine as part of Oracle Virtual Machine services.

 

The provisioned Oracle E-Business Suite comprises the following:

  • Oracle E-Business Suite 12.2.6
  • Oracle Database 12.1.0.2
  • Applications DBA (AD) and Technology Stack (TXK) Delta 8 patchset
  • Oracle Database October 2016 CPU patches
  • Applications Technology Group (ATG) Rollup (RUP) 6 patch level
  • Oracle WebTier 11.1.1.9

 

For more information, visit Reference Architecture here: https://www.hds.com/en-us/pdf/architecture-guide/hitachi-cloud-foundation-for-oracle-e-business-suite.pdf

 

This solution was jointly developed with Hitachi Consulting (HCC), and is restricted to Hitachi Consulting (HCC) sales only. For any questions, please touch base with the Oracle Solutions PM (UCPOraclePM@hds.com) team.

Use Hitachi Cloud Foundation for Oracle Database to provide reliability, high availability, scalability, and performance while processing small to large Oracle workloads. This reference architecture is a validated cloud solution for Oracle Database 12c running on Oracle VM 3.4.1, with virtual machine using Oracle Linux Operating System 7.2.

 

Cloud is fast, agile, and aims to be a more efficient use of resources. Cloud deployment aims for IT transformation. You want a fast and flexible journey to reduce cost, quickly scale up or down, and—most importantly—be easy and intuitive.

This solution integrates many innovative technologies from Hitachi Data Systems and from Oracle. To create a Oracle database cloud service, this environment uses Hitachi Unified Compute Platform (UCP) with Oracle Virtual Machine and Oracle Enterprise Manager (OEM) Cloud Control 13c. Unified Compute Platform has Hitachi Virtual Storage Platform G800 (VSP G800) and Hitachi Compute Blade 2500 (CB 2500) for storage and computing resources.

 

It provides a base of the following to migrate to Oracle database cloud service:

  • Quick database deployment in cloud
  • Validation of virtual machine configurations
  • Central monitoring of Hitachi storage and servers, virtual machines, database, and applications

 

This solution provides flexibility to slice and dice storage and compute resources based on unique requirements. Deploy small databases as well as huge databases, as long as there are resources available. As a cloud solution, this environment features simple provisioning, chargeback/showback, and centralized user interface using Oracle Enterprise Manager Cloud Control 13c.

 

For more information, visit Reference Architecture here: https://www.hds.com/en-us/pdf/best-practices/hitachi-cloud-foundation-for-oracle-database.pdf 

Description

The UCP 6000 for Oracle RAC with Broadwell processor solutions showcases the newest generation of Intel CPUs and the latest released version of Hitachi Accelerated Flash modules “DC2” as well as larger HDD drives. This solution aims to meet customer expectations and keep up with the latest introductions of Oracle (e.g. Exadata X6-2) and other competitors who will introduce the next generation of their solutions using the latest CPU architecture from Intel. This project focuses on the refresh of UCP 6000 for Oracle RAC overall solutions.

 

Methodology

The solutions is to be built to provide the best price/performance for Oracle solutions, including CPU, RAM, Flash storage, and HDD.

 

Solution

 

The reference architecture covers a quarter-rack environment for Hitachi Unified Compute Platform 6000 for Oracle RAC. Below are the high-level concerpts covered in the white paper:

  • Solution components
  • Solution design
  • Storage architecture
  • Network architecture

 

Storage Architecture

 

 

 

 

For more information, take a look at the full Reference Architecture document at HDS.com

The Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters on Two Nodes Using Hitachi Virtual Storage Platform G600 with NAS Modules and Hitachi Compute Blade 2500 solution addresses the following business priorities:

 

  • Establish best practices for running Oracle 12c RAC on Hitachi Virtual Storage Platform G600 with NAS modules
  • Create a reference architecture for an Oracle 12c RAC on Hitachi Virtual Storage Platform G600 with NAS modules solution

  The Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters on Two Nodes Using Hitachi Virtual Storage Platform G600 with NAS Modules and Hitachi Compute Blade 2500 solution provides a UCP solution to respond to NAS based competition in the Oracle market. This enables the teams to have discussions about the real performance requirements and leads to an adjusted configuration that provides better value to the customer.  

Business benefit and Solution Value Propositions

  This blog describes at a high level the reference architecture whitepaper describing the Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters on Two Nodes Using Hitachi Virtual Storage Platform G600 with NAS Modules and Hitachi Compute Blade 2500 solution solution.  Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters on Two Nodes Using Hitachi Virtual Storage Platform G600 with NAS Modules and Hitachi Compute Blade 2500 shows how using Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters on Hitachi Virtual Storage Platform G600 with NAS Modules provides an integrated solution for an Oracle infrastructure. Use this document to design an infrastructure for a customer’s requirements and budget.  This validated solution integrates servers, storage systems with NAS modules, network, and storage software. The environment provides reliability, high availability, scalability, and performance while processing small-scale to large-scale OLTP workloads. The dedicated servers run Oracle Database 12c Release 1 with the Oracle Real Application Clusters (RAC) option. The operating system is Oracle Linux 7.2. 

Overview

  This is a high level view of the tested architecture for the Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters on Two Nodes Using Hitachi Virtual Storage Platform G600 with NAS Modules and Hitachi Compute Blade 2500 solution. The validated environment implements Hitachi Unified Compute Platform 6000 for Oracle Real Application Clusters on two nodes using Hitachi Virtual Storage Platform G600 with NAS modules. In this configuration, a Hitachi Compute Blade 2500 and  520H B4 half-width server blades with Intel Xeon E5-2699v4 processor CPUs are used.  High-level concepts covered in the white paper:  

  • Solution components
  • Solution design
  • Storage architecture
  • Network architecture 

 

Storage Architecture

 

 

The storage architecture used for the solution is documented in the white paper. It takes into consideration Hitachi Data Systems and Oracle recommended practices for the deployment of database storage design. A high level view of the storage architecture is shown below.

Business Problem Statement

Good Disaster Recovery (DR) practice requires keeping usable business-critical backups offsite. Organizations have traditionally implemented this by writing backups to tape and shipping the tapes to be stored offsite. This is costly and operationally complex, requiring hardware, personnel, and sound procedures to ensure that the offsite backups are up-to-date, secure, and able to be recalled and used in the face of disaster. While shipping and secure storage are often outsourced, the IT organization of the enterprise retains the burden of ensuring the integrity of the backups and procedures. Enterprises deploy multi-tiered storage architectures to store their production data and backups to reduce the overall capital and operating expenses for their storage infrastructure.

For long term archives, and backups, they utilize tape vaulting and store tapes in an offsite location. Many small and medium businesses that do not have a tape infrastructure have to deploy some form of virtual tape or disks for storing backups and archives.

 

Oracle Database High Availability is always a high priority for Oracle, as we understand that keeping business online 24/7, 365 Days a Year is vital. Backup windows are under pressure to shrink due to the performance impact of backup and the 24/7 nature of modern business, but the amount of data to protect is constantly growing. Traditional backup takes hours to complete.

 

To address these problems, customers are increasingly turning to hardware-based snapshots and cloud infrastructure.

 

Business benefit and Solution Value Propositions

The answer to protect Hitachi Unified Compute Platform for Oracle database from HDS and other Oracle deployments is, using Hitachi Data Instance Director (HDID), Veritas NetBackup, and Hitachi Content Platform.

 

Protect Hitachi Unified Compute Platform for Oracle Database 12c with Hitachi Data Instance Director, Veritas NetBackup, and Hitachi Content Platform, solution is based on proven Oracle high availability technologies, to propose Disaster Recovery (DR) and long term Oracle database backup storage.

 

This pretested, backup and recovery solution be used to accelerate data protection with reliability, redundancy, scalability, high availability while processing small-scale to large-scale OLTP workloads.

HCP storage offers storage redundancy, security, availability and scalability with geographic distribution that enables it to absorb a broad range of adverse events without loss of availability. These characteristics make it an excellent alternative to writing, shipping and storing tapes in a secure location.

 

Lastly, backups are created and updated over the network, with minimal or no operator involvement – drastically simplifying operational procedures. Cloud services for storing backups offer business benefits in terms of elasticity in capacity and operational expenses. It can also simplify your own infrastructure as you no longer need to provide and manage storage (e.g., tapes that need to be rotated, shipped away, etc.).

Overview

This blog describes how to do the following:

 

  • Perform Oracle Database 12c backup (Hitachi Thin Image snapshot) and perform backup mount on the proxy server using Hitachi Data Instance Director.
  • Perform Oracle Database 12c restore, and recovery operations using Hitachi Data Instance Director.
  • Perform Oracle Database 12c backup from proxy server to Hitachi Content Platform using Veritas NetBackup.
  • Perform restore, and recovery operations on the application or production host from Hitachi Content Platform storage using Veritas NetBackup.

Storage Architecture

This describes Hitachi Unified Compute Platform for Oracle Database protection solution using HDID, NetBackup, and HCP                                                                             

Below is the storage architecture used for the testing.

  

Test Results

These are the test results.

Test case

Result

Backup Oracle - HDID Scheduled snapshot (Hitachi Thin Image), mount on proxy server

Success

Restore (Revert) Oracle database using HDID and Recover Oracle Database with manual steps

Success

Backup 'Hitachi Thin Image Snapshot mount' from proxy server to Hitachi Content Platform using Veritas NetBackup

Success

Restore and recover backup(Oracle database) from HCP through NetBackup directly to application host

Success

 

Click here to get reference architecture guide to protect Hitachi Unified Compute Platform for Database Oracle 12c with Hitachi Data Instance Director, Veritas NetBackup, and Hitachi Content Platform

Click Here to get recorded hand on scenario execution video on Hitachi Unified Compute Platform for Oracle Database 12c protection with Hitachi Data Instance Director, Veritas NetBackup, and Hitachi Content Platform

Oracle databases are used for many mission-critical enterprise applications. The requirement to make these applications consistently available implies the use of Disaster Recovery (DR) technologies to avoid any unplanned downtime. Customers may want to add DR capabilities to their Oracle environment and want to use Hitachi Global Active Device (GAD) as a common DR implementation for Oracle database and other application. Direct consequences of application downtime and data unavailability are unhappy customers, loss of productivity and revenue and challenges to corporate reputation. In short, enterprise deployments needs protection from unforeseen disasters and natural calamities.

 

An answer to this problem from Hitachi Data Systems (HDS) is Hitachi global-active device. The base “UCP 6000 for Oracle RAC” solution provides a highly available solution, in addition to this GAD provides an explicit DR features. Customers can protect their database in Oracle 12c real application cluster (RAC) environment with global-active device on Hitachi Virtual Storage Platform (VSP) G Series.

Best practice guide "Protect Database Oracle 12c with Global-Active Device on Hitachi Virtual Storage Platform G Series" has demonstrated how GAD can be deployed to add DR capabilities to an ‘UCP 6000 for Oracle RAC’ solution. This best practice guide demonstrates how to use global-active device in VSP G series to protect Oracle Database 12c with RAC in a two-site environment. See how to deploy global-active device to add backup and recovery capabilities in an Oracle environment to achieve zero for a recovery point objective (RPO) and a recovery time objective (RTO) in case of disaster or component failure.

 

GAD ensure continuous operations for your most mission critical data and applications by simplifying and automating high availability. It extends storage virtualization horizontally across multiple enterprise storage systems and achieves active-active clustering and volumes that span physical systems.

Figure 1 shows RAID groups and provisioning pools created for the environment on each VSP G600, each Hitachi Compute Blade 2500 and Hitachi Compute Blade 500 on site 1, site 2 and the quorum site.

Storage_Final.png

Global storage virtualization provides "global active volumes." These are storage volumes with the ability to have read and write copies of the same data in two systems or geographic places at the same time. The active-active storage design enables production workloads on both systems in a local or metro cluster configuration while maintaining full data consistency and protection. Configuring Oracle Real Application Clusters on extended distance with global-active device lets you to create and maintain synchronous, remote copies of data volumes on Hitachi Virtual Storage Platform G series storage.

The evaluated architecture used a synchronous replication model for zero data loss between two Hitachi Virtual Storage Platform G600 storage systems that were separated by 20 km and 100 km for load balancing and active/active availability. A network emulator unit was used to emulate the systems at certain distances apart between the site 1 and site 2 to observe any disaster recovery obstacle due to the increased distance between sites.

 

Table below lists the most common use cases and scenarios evaluated

Use Case

Objectives

Results

Use Case 1 — Recover Oracle Database After Complete Site 1 Failure

Recover from a complete site 1 storage system and Oracle RAC hosts failure while Oracle Database instances still run on the surviving site 2 storage system.

Success

Use Case 2 — Recover Oracle Database After Site 1 Storage Failure

Recover from a site 1 storage system failure while Oracle Database instances are running on the site 2 storage system.

Success

Use Case 3 — Recover Oracle Database After Quorum Site Failure

Recover from a quorum disk failure while Oracle database instances are running at the surviving site.

Success

Use Case 4 — Recover Oracle Database After Storage Replication Link Failure

Recover from storage replication link failure between site 1 and site 2 storage systems.

Success

Use Case 5 — Recover Oracle Database After Path Failure Between Servers and Local Storage System

Recover from path failure between servers and local storage.

Success

Use Case 6 — Recover Oracle Database after All Fibre Channel links Fail

Recover from a failure all of the Fibre Channel link connections between site 1 and site 2.

Success

Use Case 7 — Demonstrate Planned Power Off and Power On at Site 1

Demonstrate how to perform a planned outage and restart with the site 1 storage system.

Success

 

In conclusion, using Hitachi Storage Virtualization Operating System with global-active device provides an infrastructure with continuous availability that does the following:

  • Protect your database with global-active device from unplanned outages at data centers to keep database available.
  • Use global-active device with host-based applications to fail over between a primary site and secondary site Hitachi Virtual Storage Platform Gx00 with no disruption. Hitachi Dynamic Link Manager provides host multi-pathing with deep storage integration.
  • There is no adverse effect on recovery procedures and data protection for distances between sites that are 20 km to 100 km apart.

You can leverage the benefits of synchronous data replication beyond traditional disaster recovery protection to include workload balancing across sites and coordinated site-wide maintenance with no downtime.

 

Sincere thanks to  Yoshihito Katayama, Tsuyoshi Inoue, ITPD Team, Steven Burns, Eduardo Freitas for their vital contribution and making this paper possible.

 

Please Click Here to get best practice guide to Protect Database Oracle 12c with Global-Active Device on Hitachi Virtual Storage Platform G Series

Please Click Here to get recorded video for hands on done for executing scenario where we  "Recover Oracle Database After Storage Replication Link Failure."