Configuration - SAP Oracle iDataAgent

Configuration

Once the SAP Oracle iDataAgent has been installed, configure an Instance to facilitate backups. Each instance references an Oracle database. Also it is recommended to create separate subclients for data and log backups. The following sections provide the necessary steps required to create and configure these components for a first backup of an Oracle database.

Creating an Instance

  1. From the CommCell Browser, navigate to <Client> | SAP for Oracle. Right-click SAP for Oracle | All Tasks and click New Instance (ORACLE SID).

  2. Specify the following details:
    • In the Instance (Oracle SID) box, type the Instance Name.
    • Browse or enter the path to the Oracle application files in Oracle Home.
    • Browse or enter the path to the Oracle data and control files in SAP DATA PATH.
    • Select a Storage Policy from the drop down list.

      If you do not have a Storage Policy created, follow the steps given below to create a Storage Policy.

      If you have already created a Storage Policy, then go to step 4.

  3. Create a Storage Policy:

    Note: The storage policy retention for the SAP Oracle IDA must be relative to the SAP recov_interval value. The SAP recov_interfval is set in the init<SID>.sap profile file and defines the time interval that the BRRESTORE and BRRECOVER commands search for the data and log backup details files in the summary file. By default, this value is 30 days. For more information, see FAQs.

    1. From the CommCell Browser, navigate to Policies.
    2. Right-click the Storage Policies and then click New Storage Policy.
    3. Follow the prompts displayed in the Storage Policy Wizard. The required options are mentioned below:
      • Select the Storage Policy type as Data Protection and Archiving and click Next.
      • Enter the name in the Storage Policy Name box and click Next.
      • From the Library list, click the name of a disk library to which the primary copy should be associated and then click Next.

        Ensure that you select a library attached to a MediaAgent operating in the current release.

      • From the MediaAgent list, click the name of a MediaAgent that will be used to create the primary copy and then click Next.
      • For the device streams and the retention criteria information, click Next to accept default values.
      • Review the details and click Finish to create the Storage Policy.

  1. For Windows Client

    • Click Change.
    • Enter the User Name and Password to access the Oracle application. Re-confirm the password.
    • Click OK.

    Use <client_name>/<SID_name>adm in order to perform backup and restore operations from CommCell Console for the associated instance.

    Make sure that the user has administrator privileges to access the Oracle application.

    For UNIX Client

    Enter the user name in ORACLE USER to access the Oracle application on a Unix client.

    Use <SID_name>adm in order to perform backup and restore operations from CommCell Console for the associated instance.

    Make sure that the user has administrator privileges to access the Oracle application.

  1. Click Details tab and add the following information:
    • Enter the target database connect string in Connect String.
    • Browse or enter the path to the SAP EXE folder in SAP EXE Folder (Required).

  2. Click Storage Device tab.

    Select a Storage Policy used for user command backup of data from the drop down list.

  3. Click Log Backup tab.
    • Select a Storage Policy used for all Archive Log backups from the drop down list.
    • Click OK.

Creating Subclient for Data Backup

  1. From the CommCell Browser, navigate to <Client> | SAP for Oracle | Instance.

    Right-click Instance | All Tasks and click New Subclient.

  2. Enter the Subclient Name.

  3. Click the Logs Backup tab and clear the check box for Backup Archive Log.

  4. Click the Storage Device tab.
    • Select a Data Storage Policy from the drop down list.
    • Click OK.

Creating Subclient for Log Backup

  1. From the CommCell Browser, navigate to <Client> | SAP for Oracle | Instance.

    Right-click Instance | All Tasks and click New Subclient.

  2. Enter the Subclient Name.

  3. Click the Content tab and clear the check box for Data.

  4. Click the Storage Device tab.
    • Select a Data Storage Policy from the drop down list.
    • Click OK.

    Make sure that the storage policy selected uses the same MediaAgent used by data and logs.