PowerProtect Data Manager 19.12 Oracle RMAN User Guide

Centralized restore and recovery of Oracle backups

When Oracle Server data is backed up as part of a protection policy in PowerProtect Data Manager, you can restore and recover the Oracle Server backups by using the centralized restore and recovery functionality in the PowerProtect Data Manager UI.

A centralized Oracle restore and recovery includes the following limitations:

• You cannot perform a cross-OS platform restore.
• You cannot perform a quick recovery.
• You cannot perform a centralized restore of an Oracle backup performed by a stand-alone Oracle RMAN agent before the agent was registered with PowerProtect Data Manager.

You can perform the following types of centralized restore and recovery of Oracle Server backups:

• Centralized restore and recovery of a full online database without restore of the control file.
• Centralized restore of only archive logs without restore of the control file.
• Centralized disaster recovery of an entire database, including the spfile and control file.

Using a centralized restore from the PowerProtect Data Manager UI, you can restore the Oracle database or archive logs for a single asset. You can perform the centralized restore to either the original Oracle Server host or an alternate host with the following requirements:

• The Oracle RMAN agent software must be installed and configured on the alternate host.
• The alternate host must be an Oracle Server host that is a discovered asset of PowerProtect Data Manager.

Optionally, you can select to perform a dry run of any centralized restore and recovery operation to either the original host or an alternate host. The dry run option creates the required RMAN restore scripts, but does not perform an actual restore or recovery. You can use the RMAN restore scripts that the dry run creates to perform a self-service restore as required.

You must perform all centralized restore and recovery operations from the Restore > Assets > Oracle window in the PowerProtect Data Manager UI. You can perform a centralized restore and recovery to a specified Oracle Server host.

The following topics describe the considerations, prerequisites, and procedures for the supported types of centralized restore and recovery of Oracle backups.