Protect and manage data for the intelligent enterprise

HPE RMC and HPE StoreOnce Catalyst Plug-ins for Oracle, SAP HANA, and Microsoft SQL Server

+ show more
TAP IMAGE TO ZOOM IN

Protect and manage data with HPE Recovery Manager Central and HPE StoreOnce Catalyst Plug-ins

Protecting and recovering database environments is becoming more challenging as a result of large and increasing data volumes, more complex business demands, and rising costs.

  • Enable fast and affordable end-to-end protection and copy data management for Oracle, SAP Hana, and SQL Server databases

    The database protection and copy data management challenge

    Organizations deploying large-scale Oracle, SAP HANA®, and Microsoft SQL Server databases struggle with protecting rapidly growing and changing mission-critical data.

    Some of the pain points in protecting databases include:

    • Backing up large databases with minimum complexity and within a short time frame
    • Keeping data protection costs under control
    • Maintaining a reasonably low recovery-time objective (RTO) and recovery-point objective (RPO) for an application in case of disasters or logical issues
    • Protecting databases hosted in heterogeneous storage environments involving primary storage, secondary storage, and cloud tiers

     

    On the SAP HANA platform, the database, data processing, and application platform capabilities are combined in a single in-memory platform and a persistent storage layer recovers data to the most recent committed state after a restart or power loss. However, protection against logical or user errors and catastrophic failures is not possible from the persistent storage layer alone.

     

    Array-based snapshots offer fast, nondisruptive point-in-time copies of data. But snapshots alone cannot deliver comprehensive backup. They have retention limitations, corruption vulnerabilities, and dependence on the underlying storage system. Moreover, snapshots are at risk if the storage system fails. Replication might protect against site loss, but it does not protect against viruses because they are replicated to the secondary site.

     

    Typically, backups require production database application resources for extended time periods, which might be disruptive to users. Backup and recovery of SAP HANA databases involve heavy reliance on scripts and slow performance. The Backint for SAP HANA interface supports third-party backup and recovery software, but a dedicated backup media server is necessary and backup scheduling can be complex.

     

    Enterprises and small businesses alike are relying more and more on multiple copies of their production database for IT functions beyond data protection. Tasks such as testing and development, analytics, report generation, and copies for application development purposes are common in every IT organization. Yet, managing the creation and use of these copies can become complex and costly to the point that it can negatively impact daily business operations.

     

    A faster, easier, and more efficient way to manage data copies is needed. Hewlett Packard Enterprise (HPE) can help provide an application-managed, storage-integrated data protection and copy data management offering.

  • The HPE solution

    HPE StoreOnce Catalyst Plug-ins are available free of charge for Oracle Recovery Manager (RMAN), SAP HANA, and SQL Server. These high-performance plug-ins provide database administrators (DBAs) with faster backup and recovery of databases. An alternative to traditional NAS and virtual tape library (VTL) backup modes, the plug-ins are installed directly on your database servers. They are also integrated with Oracle Enterprise Manager, SAP HANA Studio, or SQL Server Management Studio to initiate backup as well as restore operations and replicate data to a secondary target including the cloud.

    As a result, DBAs can back up their databases without the need for an additional backup application. The plug-ins also provide the option to deduplicate the database backup on the nodes, reducing the data flow through the network. Another option is to deduplicate on the target HPE StoreOnce appliance, reducing the deduplication load on the database application servers.

     

    Most importantly, HPE StoreOnce Catalyst makes it practically impossible for ransomware to attack database backup stores directly. It effectively isolates the data from traditional lines of communication and command sets leveraged by ransomware attackers.

     

    HPE Recovery Manager Central (RMC) offers a practical, efficient, and unified approach to copy data management and database protection so that backing up multiterabyte databases is possible within a short window. It provides a converged availability and backup service for Oracle, SAP HANA, and SQL Server to augment or replace traditional backup approaches.

     

    Without requiring any additional licenses, HPE RMC for Oracle, SAP HANA, and SQL Server are included with every HPE Primera, HPE 3PAR StoreServ, and HPE Nimble Storage array. HPE RMC combines the performance of local and remote snapshots with the protection of backups to enable fast, efficient, reliable, and simple protection of Oracle and SQL Server data, as well as log volumes of SAP HANA data.

     

    In addition to data protection, HPE RMC allows copy data management for databases. Oracle and SQL Server DBAs can mount the snapshots on a designated server for operations such as database migration or use them to create a clone of the database on a backup server. Using HPE RMC, DBAs can rapidly spin up fast clones for DevOps, unlocking the value of mission-critical databases. Oracle and SQL Server cloning speed is at least 31 times faster, takes eight fewer steps, and requires up to three times less storage capacity compared to traditional methods.  1 SAP HANA copy data management includes system copy or refresh operations, which involve moving one or more tenants or entire SAP HANA systems from one host to another to create production and nonproduction copies of existing systems. System copy or refresh processes use HPE RMC and many other methods to manage data copies.

Consider cloud storage

If you are considering cloud storage for long-term data retention and lower cost disaster recovery, HPE Cloud Bank Storage enables you to implement a simple and reliable off-site disaster recovery solution. It backs up your database to and restores from cloud storage. HPE Cloud Bank Storage is integrated into HPE RMC and HPE StoreOnce Catalyst Plug-ins.

 

Databases can also be directly backed up from HPE primary storage to HPE Cloud Volumes Backing up with HPE RMC eliminates the need for a secondary backup site by offering a tertiary copy to the cloud in addition to having a secondary backup site. Databases are backed up from HPE Primera, HPE 3PAR, and HPE Nimble Storage to HPE Cloud Volumes Backup stores and are restored back to the same or alternative HPE primary storage arrays.

 

HPE database protection enables you to follow the 3-2-1 best practice by:

  • Maintaining three copies of data (the primary data and two copies) to avoid losing data to a faulty backup
  • Storing backup copies on two different media types such as tape, disk, secondary storage, or the cloud
  • Keeping one copy off-site—either on tape or in the cloud—in the event of local hazards or ransomware infections within the network
  • Benefits of HPE RMC For Oracle, SAP Hana, and SQL Server

    HPE RMC combines the speed of taking nondisruptive snapshots on HPE Primera, HPE 3PAR StoreServ, and HPE Nimble Storage arrays with the reliability and efficiency of deduplicated backups on HPE StoreOnce. This delivers a converged availability and a fast backup and recovery solution for Oracle, SAP HANA,  2 and SQL Server that DBAs can easily manage. HPE RMC offers the following benefits for database environments:

     

    • Fast backup and recovery: Unlike traditional approaches, HPE RMC only sends changed data blocks to HPE StoreOnce, leading to faster and more efficient database backup. When a database crashes, HPE RMC quickly recovers data using multiple block‑based streams, enabling you to deliver on aggressive RTO service-level agreements (SLAs). You can also commit to tight RPO SLAs with frequent recovery points. HPE RMC accelerates backups to and restores from next-generation HPE StoreOnce systems by 30% compared to the previous HPE StoreOnce generation.  3
    • Reduced cost and complexity: Data protection with HPE RMC is simple with direct backup from array snapshots to HPE StoreOnce. Because the stored backups on HPE StoreOnce systems are deduplicated, backup storage costs are contained—and in fact, you can economically store data on HPE StoreOnce for extended periods. Infrastructure costs and the datapath are also reduced because HPE RMC runs natively on HPE StoreOnce appliances.
    • Application-managed and granular data protection: DBAs can monitor and manage snapshots, backups, and recovery directly and seamlessly from within the HPE RMC GUI that is launched from Oracle Enterprise Manager, SAP HANA Studio, or SQL Studio. Additionally, Element Recovery Technology enables granular recovery of an individual database file or files from an HPE StoreOnce backup, providing the same recovery experience for both snapshots and backups, depending on RPOs and RTOs.
    • Single console to manage application data hosted in heterogeneous storage environments: HPE primary storage snapshots can be managed with a single centralized SLA policy that defines frequency and retention of snapshots, backups, and copies including HPE Cloud Volumes Backup and HPE Cloud Bank Storage.
    • Efficient copy data management: HPE RMC offers a one-click clone database feature, which allows administrators to automatically bring up a fully functional single-instance Oracle or SQL Server database clone. This function provides a copy of the production database for testing and development, QA, reporting, analytics, or migration purposes. HPE RMC also enables DBAs to start the Oracle or SQL Server clone in mounted mode for backup and restore operations.

    Moving these operations off the production server reduces risk and improves the performance of the production environment. For SAP HANA databases, HPE RMC takes an application-consistent data snapshot of the source database and copies it to an HPE StoreOnce Catalyst store. This can be restored to a snapshot on the same HPE storage array or to a new volume on the same or different HPE storage array. Using SAP HANA Studio, you can then restore from the data snapshot of the source database. In summary, HPE RMC copy data management delivers the following benefits:

     

    • Policy-based copy automation where a single copy policy helps minimize secondary copy data sprawl across tiers
    • Creation of live and updatable clones of production databases without consuming additional storage space or impacting production
    • Enabling zero footprint clones to run at production speeds, even while servicing multiple copies from the same original volume by high I/O delivered by all-flash HPE Primera, HPE 3PAR, and HPE Nimble Storage
  • Benefits of HPE StoreOnce Catalyst Plug-ins

    Because HPE StoreOnce Catalyst Plug-ins for Oracle, SAP HANA, and SQL Server are integrated with Oracle RMAN, Backint for SAP HANA, and SQL Server backup functions, respectively, DBAs can efficiently transfer backups from the database to the backup target. The plug-ins provide the following benefits for database environments:

     

    • Efficient resource consumption: The plug-ins deliver efficient use of network bandwidth and fast backup processing time with source-side deduplication. This means only unique data is sent to the HPE StoreOnce appliance, thereby helping optimize network utilization and significantly reducing bandwidth requirements. In addition, Oracle and SQL Server backups and restores are accelerated by 50% and 15%,  4 respectively, with next-generation HPE StoreOnce systems compared to the previous generation.
    • Reduced backup footprint: An improved deduplication ratio allows backups to be stored longer with reduced storage capacity compared to file backup implementations. Storage capacity requirements are reduced by 95% compared to a fully hydrated backup—guaranteed.  5
    • Increased cost savings: By enabling direct backups to HPE StoreOnce, third-party data protection software is not required. The HPE StoreOnce Catalyst Plug-in controls the backup using Oracle RMAN, SAP HANA Backint, or SQL Server backup functions to make a direct copy to the HPE StoreOnce appliance. This helps eliminate the need to pass through a backup media server.
    • Control and simplicity: The HPE StoreOnce Catalyst Plug-in is installed directly onto the database nodes with only a few clicks. DBAs can back up, restore, and delete database backups directly from Oracle Enterprise Manager, SAP HANA Studio, and SQL Server Studio. DBAs have complete control of the backups.
  • HPE Cloud Bank Storage

    HPE Cloud Bank Storage is an HPE StoreOnce feature that delivers highly efficient storage and data transfer to the cloud. The combination of HPE StoreOnce deduplication and cloud storage provides a low-cost, high-performance, zero-risk, and long-term retention solution. HPE Cloud Bank Storage is:

     

    • Economic: Protect more than 100 PB  6 of data at 20X  7 lower cost than existing public cloud services. You can triple  8 the native capacity of HPE StoreOnce systems by leveraging on-premises or public cloud storage. HPE Cloud Bank Storage and HPE StoreOnce deliver 3X to 5X  9 lower cost over a five-year period when compared to third-party software backups to the cloud.
    • Efficient: Reduce your storage capacity requirements by 20X  10 with HPE StoreOnce deduplication technology and help optimize bandwidth utilization cost while transferring the data. HPE Cloud Bank Storage and HPE RMC deliver 10X  11 faster backups when compared to third-party software backups to the cloud.
    • Flexible: Protect Oracle, SAP HANA, and SQL Server data on-premises and off-premises with public and private cloud services by simply upgrading your HPE StoreOnce software. You can upgrade by purchasing an HPE Cloud Bank Storage license and pointing it at either AWS, Microsoft Azure, or even your own private cloud with Scality RING, Accenture Cloud Platform (ACP), SUSE, or IBM Cloud Object Storage (formerly Cleversafe).
    • Reliable: Mitigate risk with a simple, encrypted, and reliable cloud disaster recovery solution. HPE Cloud Bank Storage moves data to cloud storage and from the cloud back to the local HPE StoreOnce system. The self-describing backup data in the cloud enables you to restore to any HPE StoreOnce system if access to the original on-premises system is lost.
  • Summary

    Choose HPE Recovery Manager Central for fast backup and recovery of databases on HPE Primera, HPE 3PAR StoreServ, and HPE Nimble Storage systems, as well as for copy data management tasks. HPE RMC seamlessly integrates robust, flash-optimized HPE Primera, HPE 3PAR StoreServ, and HPE Nimble Storage arrays, along with fast, scalable, and highly resilient HPE StoreOnce systems.

    If you want to deploy a native database protection solution, such as Oracle RMAN, Backint for SAP HANA, or SQL Server backup functions, choose the HPE StoreOnce Catalyst Plug-in. This enables DBAs to back up and restore directly to or from HPE StoreOnce through Oracle Enterprise Manager, SAP HANA Studio, or SQL Server Studio.

     

    Consider HPE Cloud Bank Storage to retain data for a longer time on high-capacity and low‑cost cloud storage. HPE Cloud Bank Storage also enables you to implement a simple and reliable off-site disaster recovery solution by backing up to and restoring from cloud storage.

     

    HPE data protection and copy data management solutions for databases simply and efficiently deliver the end-to-end availability, agility, and business continuity that your database environment demands.

Learn more at

hpe.com/storage/storeonce

hpe.com/storage/rmc

Download the PDF

Azure, Microsoft, and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. SAP HANA is a trademark or registered trademark of SAP SE (or an SAP affiliate company) in Germany and other countries. All third-party marks are property of their respective owners.


  • 1 Based on HPE internal testing on 1 TB Oracle and Microsoft SQL Server databases, May 2019. 
  • 2 HPE RMC for SAP HANA protects only SAP HANA data volumes because snapshots cannot be taken from log volumes. 
  • 3,4 Based on HPE internal testing, July 2018 
  • 5 Refer to the HPE StoreOnce Get Protected Guarantee Program 
  • 6 100 PB assumes deduplication ratio of 20:1 and the maximum logical capacity of HPE StoreOnce 6600 of 34 PB. 
  • 7,10 This value reflects the long-term cost of retaining backup data with HPE Cloud Bank Storage for HPE StoreOnce. It assumes deduplication ratio of 20:1 and Amazon Web Services (AWS) S3 standard object storage pricing of $0.02 per GB per month. 
  • 8 Capacity can triple compared to a fully hydrated backup using external object storage. 
  • 9,11 Lab Insights—Data Protection in a Hybrid Cloud Environment, Evaluator Group and Demartek, May 2018. 
Based on HPE internal testing on 1 TB Oracle and Microsoft SQL Server databases, May 2019. 
HPE RMC for SAP HANA protects only SAP HANA data volumes because snapshots cannot be taken from log volumes. 
Based on HPE internal testing, July 2018 
100 PB assumes deduplication ratio of 20:1 and the maximum logical capacity of HPE StoreOnce 6600 of 34 PB. 
This value reflects the long-term cost of retaining backup data with HPE Cloud Bank Storage for HPE StoreOnce. It assumes deduplication ratio of 20:1 and Amazon Web Services (AWS) S3 standard object storage pricing of $0.02 per GB per month. 
Capacity can triple compared to a fully hydrated backup using external object storage. 
Lab Insights—Data Protection in a Hybrid Cloud Environment, Evaluator Group and Demartek, May 2018.