Streamlining Oracle Database Protection and Recovery with Cohesity and Oracle Rman

By Rawlinson Rivera • December 27, 2017

In today’s era of digital transformation and the ubiquity of IoT (Internet of Things), enterprises are faced with significant challenges around the management of business-critical data. Organizations find themselves in a deep struggle with data protection, access, retention, and recovery, as well as mobility.

The problem with old-school data management solutions

Traditional data management solutions can’t keep up with the data growth and business demands of our current times.

This is partly because the majority of data-management solutions were designed to satisfy the business requirements of a couple of decades ago. They lack modern and advanced technological innovations, as well as modernized operational workflows designed to drive simplicity in management.

Traditional data protection and recovery solutions depend on complex workflows and processes that require a lot of management efforts to perform some of the most fundamental and core functions. In enterprise scenarios, the manageability of the infrastructure is compromised by complex solutions and operational procedures.

Complexity not only increases the management efforts, it also increases operational costs. More importantly, complexity increases the probability of functional risks, which can be extremely costly and detrimental to any business.

In short, there is a list of challenges causing a lot of people – from the executive staff all the way down to the infrastructure admins – to lose sleep over management and protection of their data.

Here’s what they are thinking about in the wee hours of the morning:

  • Protections and recovery windows
  • Recoverability service levels
  • Reduction of risks and exposure to data loss
  • Long-term backup storage
  • Data management complexity
  • Data sovereignty and compliance
  • Budgets and costs

Overcoming challenges

Enterprises have to adopt a modern data management solution that is capable of addressing the challenges covered above.

Most information generated and stored by business-critical applications relies on relational database management systems, such as Microsoft SQL Server and Oracle to name a few. Oracle is one of the undeniable leaders in the relational database management systems domain, and it’s also one of the most relied upon systems in the enterprise.

Application owners and database admins face the challenge of protecting a large number of databases with data volumes that continuously expand due to growth in database sizes, as well as regulatory compliance requiring longer data retention periods.

Moreover, because of long-term data sovereignty and compliance mandates, it has become too expensive and risky to preserve protected data on traditional primary storage systems. At the same time, having an active data-protection strategy with fast RTOs and RPOs is paramount, especially for mission-critical applications that can withstand only minimal downtime windows.

This means enterprises have to satisfy data-management business requirements, whilst also adhering to data sovereignty and compliance regulation acts.

A solution is needed that is capable of simplifying and streamlining their data management procedures.

Streamlining Procedures

Cohesity’s DataPlatform helps enterprises overcome data-management challenges by streamlining procedures, and providing a simple, fast, and cost-effective converged data platform. This platform includes a data protection and recovery solution for growing Oracle database environments.

With native integration to Oracle Recovery Manager (RMAN), Cohesity provides application-consistent backup and recovery for both Oracle single instance or Real Application Clusters (RAC).

COHESITY DATAPLATFORM PROVIDES POWERFUL INTEGRATION OPTIONS FOR ORACLE RECOVERY MANAGER (RMAN)

Cohesity’s Remote Adapter integration with Oracle RMAN – Cohesity Remote Adapter delivers an integrated and centralized approach to managing Oracle backup jobs. It provides a single location to register and schedule all RMAN scripts across the Oracle environment. Remote Adapter is built into Cohesity DataPlatform and offers flexible management of scripts running on remote hosts.

This allows the Cohesity cluster to manage data protection processes and schedules as well as provide a consolidated log of all activity. Oracle RMAN scripts are still hosted on the Oracle server with one extra step to register the scripts with the Cohesity cluster.

Once registered, the RMAN scripts are remotely triggered and monitored for completion and activity logged on the cluster.

Advantages of the Cohesity Remote Adapter and Oracle RMAN: Simplifying administration by providing a single-pane-of-glass for managing backup attributes and reports.

More specifically, the Remote Adapter:

  • Provides a single location for the customer to register all RMAN scripts
  • Provides central scheduling for all RMAN scripts consolidating data protection scheduling across multiple Oracle servers
  • Reports and tracks all backup tasks, schedules, and alerts from a single console
    Provides QoS policies for workload optimization

Oracle RMAN Writing to Cohesity DataPlatform as a deduplication target – For this option, Cohesity is presented as an NFS volume, enabling direct mounting to Oracle database servers. No intermediate media servers are required.

RMAN automatically leverages Cohesity’s QoS policy for optimal data tiering as well as global deduplication and compression to reduce secondary storage consumption and footprint.

Advantages of leveraging RMAN with Cohesity as target storage:

  • Supports existing DBA processes with no changes required by DBA
  • Leverages Cohesity scale out platform
  • Provides QoS policies for workload optimization

Oracle RMAN with Cohesity Oracle Source Side Deduplication Plugin

For this option, Cohesity is presented as an NFS volume, but RMAN calls for the Cohesity Oracle Source Side Deduplication plugin; this allows for storage-efficient deduplication that enhances the environment with faster backups and reduced network traffic by only sending new data blocks.

Advantages of leveraging Cohesity Oracle Source Side Deduplication Plugin with RMAN:

  • Faster Backups
  • Reduce Network traffic between Oracle DB servers and Cohesity DataPlatform
  • Enables more frequent backups resulting in RPOs

Cohesity’s DataPlatform also makes it easy for enterprise organizations to assess and validate the reliability of their data protection strategy and requirements from both physical and logical perspectives

  • Physical: Disasters, outages, failures, corruptions
  • Logical: Human errors, application errors, remote replication

Take a look at the demonstration below which showcases Cohesity’s integration with Oracle RMAN.

-Enjoy

For future updates about Cohesity, Hyperconverged Secondary Storage, and anything in our wonderful world of technology be sure to follow me on Twitter: @PunchingClouds.