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.
About this task
NOTE:Including Oracle database files with the file system backup consumes storage space in the Avamar system and increases network traffic during the nightly backup window.
Create a dataset that excludes the entire root directory branch for each Oracle instance, and then assign the dataset to the Avamar client. For example, if the full pathname of a database instance is
/space/local/oracle/ora901, exclude this directory in the Avamar dataset.
Steps
Open the
oratab file in a text editor and note the home directory for all Oracle database instances.
In
Avamar Administrator, select
Tools > Manage Dataset.
The
Manage All Datasets window appears.
Click
New.
The
New Dataset dialog box appears.
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: ` ~ ! @ # $ % ^ & * ( ) = + [ ] { } | \ / ; : ' " < > , ?
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.
Select
Enter Explicitly and select the plug-in from the
Select Plug-In Type list.
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.
Click the
Options tab and select the plug-in from the
Select Plug-In Type list.
The windows expands to display plug-in options.
Complete the following fields:
Leave the
Oracle instance name field blank. The Oracle instance name is filled in when the Oracle server is assigned to a group.
(Optional) For Oracle 12c and later, if the Oracle user has
SYSBACKUP privileges (instead of
SYSDBA), select
SYSBACKUP privilege.
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.
Type the password for the account in the
Password field.
Click
OK.
The
New Dataset dialog box closes. The new dataset appears in the left pane of the
Manage All Datasets window.
Click
OK.
The
Manage All Datasets window closes.
In
Avamar Administrator, click the
Policylauncher link button.
The
Policy window appears.
Click the
Policy Management tab.
Click the
Clients tab.
The left pane contains a list of domains.
Click the domain that contains the Oracle server.
A list of Avamar clients appears in a table to the right of the domains list.
Click the client that runs the Oracle server.
Select
Actions > Client > Edit Client.
The
Edit Client dialog box appears.
In the
Edit Client dialog box, complete the following setting:
Click the
Dataset tab.
From the
Select An Existing Dataset list, select the dataset you created in step
4.
Select
Override group dataset.
Click
OK.
Data is not available for the Topic
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: <>()\