Dell Avamar for Oracle 19.10 User Guide

Excluding Oracle directories from file system backups

You can optimize Oracle database backups and save storage space by creating a dataset that excludes the platform-specific file system from the Avamar Plug-in for Oracle backup.

1. Open the oratab file in a text editor and note the home directory for all Oracle database instances.
2. In Avamar Administrator, select Tools > Manage Dataset.
   The Manage All Datasets window appears.
3. Click New.
   The New Dataset dialog box appears.
4. In the Name box, type a name for the dataset.
   The name can include alphanumeric characters (A-Z, a-z, 0-9) and the following special characters: period (.), hyphen (-), and underscore (_). Do not use Unicode characters or the following special characters: ` ~ ! @ # $ % ^ & * ( ) = + [ ] { } | \ / ; : ' " < > , ?
5. Click the Source Data tab.
   The Source Data tab is where you define a list of source data plug-ins that contribute data to this dataset.
   1. Select Enter Explicitly and select the plug-in from the Select Plug-In Type list.
   2. To remove a plug-in from the dataset, select the plug-in from the list in the bottom portion of the New Dataset dialog box, and then click -. Repeat this step as necessary.
      NOTE:The Avamar Plug-in for Oracle does not support include or exclude lists in datasets.
6. Click the Options tab and select the plug-in from the Select Plug-In Type list.
   The windows expands to display plug-in options.
7. Complete the following fields:
   1. Leave the Oracle instance name field blank. The Oracle instance name is filled in when the Oracle server is assigned to a group.
   2. (Optional) For Oracle 12c and later, if the Oracle user has SYSBACKUP privileges (instead of SYSDBA), select SYSBACKUP privilege.
   3. Type the username to use to authenticate the Oracle database in the Username field. If you leave the Username field blank, RMAN tries to log in with the same username and password that the Avamar client agent uses, and attempts to assume SYSDBA (or SYSBACKUP) privileges.
   4. Type the password for the account in the Password field.
   5. Click OK.
      The New Dataset dialog box closes. The new dataset appears in the left pane of the Manage All Datasets window.
8. Click OK.
   The Manage All Datasets window closes.
9. In Avamar Administrator, click the Policy launcher link button.
   The Policy window appears.
10. Click the Policy Management tab.
11. Click the Clients tab.
    The left pane contains a list of domains.
12. Click the domain that contains the Oracle server.
    A list of Avamar clients appears in a table to the right of the domains list.
13. Click the client that runs the Oracle server.
14. Select Actions > Client > Edit Client.
    The Edit Client dialog box appears.
15. In the Edit Client dialog box, complete the following setting:
    1. Click the Dataset tab.
    2. From the Select An Existing Dataset list, select the dataset you created in step 4.
    3. Select Override group dataset.
    4. Click OK.