Amol Bhoite

Protect Hitachi Unified Compute Platform for Oracle Database 12c with Hitachi Data Instance Director, Veritas NetBackup, and Hitachi Content Platform

Blog Post created by Amol Bhoite Employee on Feb 6, 2017

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

Outcomes