• No results found

ORACLE BACKUP SOFTWARE SOLUTIONS

N/A
N/A
Protected

Academic year: 2021

Share "ORACLE BACKUP SOFTWARE SOLUTIONS"

Copied!
37
0
0

Full text

(1)

www.dcig.com ORACLE BACKUP

BUYER’S

GUIDE

SO FTW ARE SOLUTION S

2011

ORACLE BACKUP

SOFTWARE

SOLUTIONS

BUYER’S GUIDE

The Insider’s Guide to Evaluating

Oracle Backup Software Solutions

By Will Boudreau, Carl Rubin and Jerome Wendt

(2)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Table of Contents

1

Introduction

4

Executive Summary

6 How to Use this Oracle Backup

Software Solutions Buyer’s Guide

6 Disclosures

7 The Seven-Step Process Used to

Score and Rank the Oracle Backup

Software Solutions

7 Observations and Recommendations

Regarding Each Backup

Software Ranking

9 Recommended and/or Best-in-Class 9 Excellent

9 Good 10 Basic

11

Oracle Backup

Software Solutions

Scores and Rankings

12 Overall

13 Oracle Integration

14

Oracle Backup Software Solutions

Buyer's Guide Data Sheets

15 Arkeia Network Backup 9 16 Asigra Cloud Backup™

17 Atempo Time Navigator 4.2 SP6 Oracle Module 18 CA ARCserve r15 19 Commvault® Simpana® 9 20 EMC Avamar 6.0 21 EMC Networker 7.6 SP2 22 HP Data Protector 6.2

23 Innovation FDR/UPSTREAM client and UPSTREAM Reservoir client v 3.6.3 24 NetApp Syncsort Integrated Backup 25 Quest Software NetVault Backup 8.5.3 26 Quest Software LiteSpeed® Engine

for Oracle 2.1

Appendix

A Definitions, Explanations and Terminology

B Oracle Backup Software Provider Contact Information C Author Contact Information

(3)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Introduction

This DCIG 2011 Oracle Backup Software Solution Buyer’s Guide is the latest in the ongoing series of Buyer’s Guides that DCIG began producing in 2010. Unlike other Buyer’s Guides that only look at factors that influence buying decisions of a particular and/or a limited number of products, DCIG Buyer’s Guides take a comprehensive look at products in a particular market segment. DCIG then weights and scores the products in that space and publishes the results without bias.

Like every other Buyer’s Guide that DCIG has produced, the Oracle Backup Software Solutions Buyer’s Guide was produced without any vendor sponsorship. Vendors of the products covered in this Buyer’s Guide are only given the opportunity to license and market the final results once DCIG’s research is complete.

This particular Buyer’s Guide is collaboration between Jerome Wendt of DCIG, LLC, (DCIG) and Carl Rubin and Will Boudreau of Monument Data Solutions LLC (Monument). Our intent in producing this Buyer’s Guide is to provide a resource for vendors, end-users, and others that establish the landscape for Oracle Backup Software Solutions and the important features and functions that the vendors of this technology are offering.

This Buyer’s Guide is intended as a complement to the evaluation and buying process that compa-nies must normally undertake themselves. It provides a comprehensive handbook to help them shorten the time and reduce the effort needed to evaluate Oracle Backup Software Solutions. One of the goals of this and every DCIG Buyer’s Guide is to accelerate the evaluation process for the end-user. Jerome’s extensive experience and research into a variety of data storage and data protection technologies coupled with Carl and Will’s years of experience managing and support-ing Oracle databases and backups collectively convinced us that there was a dearth of informa-tion about which backup soluinforma-tions were best suited to backup and recover Oracle databases. As such, it was determined that a DCIG Buyer’s Guide that identified and positioned the land-scape would be of tremendous value to vendors, end-users, and others. Using it they could quickly and easily approach this space and, with much less upfront research, discovery, and analysis, more confidently arrive at an insightful, informed conclusion as to how to best proceed. Putting together this Oracle Backup Software Solution Buyer’s Guide validated our belief that the discovery and evaluation of products in this space is both arduous and resource-intensive. In a segment as complex as backing up Oracle databases, just identifying the vendors that offer specialized products in this space can be challenging.

Short-listing which features matter in each product and weighting each one is even more difficult, especially for companies and/or individuals that are new to backing up Oracle databases. They many times are not aware of the breadth of products and features in this space and may not have the time to do the initial research and then an exhaustive evaluation of available solutions.

Our Methodology

In preparing this Buyer’s Guide, DCIG and Monument identified over 30 vendors who were potentially candidates for inclusion and sent them surveys to complete. However what we found was that a number of vendors that organizations may normally associate with Oracle backup (IBM, Symantec and others) declined to complete the survey associated with this particular Buyer’s Guide.

(4)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Introduction

continued

The reason they most often cited for not participating is that their backup software does not offer the advanced integration to backup Oracle databases that the majority of the products found in this Buyer’s Guide provide. Other backup software products that are specifically targeted at virtual backup also declined to participate because Oracle does not certify the backup of Oracle databases on virtual server platforms other than the one Oracle resells. Responses such as these further helped to exemplify why a Buyer’s Guide like this one was needed. The vendors that were included in this Buyer’s Guide completed a questionnaire that contained more than 60 yes/no and multiple choice questions. The survey included questions in the areas of Database Technology, Database Versions, Backup, Restore, Oracle RMAN, and Support.

Once DCIG received back the completed surveys, DCIG and Monument tabulated and assembled all of the responses. As part of our process, we also spoke to end-users to get a sense of what their specific needs were in these various areas as well as how they prioritized and weighted specific features.

Monument then took the lead in assessing the vendors’ capabilities indicated in the question-naire using vendor submitted information as well as information available in the public domain. Vendors’ capabilities were then evaluated by applying weighting based on our conversations with end-users as well as our own expertise and understanding of where the Oracle backup and recovery market is headed.

After we compiled all of the scores, we then assessed what constituted a “Best-in-Class” and/or “Recommended” solution, an “Excellent” solution, a “Good” solution, and which solu-tions provided more “Basic” functionality.

Each vendor in this Buyer’s Guide has something to offer in the right scenario and applica-tion. “Best-in-Class,” “Recommended,” “Excellent,” “Good,” and “Basic” are a measure of how much functionality and capability each solution has relative to the overall landscape—not whether the solution is the right and appropriate fit for any particular end-user’s needs. This Buyer’s Guide will therefore NOT tell you which solution is necessarily best for your environment. Only YOU can make that decision. Rather, it removes the heavy lifting that you would otherwise have to do to understand the vendor landscape and the features and functions to focus on.

This Oracle Backup Software Solutions Buyer’s Guide: • Lists each individual Oracle Backup Software Solution • Lists different Oracle backup software features

• Weights these features according to what end users consider most important • Scores and ranks the features on each product based upon the criteria that

matters most to users

• Provides an objective, third-party evaluation of Oracle backup software from an end-user’s viewpoint

(5)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

• Provides data sheets for 12 Oracle Backup Software Solutions to enable quick comparisons of the features that are supported or not supported by each backup software

• Further aligns the Oracle Backup Software Solutions by functionality to help you determine which vendors fit best with specific functionality needs • Provides contact information for each vendor to accelerate your ability to

contact the vendors.

• Provides recommendations on how to best use this Oracle Backup Software Solutions Buyer’s Guide

The end result is that this Buyer’s Guide gives users the opportunity to do “at-a-glance” comparisons between different Oracle Backup Software Solutions. Using these results, orga-nizations can quickly come up with a short list of products that meet their specific needs and either go directly to a product evaluation with select products or even opt to immediately get competitive bids on these products.

Note that this Buyer’s Guide is not intended to be a substitute for bringing individual products into your environment and testing them in-house with your applications. That function should still be done since these products may behave differently under different application work-loads and in different environments. However what this Buyer’s Guide will do is help you get to that buying decision and/or testing stage more quickly.

We hope this Buyer’s Guide meets this intended purpose in your environment.

Carl, Will and Jerome

(6)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

As more organizations have chosen Oracle databases, the need for an efficient, effective, and reliable backup solution is critical as this marketplace is changing in two ways. First, larger orga-nizations are increasing the number and size of instances; and, second, smaller orgaorga-nizations with limited IT staff are now purchasing Oracle databases.

Another big change is the number of organizations that have instituted and/or are looking to institute failover and disaster recovery for their business critical systems is on the rise. As the cost of hardware continues to decline and backup software continues to offer more options to do advanced forms of recovery, it is becoming both more affordable and practical for any size business to achieve this objective.

Oracle databases and the applications that rely upon these databases are at the top of the list for most organizations in terms of putting in place solutions that provide failover and recovery. These are most often business critical applications that have the least amount of tolerance for downtime and the highest demand for fast, reliable recoveries.

Of course, the key to executing on these ideals is to first successfully backup your Oracle data-bases and then have a methodology in place to either reload this Oracle database in its existing location or another site to continue business operations.

The difficulty then becomes choosing the right solution to deliver on these tasks. In addition to the time it takes to compare and review different products, each organization has its own particular backup and recovery requirements that it often needs to first define and understand before it can select the correct solution and then properly install so they can backup and recover a single specific Oracle database instance or multiple types of Oracle instances.

The challenge associated with protecting Oracle databases has been growing and becoming especially acute in the mid-market. Monument has found in its practice a growing number of smaller firms are utilizing Oracle databases as a result of their purchases of business applica-tions that run on Oracle databases beneath the covers.

So they are not choosing Oracle per se. Instead they now need to protect Oracle databases as a result of bringing a specific business application in house. This puts the onus on IT depart-ment to protect Oracle databases as part of their other duties.

Both DCIG and Monument have for some time been watching these trends and hearing from end-users that some guidance is needed on the Oracle Backup Software landscape. In fact, since DCIG announced on its website in the form of a blog entry that it was producing a Buyer’s Guide on Oracle Backup Software Solutions, it has become one of the most viewed entries on DCIG’s website. This combination of factors has resulted in the decision to produce this initial Buyer’s Guide on Oracle Backup Software Solutions.

This Buyer’s Guide is the result of a multi-month effort talking to multiple vendors about their solutions and then developing a survey with over 60 different yes/no and multiple choice ques-tions that covered a broad range of features and functionality as it relates to Oracle backup.

(7)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

The goal of this Buyer’s Guide is to:

• Identify the main features and functions of Oracle Backup Software Solutions • Provide a ranking of the vendors across two major categories

• Present insight to help end-users perform thorough evaluations.

• Impart expertise by weighting the questions to help organizations wade through the features and functions to understand which are more important than others

This Buyer’s Guide cannot tell you the “right” solution for your environment. Rather this Oracle Backup Software Solutions Buyer’s Guide will help you focus your attention more quickly in the right areas, identify important features to evaluate, ask the right questions, accelerate your evaluation, strategy, and decision-making, and then provide you with a reference and audit trail to justify your conclusions.

(8)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

How to Use this Oracle Backup

Software Solutions Buyer’s Guide

This Buyer’s Guide should help you initiate an evaluation of backup software for your Oracle databases and create a short list of vendors to consider.

“Best-in-Class” and/or “Recommended,” “Excellent,” “Good,” and “Basic” are a measure of how much function-ality and capability each solution has relative to the overall landscape—not whether the solution is the right and appro-priate fit for any particular’s end-user’s needs.

This Oracle Backup Software Solutions Buyer’s Guide will therefore not tell you which solutions to eliminate. Instead the intent of this Buyer’s Guide is to take the place of the heavy lifting that organizations normally need to do to understand the vendor landscape and the features and functions that each Oracle backup software solution has to offer.

This Buyer’s Guide ranks the products from more complete functionality to lesser amounts of functionality. This does not therefore tell you which functionality, which features, or what amount of functionality is the best fit for your envi-ronment. You should instead use this Buyer’s Guide as a handbook in evaluating Oracle Backup Software Solutions to understand:

• Who the players are

• What features and functions are available • The specific features and functions available on

each product

• Which specific features and functions to focus on. This Oracle Backup Software Solutions Buyer’s Guide should help you in the following five ways:

1. Accelerate your ability to assess the Oracle database backup software market place. 2. More quickly develop a “short-list” of backup

software vendors that are a good fit for your environment.

3. Use the Oracle Backup Software Solution Buyer’s Guide as a complement and “audit trail” in your evaluation process.

DCIG and Monument have already gone through a rigorous process of first scoring the products and then ranking them as “Best-in-Class,” “Recommended,” “Excellent,” “Good” and “Basic.” This provides a solid starting point when doing a comparative analysis of the different features and functions that each product provides as this Buyer’s Guide includes standardized data sheets for each Oracle Backup Software Solution. Because each Oracle Backup Software Solution looks

different and contains different features and functions, it is difficult to make side-by-side comparisons. This Buyer’s Guide tackles this problem by creating a standard, easy to read reference data sheet for every Oracle Backup Software Solution. In this way, product data sheets for individual products can be printed out, laid down side by side and then the features on them quickly compared.

4. This Buyer’s Guide normalizes complex Oracle Database backup terminology.

Every industry has a proclivity to adopt acronyms and jargon that is specific to it and the Oracle database market is no different in that it not only uses unfamiliar terms but sometimes refers to the same technology in different ways which complicates any attempts to do an objective evaluation of a technology. This Buyer’s Guide attempts to explain and normalize the jargon specific to Oracle backup while seeking to enhance the quality and productivity of the discussions around the technology.

5. Provides a concise summary of each vendor’s strengths and weaknesses around the major categories of this report.

Disclosures

The general trend in the U.S. over the last few years has been, for better or for worse, for both large and boutique analyst firms to receive some or all of their revenue from software providers.

DCIG is no different in this respect in that DCIG receives payment for the different services it performs for storage providers. The sponsored services that DCIG provides include blogging, case studies, product reviews, executive white papers, special reports and full-length white papers. For more information on DCIG, visit www.dcig.com.

(9)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

In the interest of being fully transparent, a number of the storage providers included in this Oracle Backup Software Solutions Buyer’s Guide are or have been DCIG clients. No vendors, however, whether clients or not, have been afforded preferential treatment in this Buyer’s Guide. The client relationship means that we have more complete and better knowledge of a specific vendor’s products and solutions, and that DCIG would consider their Oracle Backup Software Solution for inclusion in this Buyer’s Guide. In that vein, there are a number of important facts to keep in mind when considering the information contained in this Oracle Backup Software Solutions Buyers Guide and its merit.

• No storage provider paid DCIG or Monument any fee(s) to develop this Buyer’s Guide.

• Neither DCIG nor Monument provided any guarantee to a Oracle Backup Software vendor that their solution would be included in this Buyer’s Guide.

• Neither DCIG nor Monument provided any guarantee or assurance to any vendor about how their solution might be scored in this Buyer’s Guide.

• All research was based upon information provided directly by the vendor, research and analysis by DCIG and Monument, and other publicly available information. • Monument is an independent software consultancy,

working in partnership with DCIG, with no financial or contractual relationship to any of the vendors covered in this Buyer’s Guide. For more information on Monument, visit www.monumentdata.com.

The Seven-Step Process Used to Score

and Rank Oracle Backup Software

To score and rank each Oracle Backup Software Solution, DCIG and Monument went through a seven step process to come to the most objective conclusion possible.

1. DCIG and Monument identified the pertinent features available in backup software solutions for the backup and recovery of Oracle databases.

2. DCIG and Monument assessed which features could and should be part of a questionnaire to which vendors would respond. One distinction between a Request for Proposal (RFP) and the Oracle Backup Software

Solutions questionnaire is that we wanted to identify specific differences that are necessary versus those that are “nice to have.” These differences would identify features that would influence a buyer’s decision. 3. A questionnaire was sent to each vendor asking about

its Oracle database support for specific backup software features and functions.

4. Each question was assigned a weighting based on our conversations with end-users as well as our own experience and understanding of industry trends. 5. Upon compilation of the vendors’ capabilities against

each item in the questionnaire, we looked at each and every vendor capability and scored their capabilities. 6. Scores for each question were then normalized, and

summed up as a “Total Score.”

7. The features were broken down into two main categories, “General Oracle Backup” and “Oracle Integration”, with the scores of each shown on each product’s data sheets. The “Total Score” on each data sheet is the sum of the scores of the two categories displayed on each data sheet.

DCIG Observations and

Recommendations Regarding

Each Backup Software Ranking

Observations

The rankings were based upon what key features and functions that would be needed the most by users of these products.

For example, we felt that the ability to perform a Bare Metal Restore was critical and we gave this particular feature a high rating. A Bare Metal Restore is the capability to restore a system on a new server if the original server has completely failed and is usually a basic tenet of a reliable Disaster Recovery plan.

Conversely, support for legacy Oracle databases that are no longer formally supported by Oracle (identified as 7.x, 8.0.x, 8i, and 9i on the data sheets) we rated as less impor-tant. So while the product’s support of these legacy data-bases is displayed on the data sheets, we did not assign weightings for these features since most organizations are

(10)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

not using unsupported versions of Oracle. However, having them listed in the data sheets will help those that still do have these requirements and may need this information when comparing the products from different vendors. Overall, we determined the following features were deserving of higher rankings and were scored and weighted accordingly:

Oracle RMAN and Data Guard

Oracle’s RMAN is becoming a standard for backing up Oracle Databases. However, a majority of organizations still do not use RMAN. Oracle is pushing the marketplace to utilize this process and we feel in the future it may be used more often. A large number of questions on this survey are related to RMAN but if RMAN is not a requirement for your organization, it should be recognized and duly noted in your evaluation process of an Oracle backup software solution. Other chief RMAN features are the capability to:

• Use the RMAN VALIDATE command without scripting. This is important since this does not require a read of the backup to ensure the backup is running properly. • Natively make use of RMAN backup and recovery

commands (no scripting required)

• Determine the appropriate type of recovery by perform-ing such tasks as checkperform-ing for data files, control files, archive logs, etc. that are needed to recover a database without using RMAN

Oracle’s Data Guard product is also becoming more popu-lar for use in maintaining Disaster Recovery (DR) systems. We rated backup software highly which maintained, supported, or generated notifications if Data Guard failures occurs. Once a Data Guard database has been setup and updated with log files from the primary database, it is very difficult to resync the two systems if they get out of sync, so knowing about failures is important.

Oracle RAC

Oracle’s Real Application Clusters (RAC) is a clustered database with a shared cache architecture that delivers highly available database solutions. Oracle RAC usually has a primary and secondary database to provide a higher level of system uptime. If the primary database fails, the second-ary database automatically comes online.

If you are using Oracle RAC in your environment, it is criti-cal that your Oracle Backup Software Solution is aware of RAC, can detect if there is a node failure and can continue to perform backups after such a failure occurs. Those systems that were aware of Oracle RAC and had features that supported Oracle RAC functionality were given a higher rating than those that did not.

Other Oracle Backup Types

Other Oracle backup types that we also rated highly were: • Secure Backup, which entails some type of encryption. • Cold/offline Backup

• Hot/online Backup • Disk Image Backup

Backup Media

Since the backup media world is changing, we rated the ability to perform all different types of backup media as very important. The types of media that can be used by the backup software are:

• Cloud storage (public) • Disk (NAS or SAN) • Tape

• Virtual Tape Library (VTL)

The difference between disk (either NAS or SAN) and a VTL (virtual tape library) is that a VTL looks like a physical tape library from the perspective of the backup software. This ability of backup software to leverage disk in lieu of tape we view as paramount as the industry is rapidly moving away from using tape as the primary backup and restore target and instead using disk in one of its various iterations (Cloud storage, NAS, SAN or VTL.)

The role of tape in many organizations is primarily evolving to that of a secondary backup target in the form of disk-to-disk-to-tape (D2D2T) or to archive data.

Cloud storage is also rapidly coming on the scene as a potential backup target but for now DCIG and Monument recommend that if it is used, it is used primarily in the same way that tape is used —in the form of disk-to-disk-to-cloud (D2D2C). The main concern is the internet bandwidth that

(11)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

is required to do backups and restores to and from the Cloud. So it is only practical for most companies to use Cloud storage as a secondary backup target or for archive similar to how tape is being increasingly used.

However, it should be noted that the ability to use a Cloud storage minimizes the issues with moving data off-site and opens up new possibilities for DR purposes which tape by itself does not do.

There are different ways to backup an Oracle database. The traditional ways of doing Oracle backups—Cold, Hot (Full), and Hot (Incremental)—are requirements for most environ-ments since they use a combination of these. Most organi-zations will schedule a cold backup at least once a month and use the Hot (Full) backups for their daily backups. However, with the size of some databases, the ability to do a Hot (Incremental) is very helpful from a backup window standpoint. Again, all of these features and needs depend of database size, backup windows, organizational needs, and potential for failure.

Backup Reporting

A new area that backup software vendors have begun to embrace is running audit reports on database backup successes and failures. This eliminates the need for organizations to write programs that monitor these backup software alerts or reading their log files.

“Best-in-Class” and

“Recommended” Rankings

Observations

This Buyer’s Guide measured the rankings by breadth and depth of capability. There are few vendors that have broad and deep enough functionality to be deemed as

“Recommended” or “Best-in-Class”—the product with the top score in each category—as defined in this Buyer’s Guide as vendors with scores of 70 or higher.

• DCIG classifies the “Recommended” Oracle Backup Software Solutions with the top scores.

• CommVault Simpana and Quest Software NetVault Backup received this honor for their strong breadth of Oracle Backup Support and overall Oracle integration.

Quest Software NetVault Backup achieved the “Best-in-Class” designation in Total Product Score and the Oracle Integration category though the two products by and large ranked fairly consistently across the board. • What ended up giving Quest Software NetVault Backup

a slight edge was its more advanced Oracle integration with RMAN, Data Guard, and RAC.

“Excellent” Ranking

Observations

Vendors ranked as “Excellent” scored from 60 to 69. Two vendors, EMC NetWorker 7.6 and HP Data Protector 6.2, ranked as “Excellent” overall.

The main shortcomings of these two solutions were that they did not score well on the non-RMAN features. If RMAN is not a requirement for your organization, then these two solutions are very similar to the “Recommended” solu-tions as they both handled key requirements for backing up and restoring Oracle databases as well as RAC, Data Guard, and RMAN integration.

“Good” Ranking

Observations

Vendors ranked as “Good” scored from 48 to 59 with four vendors, Asigra Cloud Backup, Arkeia Network Backup 9, Atempo Time Navigator 4.2 SP6 and CA ARCserve r15 achieving a ranking of “Good.”

The difference between these vendors and the higher rated vendors is that they have not embraced a number of Oracle centric backup and restores feature with a prime example being that they cannot handle backups in a Data Guard environment which would clearly be important if you use Data Guard.

However there are some features on these products worth pointing out. Asigra Cloud Backup has the ability to run audit reports on successful or failed backups which lets the user know about the status of their backups after they are complete. What makes Atempo Time Navigator

(12)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

noteworthy is that it makes use of the RMAN VALIDATE command whereas other competitive products in this ranking do not.

“Basic” Ranking

Observations

Vendors ranked as “Basic” scored under 48. These included EMC Avamar, Innovation FDR/UPSTREAM, NetApp Syncsort Integrated Backup and Quest Software LiteSpeed for Oracle. These solutions can backup and restore your Oracle databases and are intended for use in Oracle environments where the requirements are for simpler Oracle backup and recoveries.

If you do not need these more advanced Oracle backup features, these products may be suitable for your environ-ment. Further, each vendor is continually enhancing its software with more features so that in the future a product in this ranking may be sufficient for a particular organiza-tion’s needs.

(13)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

ORACLE BACKUP SOFTWARE

SOLUTIONS BUYER’S GUIDE

SCORES AND RANKINGS

The scores and rankings for the Oracle Backup

Software Solutions contain the following information:

• A chart that includes the scores and rankings

for all of the products

• The highest score, lowest score and mean that

were used to establish how each Oracle Backup

Software Solution was ranked

(14)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Overall Scores and Rankings

Oracle Backup Software Solutions SCORE RANKING

1 Quest Software NetVault Backup 8.5.3 76.2 Best-in-Class

2 CommVault Simpana 9 73.9 Recommended 3 EMC NetWorker 7.6 SP2 67.0 Excellent 4 HP Data Protector 6.2 60.5 Excellent 5 Asigra Cloud Backup 55.0 Good

6 CA ARCserve r15 54.4 Good

7 Atempo Time Navigator 4.2 SP6 Oracle Module 54.1 Good 8 Arkeia Network Backup 9 49.2 Good 9 NetApp Syncsort Integrated Backup 44.4 Basic 10 Quest Software LiteSpeed Engine for Oracle 2.1 39.1 Basic 11 Innovation FDR/UPSTREAM 38.1 Basic

12 EMC Avamar 6.0 30.5 Basic

Highest Score 76.2 Lowest Score 30.5 Average (Mean) 53.9 Standard Deviation 2.7 Rankings Recommended 70.0 – 76.2 Excellent 60.0 – 69.9 Good 48.0 – 59.9 Basic 30.5 – 47.9

(15)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Oracle Integration Scores and Rankings

Oracle Backup Software Solutions SCORE

1 Quest Software NetVault Backup 8.5.3 20.4 Best-in-Class

2 CA ARCserve r15 18.7 Recommended 3 CommVault Simpana 9 16.2 Excellent 4 Quest Software LiteSpeed Engine for Oracle 2.1 13.8 Excellent 5 Arkeia Network Backup 9 12.8 Excellent 6 Atempo Time Navigator 4.2 SP6 Oracle Module 11.1 Good 7 EMC NetWorker 7.6 SP2 10.3 Good 8 HP Data Protector 6.2 9.0 Good 9 Asigra Cloud Backup 8.8 Good

10 EMC Avamar 6.0 5.9 Basic

11 NetApp Syncsort Integrated Backup 5.5 Basic 12 Innovation FDR/UPSTREAM 5.4 Basic

Highest Score 20.4 Lowest Score 5.4 Average (Mean) 11.8 Standard Deviation 3.3 Rankings Recommended 17.0 – 20.4 Excellent 12.0 – 16.9 Good 8.0 – 11.9 Basic 5.4 – 7.9

(16)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

ORACLE BACKUP SOFTWARE

SOLUTIONS BUYER’S GUIDE

DATA SHEETS

(17)

DETECT ORACLE RAC NODE FAILURES AND STILL BACKUP

DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS MEDIA TYPES DISK TAPE VTL CLOUD

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR DBVERIFY EXPORT IMPORT DATA PUMP

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY FAST RECOVERY AREA

ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

Arkeia Network Backup 9

49.2

Total Score

36.4

General Oracle Backup

12.8

Oracle Integration

(18)

DBVERIFY EXPORT IMPORT DATA PUMP

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY

ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE

ENCRYPTION

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

FAST RECOVERY AREA ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

Asigra Cloud Backup

55.0

Total Score

46.2

General Oracle Backup

8.8

Oracle Integration

(19)

DBVERIFY EXPORT IMPORT DATA PUMP MEDIA TYPES DISK TAPE VTL CLOUD

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY FAST RECOVERY AREA

ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

Atempo Time Navigator

4.2 SP6 Oracle Module

54.1

Total Score

43.0

General Oracle Backup

11.1

Oracle Integration

(20)

DBVERIFY EXPORT IMPORT DATA PUMP

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION DETECT ORACLE RAC NODE FAILURES AND STILL BACKUP

DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY FAST RECOVERY AREA

ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

CA ARCserve r 15

54.4

Total Score

35.7

General Oracle Backup

18.7

Oracle Integration

(21)

MEDIA TYPES DISK TAPE VTL CLOUD ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY DBVERIFY

EXPORT IMPORT DATA PUMP

FAST RECOVERY AREA ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

Commvault

®

Simpana

®

9

73.9

Total Score

57.7

General Oracle Backup

16.2

Oracle Integration

(22)

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY DBVERIFY

EXPORT IMPORT DATA PUMP

FAST RECOVERY AREA ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

EMC Avamar 6.0

30.5

Total Score

24.6

General Oracle Backup

5.9

Oracle Integration

(23)

DBVERIFY EXPORT IMPORT DATA PUMP MEDIA TYPES DISK TAPE VTL CLOUD ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY FAST RECOVERY AREA

ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

EMC Networker 7.6 SP2

67.0

Total Score

56.7

General Oracle Backup

10.3

Oracle Integration

(24)

ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE

ENCRYPTION

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY DBVERIFY

EXPORT IMPORT DATA PUMP

FAST RECOVERY AREA ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

HP Data Protector 6.2

60.5

Total Score

51.5

General Oracle Backup

9.0

Oracle Integration

(25)

DBVERIFY EXPORT IMPORT DATA PUMP

DETECT ORACLE RAC NODE FAILURES AND STILL BACKUP

DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES

ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE

ENCRYPTION

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD DEDUPLICATION REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY FAST RECOVERY AREA

ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

Innovation FDR/UPSTREAM client and

UPSTREAM Reservoir client v 3.6.3

38.1

Total Score

32.7

General Oracle Backup

5.4

Oracle Integration

(26)

DBVERIFY EXPORT IMPORT DATA PUMP

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION DETECT ORACLE RAC NODE FAILURES AND STILL BACKUP

DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY FAST RECOVERY AREA

ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

NetApp Syncsort Integrated Backup

44.4

Total Score

38.9

General Oracle Backup

5.5

Oracle Integration

(27)

DBVERIFY EXPORT IMPORT DATA PUMP

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE ENCRYPTION RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY FAST RECOVERY AREA

ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

Quest Software

NetVault Backup 8.5.3

76.2

Total Score

55.8

General Oracle Backup

20.4

Oracle Integration

(28)

ENCRYPTION OPTIONS RMAN ENCRYPTION BACKUP SOFTWARE

ENCRYPTION

DCIG Scores and Rankings

General Oracle Backup

ORACLE BACKUP BUYER’S GUIDE SO FTW ARE SOLUTION S Supported Unsupported

Backup Software Functionality

LEGACY DATABASE SUPPORT 7.X.X 8.0.X 8i 9i RMAN INTEGRATION APIS CLI COMMAND FILES DBMS_PIPE EXTERNAL SCRIPTS GUI SCRIPT EDITOR/GENERATOR MEDIA TYPES DISK TAPE VTL CLOUD DETECT ORACLE RAC NODE

FAILURES AND STILL BACKUP DATABASE BACKUP IN DATA GUARD ENVIRONMENT

ALERT CONFIGURATION (Email and/or SNMP) RMAN ORACLE FLASHBACK RECOVERY ORACLE FAST RECOVERY AUDIT REPORTS DIFFERENT ORACLE DBA SECURITY ROLES DEDUPLICATION

REPLICATION SNAPSHOTS CLONING BARE METAL RESTORE BACKUP SOFTWARE FEATURES

BLOCK CHANGE COLD/OFFLINE HOT/ONLINE DISK IMAGE FULL INCREMENTAL CUMULATIVE INCREMENTAL DIFFERENTIAL INCREMENTAL LAN-FREE RAW PARTITION SERVERLESS

NATIVE ORACLE BACKUP METHODS ORACLE COLD ORACLE HOT (Full) ORACLE HOT (Incremental) PARTIAL DATABASE BACKUPS HARDWARE BASED (RMAN supported) HARDWARE BASED (non-RMAN supported)

RMAN PROXY COPY DBVERIFY

EXPORT IMPORT DATA PUMP

FAST RECOVERY AREA ORACLE VM ORACLE CLOUD COMPUTING AUTOMATIC STORAGE MANAGEMENT (ASM) CROSS-PLATFORM TRANSPORTABLE TABLESPACE ORACLE INTEGRATION ORACLE RAC ORACLE CLUSTERWARE ORACLE DATA GUARD ORACLE GOLDENGATE ORACLE STREAMS ORACLE SECURE BACKUP FLASHBACK TECHNOLOGIES

Quest Software

LiteSpeed

®

Engine for Oracle 2.1

39.1

Total Score

25.3

General Oracle Backup

13.8

Oracle Integration

(29)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Product Rankings Dashboard

Arkeia Network Backup Best-in-Class Recommended Excellent Good Basic HP Data Protector 6.2 Asigra Cloud Backup

Best-in-Class Recommended Excellent Good Basic

Innovation FDR/UPSTREAM client and UPSTREAM Reservoir client v 3.6.3 Atempo Time Navigator 4.2 SP6

OracleModule Best-in-Class Recommended Excellent Good Basic

NetApp SyncSort Integrated Backup CA ARCserve r15 Best-in-Class Recommended Excellent Good Basic EMC Networker 7.6 SP2 Commvault Simpana 9 Best-in-Class Recommended Excellent Good Basic

Quest Software NetVault Backup 8.5.3

EMC Avamar 6.0 Best-in-Class Recommended Excellent Good Basic

Quest Software LiteSpeed Engine for Oracle 2.1

TOTAL

SCORE SCORETOTAL

GENERAL ORACLE BACKUP GENERAL ORACLE BACKUP ORACLE INTEGRATION ORACLE INTEGRATION

(30)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Appendix A—Definitions, Explanations and Terminology

Archive Log Mode

Using ARCHIVE Log Mode the archiving of the redo log is enabled. These logs are a record of all changes to the database since the last backup point. Archiving has these advantages: A database backup, together with online and archived redo log files, guarantees that you can recover all committed transactions in the event of an operating system or disk failure. If you keep an archived log, you can use a backup taken while the database is open and in normal system use. You can keep a standby database current with its original database by continuously applying the original archived redo logs to the standby.

Automatic Storage Management (ASM)

ASM simplifies administration of Oracle related files by allowing the administrator to reference disk groups rather than individual disks and files, which are managed by ASM. The ASM functionality is an extension of the Oracle Managed Files (OMF) functionality that also includes striping and mirroring to provide balanced and secure storage. The ASM functionality is controlled by an ASM instance. This is not a full database instance, just the memory structures.

Bare Metal Restore

Bare Metal Restore backs up data in a format that allows a database to be restored to a server from “bare metal”, i.e. with-out any requirements as to previously installed software or oper-ating system. This means that a new server without the same LUN or volume setup as the old server can do the restore. This feature is most helpful when there is a hardware failure as without a Bare Metal Restore, the LUNs or volumes must first match the original to successfully restore the database.

Block Change Backup

This feature records the modified blocks since the last backup and stores the log of it in a block change track-ing file. Durtrack-ing backups RMAN uses the log file to identify the specific blocks that must be backed up. This improves RMAN’s performance as it does not have to scan whole data files to detect changed blocks.

Definitions, Explanations and Terminology

This section contains brief definitions and/or explanations of some of the terms used and assumptions made when developing the data sheets found in this Oracle Backup Software Solution Buyer’s Guide.

CLI

A command-line interface (CLI) is a mechanism for inter-acting with a computer operating system or software by typing commands to perform specific tasks. This text-only interface contrasts with the use of a mouse pointer with a graphical user interface (GUI) to click on options, or menus on a text user interface to select options.

Compressed Backups

Compression reduces the amount of space needed by a backup. There are several ways of doing this. Some programs have support for compression built in. The gzip (-z) option for GNU tar pipes the whole backup through the gzip compression program before writing it to the backup medium. Unfortunately, compressed backups are problem-atic. Due to the nature of how compression works, if a single bit is wrong, all the rest of the compressed data will be unus-able. Some backup programs have some built in error correc-tion, but no method can handle a large number of errors. This means that if the backup is compressed the way GNU tar does it with the whole output compressed as a unit, a single error makes all the rest of the backup unusable.

Cross Platform Transportable Table space

When using RMAN, transporting table spaces between databases where the endian format is different between source and destination platforms, the endian format of the data files must be converted to match the destination plat-form. This conversion can be performed in two ways: Using the “RMAN CONVERT TABLESPACE” command (convert-ing on the source host) or us(convert-ing the “RMAN CONVERT DATAFILE” command (converting on the destination host).

Cumulative Incremental Backup

The backup software creates copies of all the files, or parts of files that have changed since previous backups of any type (full, differential or incremental) with each backup building on the previous backup. To restore the data, you will need the the last full backup and all the backups since that full backup.

(31)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Appendix A—Definitions, Explanations and Terminology

Data Pump

The Oracle Data Pump provides two utilities: Data Pump Export and Data Pump Import. This product replaces the pre-Oracle 10g import and export utilities (imp and exp). Data Pump Export (expdp) and Data Pump Import (impdp) are server-based rather than client-based as is the case for the original export (exp) and import (imp).

DBMS_PIPE

The DBMS_PIPE package lets two or more sessions in the same instance communicate. Oracle pipes are similar in concept to the pipes used in UNIX, but Oracle pipes are not implemented using the operating system pipe mecha-nisms. Information sent through Oracle pipes is buffered in the system global area (SGA).

DBVERIFY

DBVERIFY is an external command-line utility that performs a physical data structure integrity check on an offline data-base. It can be used against backup files and online files (or pieces of files). DBVERIFY is primarily used to ensure that a backup database (or data file) is valid before it is restored or as a diagnostic aid when a data corruption problem is encountered.

Deduplication

Deduplication is a specialized data compression technique for eliminating coarse-grained redundant data to improve storage utilization. There are various kinds of deduplication. Source-based deduplication means that you first dedupli-cate data and then backup the deduplidedupli-cated data. This is less taxing on the networking as less data is sent to the backup media. Using target-based deduplication, data is first backed up by sending all of the data over the network, and then deduplicating it at the backup target.

Differential Incremental Backup

The backup software looks at which files have changed since the last full backup and then creates copies of all the files that are different from the ones in the full backup. If more than one differential backup is done, it will copy all the files, or parts of files that have changed since the last full backup, even if you already have identical copies of those files in a previous differential backup. To restore all the data, only the last full backup and differential backups are needed.

Disk Image Backup

This is when a copy of the database is made to any type of storage device (tape, disk, or CD). All data is backed up includ-ing free blocks with no data which can make this method of backup very slow and result in a very large backup.

Duplexing Backup Sets

RMAN can write duplexed backup sets that create up to four identical copies of each backup piece in a backup set to different destinations. Duplexing provides an extra layer of protection against disaster, media damage and human error. RMAN can duplex backup to either disk or tape but cannot duplex to disk and tape at the same time. Backup duplexing is not applicable to disk image backups.

Fast Recovery Area

Fast Recovery Area minimizes the need to manually manage disk space for backup-related files and balance the use of space among the different types of files. In this way, a fast recovery area simplifies the ongoing administration of your database.

Full Backup

A complete backup of an entire database.

Hot Backup

A Hot Backup is performed while software accessing that database is running. Traditional or cold backups require systems to be taken offline before backups are done.

Legacy Oracle Database Versions

These are older releases of Oracle databases that are no longer formally supported by Oracle under normal mainte-nance and support contracts.

Non-Archive Log Mode

Using Non-Archive Log Mode the archiving of the redo log is not enabled. In this mode, offline redo logs can (and will) be overwritten without first making sure they are saved. If the database fails you may lose everything since the last backup.

Oracle Clusterware

Oracle Clusterware is the cluster software required to run the Real Application Clusters (RAC) option for the Oracle database. It provides the basic clustering services that enable Oracle software to run in clustering mode.

(32)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Appendix A—Definitions, Explanations and Terminology

Oracle Data Guard

Oracle Data Guard supports both physical standby and logi-cal standby databases. It can be setup to facilitate failovers or switchovers to alternative hosts in the same or alterna-tive locations. The most common use of this feature is for Disaster Recovery Databases which are located off-site.

Oracle Flashback Technologies

Oracle Flashback Technologies are data recovery solutions that enable reversing errors by selectively and efficiently undoing the effects of a mistake. Before Flashback, an incorrect transaction that only took seconds to create could take hours to reverse. Using Flashback correcting an error takes about as long to reverse as it took to make it. In addition, the time required to recover from this error is not dependent on the database size. Flashback supports recovery at all levels including the row, transaction, and table levels, as well as the entire database.

Oracle GoldenGate

GoldenGate enables real-time data integration and continu-ous data availability by capturing and delivering updates to continuous data synchronization across heterogeneous envi-ronments. The most common application is to gain improved business intelligence across the enterprise by using more accurate and timely data and increased performance. Other uses include query offloading; zero-downtime upgrades and migrations; disaster recovery; and active-active databases for data distribution, data synchronization and high availability.

Oracle RAC

Oracle Real Applications Clusters (RAC) is a cluster data-base with a shared cache architecture that provides a highly scalable and available database solution. In an Oracle RAC environment, an instance has more than one identical data-base. This allows an application or user to connect to the instance and have access to a single set of data. If one of the RAC nodes fails, the other node seamlessly continues to operate without any loss of data or use of the system.

Oracle Secure Backup

Oracle Secure Backup provides centralized tape backup management for an integrated, easy-to-use solution that encrypts data to tape to safeguard against the misuse of sensitive data in the event that backup tapes are lost or stolen.

Oracle Streams

Oracle Streams helps propagate information within and between databases. It provides tools to capture, process (‘stage’) and manage database events via Advanced Queuing queues. Oracle Streams can be setup in homogeneous (all Oracle data-bases) or heterogeneous (non-Oracle and Oracle datadata-bases) environments. It uses database objects to share data and messages. Applications for the Oracle Streams toolset include data distribution, data warehousing and data replication.

Oracle Virtualization (VM)

Oracle VM is server virtualization software that fully supports both Oracle and non-Oracle applications and delivers more efficient performance. Oracle VM has the following features: server clustering and server virtualization technologies, integrated clustering, virtualization, storage, and management for grid computing.

Raw Partition Backup

This is related to disk imaging and is when a copy is made of the Database for backup purposes. All data is backed up including free blocks with no data which can result in backups that are both very slow and very large.

RMAN

Oracle Recovery Manager (RMAN) is a tool that allows for efficiently backing up and recovering an Oracle database. RMAN is designed to provide block-level corruption detection during backup and restore. RMAN optimizes performance and space consumption during backup with file multiplexing and backup-set compression, and integrates with Oracle Secure Backup and third-party media-management products for tape backup. RMAN provides a common interface for backup tasks across different host operating-systems, parallelization of backup/recovery data streams, backup-files retention policy, and detailed history of all backups.

RMAN Data Recovery Advisor

RMAN Data Recovery Advisor automates the diagnosis of database failures and corruptions, advises the recovery steps and performs automatic recoveries of the database failure.

RMAN Recovery Catalog

An RMAN Recovery Catalog is a schema stored in a database that tracks backups and stores scripts for use in RMAN backup and recovery situations.

(33)

DCIG 2011 ORACLE BACKUP SOFTWARE SOLUTIONS BUYER’S GUIDE

The Insider’s Guide to Evaluating Oracle Backup Software Solutions

Appendix A—Definitions, Explanations and Terminology

VALIDATE

The VALIDATE command is used to check for corrupt blocks and missing files, or to determine whether a backup set can be restored. If VALIDATE detects a problem during validation, then RMAN displays it and triggers execution of a failure assessment. This gives the user a better idea if a backed up database is restorable.

VTL

A virtual tape library (VTL) is a data storage virtualization technology used for backup and recovery purposes. A VTL is usually a hard disk storage device which presents itself as a physical tape library to backup software.

References

Related documents

• Self-service Public PaaS based on Oracle VM, Oracle Enterprise Linux, Oracle Database RAC and Oracle WebLogic Server..

Oracle 11gR2 : Recover dropped tablespace using RMAN tablespace point in time recovery.. Mohamed Azar

Oracle Automatic Storage Management (ASM) is a volume manager and an Oracle specific file system that supports single instance Oracle Database and Oracle RAC configurations.. It

These factors include, but not limited to database server operating system, file system or Oracle ASM, volume management such as LVM or VxVM, Oracle RAC or non-RAC, backup and

 OpenStack integration with Oracle Solaris, Oracle Linux, Oracle VM, Oracle Virtual Compute Appliance, Oracle’s storage.  Oracle Infrastructure Cloud and Oracle Storage

Infrastructure products, including Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware.. You will also learn to administer the Oracle Clusterware

The role composition language that is used to obtain an integrated data model for all tools involved in an integration scenario, is an essential part of our approach.. For example,

RQ2: How does television and social media use influence migrant decision making to move to the West by Sub-Saharan Black African Students (SBAS).. RQ3: To what extent does

The Corporation administers two long-term incentive plans: (i) a long-term incentive plan adopted in 2011, as amended in 2013, 2014 and 2015 (the “ LTI Plan ”) under which Options

Renewable energy sources have the potential to provide enough primary energy or electricity to meet our national demand as shown in table 2.. However, the

Oracle Database Single LPAR with Oracle RAC Oracle RAC Node 1 Linux Guest 1 z/VM LPAR Application Server(s) Oracle Database Guards against :. •Linux OS or Oracle DB failure

Your target group is now created and the number of business partners contained in the target group will be displayed automatically in the staging area.. If you want to display

Successful completion of an approved Utah institution of higher education program for library media endorsement matching the seven requirements (see page 2) and successful passage

Because the complexity of operating systems has prevented them from being effective and manageable arbiters of security, separation kernels and virtual machine monitors are seen as

[ 16 ] ^ ¥ Stage (Duke's AB vs CD), Emergency admission Journal article Colorectal Population-based analysis of Scottish patients diagnosed in 1998 – 2011 National Cancer

In ad- dition, most protective mechanisms shaped by selection against cancer are costly and come with trade- offs (Hochberg, Thomas, Assenat, & Hibner, 2013); thus,

– Solutions stack: servers, storage, network, OS, Oracle VM, Oracle RAC, Oracle Applications..

• Planned Oracle VM VirtualBox workstations to support running Oracle VM Templates. Oracle

• Oracle Linux and Oracle VM powers Oracle’s infrastructure and cloud offerings. – 310,000+ Oracle

§  Cloud Integration using Oracle SOA to connect Oracle E- Business Suite with SalesForce.com. §  Oracle Coherence, Oracle WebLogic Oracle Identity

Oracle Clusterware was introduced with Oracle Database 10g Release 1 as the underlying clustering software required for running Oracle Real Application Clusters (RAC). As part of

Part of the Oracle Cloud Platform as a Service (PaaS) portfolio, Oracle Database Backup Service is a cloud-based storage solution for Oracle Database backups.. This cost