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

Enable the multistream parallel backups in an Oracle RAC environment

In an Oracle RAC environment, you can enable the multistream parallel backups as either Application Direct centralized backups or Oracle Incremental Merge centralized or self-service backups. The parallel backups can run on either all nodes or selected nodes in the RAC environment, based on the configuration. You can set the cluster backup nodes to be used for the backups through an asset-level option in the PowerProtect Data Manager UI.

NOTE:When cluster backup nodes are set, Oracle Incremental Merge backups ignore any section size setting.

You must select at least one node in the PowerProtect Data Manager UI to set the cluster backup nodes for the parallel backups.

If either of the following conditions is true, you can set the cluster backup nodes:

  • The asset-level credentials are set to database authentication or Oracle wallet authentication.
  • The asset-level credentials are not set, but the policy-level credentials are set to database authentication or Oracle wallet authentication.
NOTE:

The credentials set at the asset level take precedence over the credentials set at the policy level.

If either of the following conditions is true, the cluster backup nodes are disabled in PowerProtect Data Manager:

  • The asset-level credentials are set but changed from database authentication or Oracle wallet authentication to operating system authentication.
  • The asset-level credentials are not set, but the policy-level credentials are changed from database authentication or Oracle wallet authentication to operating system authentication.

If any cluster backup nodes are unavailable during a multistream parallel backup, the following stream allocation occurs:

  • If one cluster backup node or a subset of the cluster backup nodes is unavailable, the streams from the unavailable nodes are either ignored or distributed among the available nodes, based on the streams setting in the PowerProtect Data Manager UI.
  • If all the cluster backup nodes are unavailable, the backup operation fails.
NOTE:The streams setting that you specify when you set the cluster backup nodes in the PowerProtect Data Manager UI takes precedence over the streams setting through Enable multistream backups for Oracle protection policy.

Prerequisites for Oracle RAC multistream parallel backups

Ensure that you meet the following requirements for the multistream parallel backups in an Oracle RAC environment:

  • The Oracle RMAN agent is installed on all the nodes that are used for the parallel backups.
  • If the NAMES.DIRECTORY_PATH variable is set in $ORACLE_HOME/network/admin/sqlnet.ora, then EZCONNECT is specified as one of the variable values. For example:
    cat /u02/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora
    
    NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
    WALLET_LOCATION =
       (SOURCE =
         (METHOD = FILE)
         (METHOD_DATA =
           (DIRECTORY = /u02/app/oracle/product/19.0.0/dbhome_1/wallet)
         )
       )
    SQLNET.WALLET_OVERRIDE = TRUE
    SSL_CLIENT_AUTHENTICATION = FALSE
    SSL_VERSION = 0
  • Database authentication or Oracle wallet authentication (not operating system authentication) is enabled.
  • If Oracle wallet authentication is enabled, each RAC cluster node has the created wallet that contains the entries of all the RAC nodes in the following format:
    <hostname_of_node_1>:<port_1>/<service_name_1>
    <hostname_of_node_2>:<port_2>/<service_name_2>
         :
    <hostname_of_node_n>:<port_n>/<service_name_n>

Enabling the Oracle RAC multistream parallel backups

In the PowerProtect Data Manager UI, perform the following steps to set the cluster backup nodes that are used for the parallel multistream backups of the selected asset. During the Application Direct centralized backups or Oracle Incremental Merge centralized or self-service backups, the backup streams are allocated according to the streams setting specified in the following procedure.

  1. Select Infrastructure > Assets, and then click the Oracle tab.
  2. For each node that you want to set as a cluster backup node, ensure that the required database or wallet credentials are set for each associated asset:
    1. Select the associated asset with the Host Type RAC.
    2. Select More Actions > Set Credential.
    3. In the Set Credential dialog, specify the database credentials for the Database User or Wallet.
    4. Click Save.
  3. For each node that you want to set as a cluster backup node, complete the following steps:
    1. Select the associated asset with the Host Type RAC.
    2. Select More Actions > Set Cluster Backup Nodes.
    3. In the Set Cluster Backup Nodes dialog on the Cluster Nodes page, click Add.
    4. In the Add Cluster Nodes dialog, select the required cluster nodes from the list and then click Add.
    5. On the Cluster Nodes page, specify the required values in the Service Name and Port fields.
    6. Click Stream Count, and specify the number of streams or channels to allocate for each listed backup type, such as full, incremental cumulative, incremental differential, log, and synthetic full backups. Click Next.
    7. On the Options page, select one of the following options and then click Next:
      • Ignore the channels—This option specifies that when any selected nodes are unavailable during the backup, the streams from the unavailable nodes are ignored.
      • Distribute the channels—This option specifies that when any selected nodes are unavailable during the backup, the streams from the unavailable nodes are distributed among the available nodes.
    8. On the Summary page, review the displayed settings for the selected cluster backup nodes. To change any settings, click Edit or Back to return to a previous page.

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: <>()\