Application Consistent Backup with Hitachi Virtual Infrastructure Integrator

Document created by Paul Morrissey on Feb 14, 2015Last modified by Paul Morrissey on May 11, 2016
Version 6Show Document
  • View in full screen mode

Hitachi Virtual Infrastructure Integrator (Hitachi V2I) provides scheduled automated backup service for VMs and datastores running on Hitachi Storage infrastructure. It provides VM and App consistent backup services for windows and Linux based VMs out of the box.


It natively supports the Windows based applications (MS SQL, Exchange etc.) by calling VSS writers to quiesce the application before we do storage based snapshots (if specified in backup policy)


The following outlines additional steps and location of scripts to perform application consistent backups for Linux based VMs specific to MySQL and Oracle with Hitachi V2I.

For further information on Hitachi V2I, read recent Blog

 

1 For MYSQL database:

Pre-requisites before running application consistent Quiesce backup from V2I

1.      Create a Linux VM machine with all the python, perl and MySQL packages.

2.      Download/Copy the following scripts to Linux machine under location /usr/sbin/:

pre-freeze-script.sh

post-thaw-script.sh

unquiesce.py

quiesce.py

3.       Rename pre-freeze-script.sh and post-thaw-script.sh to pre-freeze-script and post-thaw-script.

4.       Create a directory: /scripts.

5.       Assign appropriate permissions to scripts directory.

6.       Give MySQL root@localhost password in unquiesce.py and quiesce.py.

7.       Install VMtools on the VM.

 

1.2 Steps to perform Application Consistency backup from V2I

 

1)       Run V2I Quiesce Backup of VM. Please select the Quiesce option as shown in the below screenshot:

appqui1.png

2)       Check the log files are created under /scripts directory.

 

1.3 Common issues faced with script copied and troubleshooting tips,

1)       When you run quiesce.py and unquiesce.py scripts, it may give indentation errors as shown in the following screenshot if incorrectly copied/pasted:

appqui2.png

Troubleshooting tips-

·         Give proper indent for the both the scripts.

o    Remove all blank lines from shell script pre-freeze-script.sh and post-thaw-script.sh.



2 ORACLE database:

Pre-requisites before running application consistent Quiesce backup from V2I


1.      Create VM with CentOS 6 x64 with install proper VMware tools.

2.      Install oracle 11g XE on same machine.

Please follow the instruction as given in the below link:

http://www.davidghedini.com/pg/entry/install_oracle_11g_xe_on

3.      Copy all the following scripts provided by HDS on VM

pre-freeze-script.sh

post-thaw-script.sh

pre-freeze-script.sql

post-thaw-script.sql

consistent-archivelog-backup.rman

 

4.       Create directory “DBscripts” under /u01/app/oracle/.

5.       Copy files pre-freeze-script.sql, post-thaw-freeze.sql and consistent-archivelog-backup.rman in above directory.

6.       Change the owner of DBscript directory: #chown–R oracle:dba DBscript

7.       Copy pre-freeze-script.sh to pre-freeze-script under and post-thaw-script.sh to post-thaw-script /usr/sbin directory.

 

2.2 Application Consistency backup from V2I

1.       Run V2I Quiesce Backup of VM.

2.       Check the log files are created under /u01/app/oracle/DBscripts directory:

pre-freeze.log

post-thaw.log

 

2.3 Common issues faced with script copied and troubleshooting tips

 

1.       Issue: /bin/sqlplus is not found.

Troubleshooting tip: Check that environment variable ORACLE_HOME is properly set for the user profile.

 

 

Attachments

    Outcomes