Amol Bhoite

Protecting Oracle Database With Hitachi Data Instance Director In a Two Site Environment

Blog Post created by Amol Bhoite Employee on Feb 3, 2016

Business Problem Statement

 

Oracle Databases form the backbone to many critical applications. 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. In any other case, the productivity would be interrupted, data could potentially be lost, but most importantly corporate image would be tarnished with unpredictable devaluation of share price.

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. This means that until backup can be completed 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.

To address these problems, customers are increasingly turning to hardware-based snapshots and replication but this is not easy. Generally, in-depth knowledge is needed to create scripts to manage this hardware based data protection. Changes to the environment such as the addition of capacity need careful management and constant updating of scripts. Customers rely on staff with this deep technical knowledge during setup, maintenance, and restoration of data. There is risk in having human generated scripts and there is risk in reliance on a handful of staff with this specialized knowledge.

 

Business benefit and Solution Value Propositions

 

This blog describes at a high level answer to this problem from HDS is the Hitachi Data Instance Director (HDID) to protect Oracle in a two-site environment. HDID is having a seamless end-to-end optimized Solution for Backup, Replication, and Recovery for Oracle and Data Protection.

HDID with Oracle in a two-site environment, best practices guide is based on proven Oracle high availability technologies, to propose Disaster Recovery (DR) for on-premises systems.

This pretested, backup, replication solution and Recovery can be used to accelerate data protection with reliability, redundancy, scalability, high availability while processing small-scale to large-scale OLTP workloads and management with HDID centralized console.

 

Overview

 

This blog describes at a high level how to protect an Oracle Database two node Real Application Cluster (RAC) with Hitachi Data Instance Director (HDID) in a two-site environment and how to clone Oracle Database using HDID.

High-level concepts covered:

  • Concurrent snapshot (Hitachi Thin Image (HTI) – Hitachi TrueCopy – Hitachi Thin Image)
  • Concurrent snapshot (Hitachi Thin Image – Hitachi Universal Replicator (HUR) – Hitachi Thin Image)
  • Clone with Hitachi ShadowImage Replication

 

Storage Architecture

 

RAC option and ASM with HDID infrastructure is used for the testing environment and to protect Oracle Database.

Below is the storage architecture used for the testing.

 

 

Test Results

 

These are the test results of protecting Oracle with Hitachi Data Instance Director in a two site environment.

 

Test execution results Metric

Value

Site 1 Database Configuration

Total ASM Diskgroup size

15 TB

Oracle Database size

12 TB

Database fill factor

90%

Database Mode

Archivelog

Database Storage Type

ASM

Archivelog and Flash Recovery Area Location

ASM

Total number of data files

85, including small and big Tablespace data files

Concurrent Snapshot (HTI – TrueCopy – HTI)

TrueCopy Replication time

4 Hours 23 Minutes 4 Seconds

Site 1 Hitachi Thin Image Snapshot time

10 Minutes 26 Seconds

Site 2 Hitachi Thin Image Snapshot time

11 Minutes 21 Seconds

TrueCopy Replication Mount time

10 Minutes 26 Seconds

Manual Complete recovery time

Approximately 2 Minutes

Concurrent Snapshot (HTI – HUR – HTI)

Hitachi Universal Replicator time

6 Hours 51 Minutes 5 Seconds

Site 1 Hitachi Thin Image Snapshot time

10 Minutes 59 Seconds

Site 2 Hitachi Thin Image Snapshot time

11 Minutes 13 Seconds

Universal Replicator Mount time

15 Minutes 16 Seconds

Manual Complete recovery time

Approximately 2 Minutes

Clone with ShadowImage Replication

 

Scheduled In-System ShadowImage Replication clone time

1 Hours 59 Minutes 30 Seconds

Scheduled Refreshed Thin Image Snapshot and Mount operation time

17 Minutes 48 Seconds

Refreshed Thin Image Mount (with trigger)  time

6 Minutes 1 Second

Manual Complete recovery time

Approximately 1 Minute

 

Click here to get best practice guide to Protect Oracle Database With Hitachi Data Instance Director In a Two Site Environment

Outcomes