Configuration - Oracle RAC iDataAgent

Configuring the CommCell Console Users for Oracle RAC Administration

The CommCell Console user that adds nodes to the Oracle RAC pseudo client must be in a group that has the Administrative Management capability for the member nodes.

Create the group with the Administrative Management capability and then assign the user to the group. For information on how to configure and assign groups, see Getting Started with User Administration and Security.

Creating a Pseudo-Client for Oracle RAC

Once the Oracle Data Agent is installed on all the RAC database nodes, create a new Oracle RAC pseudo-client that  is a logical grouping of Oracle instances in the Oracle RAC instance.

  1. From the CommCell Bowser, right-click Client Computers, point to New Client >Application and then click Oracle RAC.

    The Create Oracle RAC Client dialog box is displayed.

  2. On the General tab, provide the pseudo-client details.
    1. In the Pseudo-client Name box, type a name for the RAC client.
    2. In the Database Name box, type the name of the RAC database to which you are assigning this client.

      The Database Name must be of the same case as the name of the Oracle RAC database.

      Example:

      SQL> select name from v$database;
      NAME
      ---------
      db1

    3. From the Storage Policy list, select the storage policy used for default subclient data.

      If you do not have a storage policy, Create a Storage Policy.

  3. On the Details tab, determine how you want to connect to Oracle.
    Option Configuration
    Oracle Wallet Auto Login

    You can use this option when you have configured the Secure External Password Store (Oracle Wallet) feature that stores password credentials, and you want to use those credentials during the data protection operations. For more information on the Secure External Password Store, go to the Oracle documentation website, Secure External Password Store.

    1. Select the Oracle Wallet Auto Login check box.
    2. Enter the Oracle Service Name in the Connect String third box.

    Note: If you provide the user name and password, the software ignores the Oracle Wallet feature.

    Use the Oracle Catalog Connect String Select the Use Connect String check box and in the Connect String box enter the Oracle connect string credentials.

    Note: If you want to use an account other than 'sys', you must grant the SYSDBA or SYSBACKUP (in Oracle version 12 or higher) privilege to the user account.

    Enter the Catalog Connect String to connect to the Oracle database.

    1. Enter the database user name in the Connect String first box.
    2. Enter the database user password in the Connect String second box.
    3. In the Confirm Password dialog box, re-enter the password, and click OK.
    4. Enter the Oracle service name in the Connect String third box.

    For example, in the following:

    sysdba/<password>@orcl

    sysdba is the database user id

    <password> is the database user id password

    orcl is the Oracle service name

  4. On the Details tab, add the Oracle instances.
    1. Click Add.

      The Add Instance dialog box is displayed.

    2. From the Instance Physical Client list, select the client name of the Oracle instance.
    3. In the Instance (ORACLE SID) box, type the name of the Oracle instance.
    4. Click Change User Account and type the Oracle user name and password.
    5. In the ORACLE HOME box, type or click Browse to locate the Oracle application install path.
    6. In the Connect String box, type the Oracle database user with privileges to access the Oracle database in the Oracle RAC node .

      Use the SYS login for example, sys/password@Service for the connect string. For example, sys/pwd12@orcl4.

    7. In the TNS_ADMIN Folder, type the path for the TNS_Admin directory.
    8. Click OK to close the Add Instance dialog box.
    9. Repeat the previous steps for each instance that you want to add.
  5. On the Storage Device tab, configure the storage policy information.
    1. In the Storage Policy used for user command backup of data box, select the data backup storage policy name.
    2. Click the Logs Backup tab.
    3. In the Storage Policy used for all Archive Log backups box, select the log backup storage policy name.
  6. Click OK.

Follow these steps if the database is in NoArchivelog mode

Creating a Subclient for Offline Backup

  1. From the CommCell Browser, expand Client Computers > client > Agent.
  2. Right-click the instance, point to All Tasks and then click New Subclient.

    The Create New Subclient dialog box appears.

  3. On the General tab, in the Subclient name box, enter a name for the subclient.
  4. On the Content tab, specify whether the backup is a full backup:
    • Select the Data check box.
    • Select the Offline Database option.
  5. On the Storage Device tab, select the name of the Data Storage Policy.

    If you do not have a storage policy, Create a Storage Policy.

  6. Click OK to close the Create New Subclient dialog box.