Adding Oracle Subclients

You can add the following content in the subclients:

• Data and logs

• Data only

• Logs only

• Data subset, for example tablespaces

• Data subset and logs

Use the following criteria when determining the unique data sets:

• The data content you want to back up and how you need to restore the data (for example, all tablespaces or a subset of tablespaces)

• The database state when you perform backups

• The required schedule for the data

You can create subclients for specific datafiles and tablespaces that frequently change or have a different backup schedule than the entire database.

Before You Begin

If you have not already done so, add an instance for the Oracle database.

Procedure

1. From the navigation pane, go to Protect > Databases.

   The Instances page appears.

2. Click the instance.

   The instance page appears.

3. In the Subclients section of the Overview tab, click Add subclient.

4. In the Subclient name box, type the subclient name.

5. From the Plan list, select a server plan.

6. In the Number of data streams box, type the number of streams that the software uses for backups.

7. Select the data to include in the backup.

   • To back up an online database, select the Data backup check box, and then select Online.

   • To back up an online database subset, select the Data backup check box, and then select Online subset.

   • To back up an offline database subset, select the Data backup check box, and then select Offline.

     The database shutdown or startup (lights out) script is run automatically during the backup.

   • To back up the database logs, clear the Data backup check box, and then select the Archive log backup check box.

8. If you chose to include the logs in the backup, select the Delete archive logs check box to have the software delete the logs after a successful backup.

9. To support restore operations for individual tables, move the Collect table metadata toggle to the right.

10. Click Save.

Result

You can perform backup operations on the subclient.

The Commvault software stores the backup in the target that is associated with the server plan.

The Commvault software automatically backs up the data and the log files by using the schedules that are associated with the server plan.