Product Review: HyperBac for Oracle
August 29, 2007
Synopsis. Oracle 10g Release 2 (10gR2) offers significant enhancements to database backup and recovery with Recovery Manager (RMAN), including the ability to compress backup sets and encrypt backups for increased security. A relatively new product called HyperBac provides an excellent alternative to Oracle 10gR2 compressed backupset methodology without the need to modify any RMAN backup, restoration, and recovery scripts. In addition, HyperBac also provides the ability to compress and encrypt Oracle DataPump dumpsets. This article provides an overview of HyperBac features that nicely complement Oracle 10gR2s enhancements to database backups and exports.
When I first reviewed the new features that Oracle Database 10g Release 1 (10gR1) offered in the Recovery Manager (RMAN) arena, I recognized immediately that the capability to create incrementally updateable image copy backups was an immense improvement over prior releases. It offers DBAs the means to perform a single incremental level 0 image copy backup of the databases datafiles and then simply apply just the changed blocks in later incremental level 1 backup sets of those same datafiles to update the initial base backup. (For details on how to implement this feature, please see my article on this and other RMAN enhancements in Oracle 10g.)
Oracle 10gR1 also introduced a third way to create a database backup, the compressed backup set, to the RMAN tool set. Compressed backup sets still contain all the same block-level information as their uncompressed counterparts, but take up a lot less space normally between 25% to 50% compression. For datafiles that contain predominantly character-based information, the compression ratio could be as great as 90%.
Oracle 10gR2 also added the ability to create encrypted backup sets. RMAN now can apply advanced encryption algorithms to any Oracle backup set via a password derived from one of three sources: Transparent Data Encryption (TDE) only, password only, or either password or TDE. Once encrypted, the backup sets cannot be decrypted without application of the corresponding password. (Please see my article on RMAN encrypted backups for a full explanation of these security features.)
These are impressive features, but I believe that a few capabilities are unfortunately still missing in Oracle Database 10g:
HyperBac Features Overview
Fortunately, Ive found a potential solution to these shortfalls with an application named HyperBac from Xceleon Technologies, a technology partner with Oracle Corporation. The HyperBac web site offers plenty of information about its availability for several different RDBMSs and platforms besides Oracle.
The easiest way to understand how HyperBac works is to think of it as a filter. HyperBac simply accepts input from RMAN or DataPump, filters that input by applying either encryption or compression, and then produces an output file thats saved to disk. When restoring a datafile, or importing data back into an Oracle database, HyperBac applies the filter in reverse, either decrypting or decompressing the backup files in the backup set or export dumpset during the restoration or import operation. HyperBac offers the following features:
Evaluation Environment Setup
For the record, Im using a dual-core AMD Athlon 64-bit CPU (Winchester 4200) to run VMWare Server 1.0.3 to access a virtualized database server environment. I configured my VMWare virtual machine to fully utilize both of the dual-core CPUs but just 1024 MB of memory. For my VMWare virtual machines OS, I used the Oracle Enterprise Linux (OEL) version that is equivalent to Red Hat Enterprise Linux 4.0 Update 4 (i.e. Linux kernel version 2.6.9-188.8.131.52.1.ELsmp).
Once my VMWare virtual machine was configured, I installed the software for Oracle Database 10gR2 (10.2.0.1.0) and then constructed the standard 10gR2 seed database, including the standard sample schemas. I then used RMAN to create a series of baseline backup sets and image copy backups for later comparisons against those Id be creating with HyperBac. Listing 1 illustrates the creation of an RMAN image copy full backup of the database; Listing 2 and Listing 3 show the creation of full backups of the database using both the normal compressed backup set methods, respectively.
Installing HyperBac for Oracle
HyperBac is extremely easy to install. I simply downloaded the corresponding HyperBac demonstration software that matched my VMWare virtual machines environment, obtained the appropriate key for the 30-day demonstration, and then installed the software on my database server. Note that the installation of HyperBac for Oracle does require root-level access to the host:
$>./hyperbac-oracle-linux -i Hyperbac for PRODUCTION PLATFORMS END-USER LICENSE AGREEMENT THIS IS A CONTRACT, PLEASE READ IT CAREFULLY, BY INSTALLING THIS SOFTWARE YOU ACCEPT ALL THE TERMS AND CONDITIONS OF THIS AGREEMENT, YOU WILL NOT BE ABLE TO USE THIS SOFTWARE UNLESS YOU ACCEPT THIS AGREEMENT. BY USING THE SOFTWARE, YOU ARE AGREEING TO BE BOUND BY THE TERMS OF THIS LICENSE. IF YOU DO NOT AGREE TO ANY TERM OR CONDITION, YOU MAY NOT INSTALL OR RUN THIS SOFTWARE. ... ... (remainder of licensing not shown for sake of brevity) ... 2005 Xceleon Technologies. All Rights Reserved. If you agree to the license agreement press 'Y' or 'N' to end the installation: Yes IMPORTANT: Product licensing message: HyperBac has 30 evaluation days remaining. At the end of the evaluation period the product will stop functioning. To obtain a license file contact www.hyperbac.com with the system key: <systemkey obscured>, or directly with the link: http://www.hyperbac.com/obtainlicense.asp?systemkey=<systemkey obscured > Press (N)ext to continue... N Installing hyperbac service files...OK Before configuring the service to start at boot time, it is recommended that you start the service now to ensure that is is configured correctly. Start service now (Y/N): Yes Starting hyperbac: [ OK ] Auto start service (Y/N): Yes Congratulations on successfully installing HyperBac, for information on configuring and using the HyperBac product, please refer to the 'Getting Started Guide for HyperBac'. This document is located at: file:///etc/hyperbac/doc/GettingStarted.html
I used the default configuration for HyperBac for Oracle as defined by HyperBacs configuration file, aptly named hyperbac.conf, thats stored in the /etc/hyperbac directory. Heres an example of its contents:
IncludeList=*;[20,0]|*.hbc;[20,0]+*;[20,0]|*.hbe;[20,26128] IndexPath=indexes KeyPath=keys IndexPath=indexes LicencePath=license/hyperbac.lic LogPath=logs DebugFlags=1
The most important parameter in this configuration file is the one named IncludeList. It defines the file extensions that HyperBac will perform its operations against, as well as the operation scope either simply compression, or both compression and encryption which it will perform to any files that match the listed filename expressions listed. In this default configuration, for example, HyperBac for Oracle will apply its compression capability against any file that has a file extension of hbc, and it will apply its combined compression and encryption capability against any file that has an extension of hbe. (See Appendix C of the Getting Started with HyperBac for Linux Systems guide for excellent documentation of the parameters that can be specified in hyperbac.conf.)
Compressing RMAN Backup Sets with HyperBac
HyperBac can compress the files that comprise an Oracle Database 10g RMAN backup set while the backup set is being created, and it makes no difference if its a normal backup set or a compressed backup set. Ive preserved the results of both RMAN operations in Listing 4 and Listing 5, respectively, and Table 1 below shows the relative savings obtained by using HyperBac to compress both types of backup files:
Compressing RMAN Image Copy Backups with HyperBac
Even more impressive, HyperBac can compress the files that are created during an RMAN image copy backup operation while the image copy files are being created. I used the code shown in Listing 6 to create an image copy backup of the seed database while routing the resulting backup files through the HyperBac filtering mechanism. Table 2 illustrates the relative space savings an average of better than 85% - when compared to a standard RMAN image copy of the same datafiles:
Encrypting RMAN Backup Sets with HyperBac
HyperBac can also simultaneously compress and encrypt RMAN backup sets with virtually no modification of the existing RMAN script that creates the backup files. The only change required is the addition of a FORMAT directive within the backup script so that the file extension for each backup file created matches one of those named in the HyperBac configuration file.
To illustrate, I used the RMAN backup script shown in Listing 7 to create a full database backup of my target Oracle database, producing a normal RMAN backup set. Note that the only modification was the addition of a FORMAT directive that names each image copy backup file so that its extension is .hbe. The resulting statistics for the creation of this backup set is shown in Table 3 below. While the encrypted backup took no less time to create using HyperBac in this scenario, it did actually result in a smaller backup set footprint as well:
Encrypting RMAN Image Copy Backups with HyperBac
HyperBac can also simultaneously compress and encrypt RMAN image copy backups while they are created during an image copy backup operation. To illustrate, I used the RMAN backup script shown in Listing 8 to create an image copy backup of all datafiles in my target Oracle database. Again, the only modification to my original image copy backup script was a FORMAT directive that names each image copy backup file so that its extension is .hbe. The resulting statistics for backing up the databases datafiles are shown in Table 4 below. Note the significant reduction in size of the backup files, both individually and cumulatively:
To prove that RMAN can still restore and recover database components from a backup set or image copy that was produced with the help of HyperBac, I destroyed the datafile for my databases EXAMPLE tablespace and then restored and recovered the tablespace. Listing 9 shows the successful results of this test.
Compressing and Encrypting DataPump Exports with HyperBac
The final HyperBac features Ill review involve its ability to create either compressed or compressed and encrypted DataPump Export dumpsets. While its possible to create an encrypted DataPump export in Oracle 10gR2, this capability again requires the licensing of Oracle Advanced Security features, while HyperBac requires no additional Oracle licensing to enable its capabilities.
As shown in Listing 10, I created a DataPump Export dump set that comprised the entire contents of the standard seed database, and I used the results from this operation as a baseline for comparison to DataPump Export operations I performed in concert with HyperBac.
I then created a compressed DataPump Export dump set and an encrypted DataPump dump set as shown in Listing 11 and Listing 12, respectively. Table 5 shows the end results: a 75% reduction in the size of the resulting dump sets, and a 45% reduction in the amount of time it took to create the files:
And to verify that these DataPump dump sets were viable, I re-imported just one table from the SH schema (SH.PRODUCTS) into the HR schema (as HR.PRODUCTS) by using the REMAP_SCHEMA directive during the DataPump Import. As shown in Listing 13 I used the encrypted DataPump Export created in Listing 9 as the target for the DataPump import operation.
HyperBac for Oracle offers excellent solutions for compression and encryption of Oracle RMAN backup sets, RMAN image copy backup files, DataPump Export dump sets, and Export files. It is simple to install, configure and customize for immediate use in concert with any Oracle 10g database. HyperBac for Oracle can be downloaded for a 30-day trial from the HyperBac web site at http://www.hyperbac.com/
References and Additional Reading
Even though Ive hopefully provided enough technical information in this article to encourage you to explore with these features, I also strongly suggest that you first review the corresponding detailed Oracle documentation before proceeding with any experiments. Actual implementation of these features should commence only after a crystal-clear understanding exists. The following Oracle 10gR2 documentation is extremely useful for understanding the deeper technical details of this article, especially the backup, restore, and recovery capabilities of Oracle 10gR2 Recovery Manager (RMAN) and the export and import capabilities of Oracle DataPump:
B14191-02 Oracle Backup and Recovery Advanced Users Guide
B14192-03 Oracle Backup and Recovery Basics
B14193-03 Oracle Backup and Recovery Quick Start Guide
B14194-03 Oracle Backup and Recovery Reference
B14215-01 Oracle Utilities