Creating a Subclient for Oracle Logical Dump Backups

You can create a subclient to run backups using the Oracle Logical Dump utility.

Before You Begin

• Define the path to the Java home directory where you installed Java, if you haven't already done so.

Procedure

1. From the CommCell Browser, expand Client Computers > client > Oracle.

2. Right-click the instance, point to All Tasks, and then click New Logical Subclient.

   The Create New Logical Dump Subclient dialog box appears.

3. On the General tab, in the Subclient name box, type a unique name for the subclient.

4. On the Content tab, specify the data to include in the backup:

   1. Determine the schemas to include:

      • To include the entire database, select Full Database.

      • To include a subset of the tables, select Schema. Then, under Available Schema, select the schemas to include in the backup, and then click Add All.

   2. In the Parallelism for export box, type the number of streams that the software uses for the export utility.

   3. In the Staging path for dump file box, type the complete path on the proxy server where the software places the dump file.

      The export dump files and the log files are placed in CVEXjobID folders under the path that you define.

5. To override the instance credentials, select the Override instance credentials check box, and then, in the Connect String boxes, type the connect string for the Oracle database. If you want the user to be externally authenticated using OS authentication, configure the connect string as "/" or " /@service" (where service is the service name) for the proxy instance. The user must have at least the following Oracle privileges:

   CREATE SESSION,CONNECT,CREATE ANY DIRECTORY,CREATE DATABASE LINK,DATAPUMP_EXP_FULL_DATABASE,DATAPUMP_IMP_FULL_DATABASE,CREATE TABLE,DBA

6. On the Storage Device tab, from the Storage Policy list, select the storage policy name.

7. Click OK.

Result

You can perform full backup operations for the Oracle data from the subclient.