V11 SP8
Loading...

Configuring Oracle Selective Online Incremental Backups

You perform a selective online incremental backup when the database is online and have performed a selective online full backup. A selective online incremental backup includes the data, logs and control file. It uses less media because it only contains the changes from the last selective online full or selective online incremental backup. The advantage of a selective online full backup is that the data and logs use the same storage policy, which means that they reside on the same media and are self-contained for long-term archiving.

For more information on selective online full backups, see Selective Online Incremental Backups.

Before You Begin

  1. Configure an instance for the Oracle database.
  2. Create a Storage Policy.
  3. Create a Selective Copy for the storage policy.

    On the Retention tab:

    • Set the Basic Retention Rules For All Backups to use the days and cycle option.
    • Set the Basic Retention Rules For Data/Compliance Archiver Data to use the days option.
    • Set the Extended Retention Rules for Full Backups to use the days option and to Keep Full Backups.

    On the Selective Copy tab:

    Set the Automatically select Full Backups at frequency to All Fulls.

  4. Optional: Run the script below from the Commvault install base directory on the CommServe computer, to copy a full cycle of jobs to selective copy.  For information, see Copying a Full Cycle of Jobs to a Selective Copy.
  5. Optional: Decide if you want the software to force the parallel log backup to use the data storage policy. For more information, see Configuring the Storage Policy for a Parallel Log Backup.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Oracle.
  2. Right-click the instance, point to All Tasks and then click New Subclient.

    The Create New Subclient dialog box appears.

  3. On the General tab, in the Subclient Name box, enter the subclient name.
  4. On the Content tab, select the Selective Online Full Backup check box.
  5. On the Storage Device tab, in the Data Storage Policy list, select the storage policy name with the selective copy.
  6. Click OK to close the Creating New Subclient dialog box.

What To Do Next

  1. Run a full backup.
  2. Run an incremental backup.
  3. Perform an Auxiliary Copy.
  4. Run the Data Aging Job Summary Report. Verify that the selective online full and selective online incremental jobs are retained by the basic retention rules.
  5. Enable Retention of a Full Cycle of Selective Jobs on the Selective Copy.
  6. Run the Data Aging Job Summary Report. Verify that the selective online full and selective online incremental jobs are retained by the basic retention rules.