Amol Bhoite

Protect Oracle Database with Hitachi Data Instance Director(HDID) In a Two-Site Environment Using Hitachi NAS Platform 4080 and Hitachi Virtual Storage Platform G600

Blog Post created by Amol Bhoite Employee on Sep 1, 2016

Business Problem Statement

Oracle Databases form the backbone to many critical applications. Traditionally their data is protected using RMAN backups to stream data and logs to a backup target, such as tape. With the growth in data, this model is becoming strained. The amount of time needed to complete backups and recoveries are not meeting business requirements.

Networked-Attached Storage (NAS) systems have become commonplace in enterprise data centers. This widespread adoption can be credited in large part to the simple storage provisioning and inexpensive connectivity model. Furthermore, the cost of NAS appliances has decreased dramatically in recent years.

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, so something has to give. Traditional backup processes create a full backup of the databases and logs, which can takes hours to complete. This means that a backup can be completed, at best, once per day, supporting a recovery point objective (RPO) of 24 hours. As much as 24 hours of new database records may be at risk of loss, or need to be rolled back or re-entered, in the event of a failure of any type.

Business benefit and Solution Value Propositions

The answer to this problem from HDS is the Hitachi Data Instance Director (HDID) for Oracle using Hitachi Virtual Storage Platform and Hitachi NAS Directory Clone and file replication on Hitachi NAS Platform 4080.

HDID with Oracle in a two site using Hitachi NAS 4080 and Hitachi Virtual Storage Platform G600, best practices guide is based on proven Oracle high availability technologies, to propose Disaster Recovery (DR) for on-premises systems.

This provides a writable, directory leveling, cloning to enable a complete and an efficient backup and recovery of an Oracle® database.

A simpler, faster way to copy, clone, and manage your databases—and protect your business—using Hitachi Virtual Storage Platform and Hitachi NAS Directory Clone and file replication on Hitachi NAS Platform 4080.

With the HDID with Oracle, DBAs no longer need to be dependent on IT personnel to backup, restore, recover, or clone databases, allowing both DBAs and storage administrators to focus on their specialty while unburdening IT of time-consuming tasks. It allows DBAs to do their jobs more effectively in less time, with greater flexibility and less dependence on storage administrators.

Having a seamless end-to-end solution for Oracle and Data Protection gives our customers the --experience that they desire with the company they trust.

The HDID product provides application-consistent storage-based clone and remote file replication orchestration for Oracle database environment using an intuitive, comprehensive and efficient user interface. Showing our customers the value of HDID with our Oracle solutions is a high priority to the success of our Oracle Business.

Overview

This blog describes how to do the following:

  • § Protect Oracle Database configured as a two node Oracle RAC with HDID in a two-site environment
  • Concurrent snapshot (Directory Clone — File Replication — Directory Clone)
  • § Clone Oracle Database using HDID, Hitachi NAS Platform, and Hitachi Virtual Storage Platform
  • Clone an Oracle Database with directory clone

Storage Architecture

This describes the three-site infrastructure to protect Oracle Database with the RAC option with the NAS-shared file system using HDID.

Below is the storage architecture used for the testing.

  

Test Results

These are the test results of protecting Oracle with HDID in a two-site environment.

Site 1 Oracle 2-node 12.1.0.2.0 Real Application Cluster Database Configuration Summary

Metric

Value

Oracle Database File System size

2 TB

Oracle Database fill factor

65%

Total number of data files

8

Database Mode

Archivelog

Database Storage Type

Cluster Shared File System

Test Execution Results Summary

Test

Metric

Value

Test 1: Concurrent Snapshot

Initial  file replication time

5 Hours 7 Minutes 56 Seconds

Site 1 directory clone snapshot time

50 Seconds

Site 2 directory clone snapshot time

6 Seconds

File replication mount time

10 Seconds

File replication Unmount time

8 Seconds

Manual Complete recovery time

Approximately 1 Minute

Test 2: Clone Oracle Database

Directory clone snapshot time

15 Seconds

Directory clone Mount operation time

5 Seconds

Directory clone Unmount operation time

5 Seconds

Manual Clone database Complete recovery time

Approximately 1 Minute

 

Click here to get best practice guide to Protect Oracle Database with HDID in a Two-Site Environment Using Hitachi NAS Platform 4080 and Hitachi Virtual Storage Platform G600

Outcomes