Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

PowerProtect Data Manager 19.17 Oracle RMAN User Guide

PDF

PowerProtect Data Manager support of Oracle active/passive RAC systems

Oracle RAC One Node is a single instance of an Oracle RAC database that runs on one node in a cluster. An Oracle RAC One Node system is also known as an Oracle active/passive RAC system. The Oracle active/passive RAC system provides enhanced high availability for single-instance Oracle databases, protecting them from planned and unplanned downtime.

PowerProtect Data Manager supports the Oracle backups and restores in a high-availability Oracle RAC One Node or active/passive system through the PowerProtect Data Manager UI and integrated Oracle RMAN agent workflows. The Oracle active/passive RAC system includes one active node where the database runs and multiple passive nodes in the cluster.

NOTE:

The Oracle RMAN agent and PowerProtect Data Manager agent service must be installed on each node in the Oracle active/passive RAC system and registered with the PowerProtect Data Manager.

In an Oracle active/passive RAC system, assigning a preferred node or setting cluster backup nodes for multistream parallel backups is not supported.

PowerProtect Data Manager automatically discovers all the nodes of the Oracle active/passive RAC system and identifies the current active node where the database is running. In the PowerProtect Data Manager UI, the assets of the active/passive system are listed with the host type "Active Passive RAC". To view the assets in the UI, select Infrastructure > Assets and then click the Oracle tab.

PowerProtect Data Manager also supports the protection of an Oracle active/passive RAC system with Oracle Data Guard configurations or Oracle Incremental Merge operations.

If you use Oracle RMAN agent parameters in the Oracle active/passive RAC configuration, then verify the configuration file after a database failover or switchover. Ensure that the instance name of the currently running instance is included in the Oracle RMAN agent configuration file.

Protection policy configuration

After you edit a protection policy for an Oracle active/passive RAC asset, the configuration job runs on all the nodes of the cluster, including the active and passive nodes. The failover or switchover of the active node also generates the configuration job on all the nodes. In the jobs display in the PowerProtect Data Manager UI, the configuration job status appears as Skipped for any node that has not been discovered at least once by PowerProtect Data Manager.

Manual configuration is required if the active node has not been discovered at least once by PowerProtect Data Manager. In the PowerProtect Data Manager UI, select Protection > Protection Policies, and then select the policy in the list and click Set Lockbox, which starts the configuration.

Backup and restore operations

PowerProtect Data Manager automatically schedules the backups on the current active node. After detecting a failover or switchover of the active node, PowerProtect Data Manager automatically tries to run the backup job on the new active node.

PowerProtect Data Manager performs the online restores on the current active node. While performing the online database recovery to the original host, PowerProtect Data Manager lists the active node that is known at the time. If the listed node is not the current active node, you can perform a full discovery of the active node from the Infrastructure > Asset Sources window. Follow the full discovery procedure in Discover an Oracle application host, and then restart the restore operation.

Limitations of Oracle active/passive RAC systems

You might encounter the following limitations during operations with the Oracle active/passive RAC systems.

Self-service protection

When a passive node becomes active for the first time, PowerProtect Data Manager discovers the new active node only after a certain time interval. This time interval depends on the configured application discovery interval and asset discovery interval, which are by default 31 minutes and 11 minutes, respectively. Any self-service backups that are performed during this interval might encounter the following issues:

  • The protections jobs might fail because the lockbox does not contain the required DD credentials.
  • The Oracle RMAN agent might be unable to override the DD details. As a result, the backups might go to a different DD, based on the DD details provided with the RMAN script.

To resolve these issues, you can perform either of the following actions:

  • You can wait for PowerProtect Data Manager to discover the new active node.
  • You can manually discover the new active node from the Infrastructure > Asset Sources window according to Discover an Oracle application host.

When the new active node is discovered, PowerProtect Data Manager performs a configuration of the new active node. If the configuration does not occur, then perform a manual configuration. In the PowerProtect Data Manager UI, select Protection > Protection Policies, and then select the policy in the list and click Set Lockbox, which starts the configuration. When the configuration is complete, you can perform the self-service backups.

Online database restore to original host

When a failover or switchover occurs and PowerProtect Data Manager has not yet discovered the new active node, an online database restore to the original host from PowerProtect Data Manager can fail. In this case, PowerProtect Data Manager does not retry the operation on the new active node.

To resolve the issue, you can perform either of the following actions:

  • You can wait for PowerProtect Data Manager to discover the new active node.
  • You can manually discover the new active node from the Infrastructure > Asset Sources window according to Discover an Oracle application host.

Once the active node is successfully discovered, you can restart the restore operation.

Protection copy deletion

When a failover or switchover occurs and PowerProtect Data Manager has not yet discovered the new active node, a scheduled or manual backup copy deletion from PowerProtect Data Manager can complete with exceptions. In this case, PowerProtect Data Manager does not retry the copy deletion on the new active node.


Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\