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.
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
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.
These are the test results of protecting Oracle with HDID in a two-site environment.
Site 1 Oracle 2-node 126.96.36.199.0 Real Application Cluster Database Configuration Summary
Oracle Database File System size
Oracle Database fill factor
Total number of data files
Database Storage Type
Cluster Shared File System
Test Execution Results Summary
Test 1: Concurrent Snapshot
Initial file replication time
5 Hours 7 Minutes 56 Seconds
Site 1 directory clone snapshot time
Site 2 directory clone snapshot time
File replication mount time
File replication Unmount time
Manual Complete recovery time
Approximately 1 Minute
Test 2: Clone Oracle Database
Directory clone snapshot time
Directory clone Mount operation time
Directory clone Unmount operation time
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