Oracle Database Protection and Recovery with Rman

By Rawlinson Rivera • December 27, 2017

In today’s era of digital transformation and the ubiquity of Internet of Things (IoT), 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.

Problems with 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.

Data Management Challenges

  • 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

Data Management Requirements

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 Recovery Time Objective (RTO) and Recovery Point Objective (RPO) 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.

Backup and Recovery for Oracle

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.

Backup and Recovery for Oracle

Backup and Recovery for Oracle

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

Cohesity’s integration with Oracle RMAN 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. The 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.

Integration with Oracle RMAN

The advantages of the Cohesity Remote Adapter and Oracle RMAN include 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

Target Deduplication for Oracle

Oracle RMAN can use the  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.

Deduplication for Oracle RMAN

Deduplication for Oracle RMAN

RMAN with Cohesity as target storage advantages:

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

Source Deduplication for Oracle

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.

RMAN with Cohesity Oracle Source Side Deduplication advantages:

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

Oracle Data Protection

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
Oracle Data Protection

Oracle Data Protection

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.