Amol Bhoite

Achieve Strict Service Level Objectives by Protecting your Oracle RAC Database with Hitachi's Global Active Device with Hitachi Data Instance Director

Blog Post created by Amol Bhoite Employee on Jan 17, 2019

The importance of achieving continuous business operations for your organization is something most cannot afford to underestimate. This is true even for some test environments. The importance of data backup and recovery, especially when dealing with business-critical database workloads should be taken seriously as data loss can lead to huge operational, and in many cases, negative financial impacts to an organization.

Organizations need to ensure the data center site failover is transparent while eliminating the need for reconfiguration, specifically when unexpected failures or planned updates occur. Organizations need to provide continuous data access to end-users, to achieve strict zero recovery time and recovery point objectives (RTO/RPO)

Also, organizations are looking for a cohesive data management solution that enables them to create business-focused policies that govern automated workflows which simplify data center management.

The answer to these problems is Hitachi Solution for Oracle RAC Database 12c with Global Active Device (GAD) using Hitachi Data Instance Director (HDID).

HDID enables you to orchestrate and automate the protection of data stored on Hitachi Unified Compute Platform for non-multitenant Oracle Database 12c. This solution is particularly useful for Oracle Real Application Clusters on Extended Distance (Stretched) clusters in a two-site environment using global-active device in Hitachi Unified Compute Platform CI using VSP G900 (multi-site deployment of Oracle RAC).

Hitachi Vantara has released enhancements to its Global Active Device (GAD). GAD supports active-active processing of shared data; all interfaces to the storage system are always active, and the system synchronizes writes across the participating storage systems. Today, setting up GAD in a customer environment employs the use of Hitachi Data Instance Director (HDID), a copy data management orchestration platform that enables organizations to create business-focused policies that govern automated workflows.

 

Overview

Using HDID enables you to orchestrate the deployment of global-active device and therefore add high availability capabilities in an Oracle environment to achieve zero recovery point objective (RPO) and recovery time objective (RTO). Using global-active device in a two-site replication environment with Virtual Storage Platform (VSP) storage provides data protection for Oracle Database. HDID also orchestrates Hitachi Thin Image snapshots on both VSP arrays to create point-in-time copies so that you can quickly recover from logical errors such as a corrupt database or ransomware.

Our Hitachi Unified Compute Platform CI architecture 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.

The UCP CI system used for testing and validation of this solution included Hitachi Virtual Storage Platform G900, Hitachi Advanced Server DS220 with Intel Xeon Gold 6140 processors, and Hitachi Advanced Server DS120 Servers with Intel Xeon Silver 4110 processors.

 

The Virtual Storage Platform (VSP) F Series [RV1] is Hitachi Vantara’s all-flash storage product line. In early 2018, Hitachi Vantara released product updates to achieve increased IOPS and lower latency, greater scalability in terms of usable capacity, and support for containerized workloads. To maximize customers’ ROI, Hitachi Vantara has extended its 100% data availability guarantee to all VSP models.

 

Storage Architecture

Below is the storage architecture used for the testing.

 

Benefits of using HDID Versus Using Manual Commands for GAD Setup and Configuration

The table below shows the benefits of using HDID versus using manual commands for GAD setup and configuration.

 

Comparison of HDID vs Manual Commands for GAD Setup

GAD Setup and Configuration

Using Manual Commands

Using HDID

Web-Based UI for management flexibility

û

ü

Quick and easy to setup and implement GAD

û

ü

Automated GAD and storage operations

û

ü

Quick GAD teardown/reset up/site recovery - Less administration

û

ü

One click Pause, Resume and Swap GAD replication options

û

ü

Automated GAD HORCM configuration and setup

û

ü

No need of HORCM storage command knowledge to setup and manage GAD

û

ü

Informative log messages and monitoring explains entire process of the GAD pairing and tiering operation

û

ü

Select secondary site storage Pool, Quorum disk and host groups on a single screen

û

ü

Automated mapping SVOLs to multiple host groups on the secondary storage site

û

ü

 

Test Results

The table below highlights the test results achieved during our HDID and GAD test for protection of the deployed Oracle RAC Database 12c environment - hosted on the Hitachi Unified Compute Platform for non-multitenant Oracle Database 12c.

 

Use Case

Services Impacted After Failure

Services Affected During Recovery

Total Service Downtime

Recover Oracle Database After Storage Replication Link Failure between Site 1 and Site 2 storage systems

No

No

Zero Time

Recover Oracle Database After Site 2 Storage Failure

No

No

Zero Time

Recover Oracle Database After Quorum Site Failure

No

No

Zero Time

Recover Oracle Database After Path Failure Between Servers and Local Storage System

No

No

Zero Time

 

Click here to get Hitachi Solution for Oracle RAC Database 12c with GAD using HDID

Outcomes