Getting Started - SAP for Oracle Configuration

Configuration

Once the SAP for 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 SnapProtect backup of an Oracle database.

1.
  • From the CommCell Browser, navigate to Client Computers | <Client>.
  • Right-click the client and select Properties.
2.
  • Click on the Advanced tab.
  • Select the Enable SnapProtect option to enable SnapProtect backup for the client.
  • Click OK.

 
3.
  • From the CommCell Browser, navigate to <Client> | SAP for Oracle.
  • Right-click SAP for Oracle and click All Tasks | New Instance (ORACLE SID).
4.
  • Enter the Instance Name.
  • Enter the user name in User Account 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.

  • 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.
5. 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).
6.
  • Click Storage Device tab.
  • Select a Storage Policy used for user command backup of data from the drop down list.
7.
  • Click Log Backup tab.
  • Select a Storage Policy used for all Archive Log backups from the drop down list.
  • Click OK.
8.
  • From the CommCell Browser, navigate to <Client> | SAP for Oracle.
  • Right-click the <Instance> and click All Tasks | New Subclient.
9. In the Subclient Name field, type a name.
10.
  • Click the SnapProtect Operations tab.
  • Click SnapProtect option to enable SnapProtect backup for the selected subclient.
  • Select the storage array from the Available Snap Engine drop-down list.

  • From the Use Proxy list, select the MediaAgent where SnapProtect and backup copy operations will be performed.

    When performing SnapProtect backup using proxy, ensure that the operating system of the proxy server is either same or higher version than the client computer.

  • Click Use Separate Proxy for Snap to Tape if you want to perform backup copy operations in a different MediaAgent.

    Select the MediaAgent from the Proxy list.
11. Click the Content tab and clear the check box for Backup Archive Log.
12.
  • Click the Storage Device tab.
  • Select a Data Storage Policy from the drop down list.
  • Click OK.
13.
  • From the CommCell Browser, navigate to <Client> | SAP for Oracle.
  • Right-click the <Instance> and click All Tasks | New Subclient.
14. In the Subclient Name field, type a name.
15. Click the Content tab and clear the check box for Data.

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

Skip this section if not using Solaris.

Click to Continue.

Enable SnapProtect Backups on Solaris Zone

Follow the steps given below to enable SnapProtect backups on each of the non-global zone clients containing the application data.

1.
  • From the CommCell Console, navigate to Client Computers | <Client>.
  • Right-click the client and select Properties.
2.
  • Click Advanced tab.
  • Select the Global Zone host name from the drop-down list.
  • Click OK.
 
  • We support disks on a global zone mounted using loopback File System on a non global zone.
  • This option need not be enabled if you are using a NFS share. This is because when using NFS mount paths, the operations are limited to the non-global zone and does not use the global zone.
3. Repeat the above steps on all the non-global zone clients containing the application data.  

Skip this section if you already created a snapshot copy.

Click to Continue.

Create a Snapshot Copy

Create a snapshot copy for the Storage Policy. The following section provides step-by-step instructions for creating a Snapshot Copy.

1.
  • From the CommCell Console, navigate to Policies | Storage Policies.
  • Right-click the <storage policy> and click All Tasks | Create New Snapshot Copy.

 
2.
  • Enter the copy name in the Copy Name field.
  • Select the Library, MediaAgent, master Drive Pool and Scratch Pool from the lists (not applicable for disk libraries).
  • Click OK.

Configure Backup Copy

Follow the steps given below to configure Backup Copy for moving snapshots to media.

1.
  • From the CommCell Browser, navigate to Policies | Storage Policies.
  • Right-click the <storage policy> and click Properties.
 

 
2.
  • Click the Snapshot tab.
  • Select Enable Backup Copy option to enable movement of snapshots to media.
  • Click OK.