Configuring Subclients for Oracle Archive Log Backups

You use archive logs backups to recover database transactions that have been lost due to an operating system or disk failure or to recover lost database transactions.

You apply the archive logs to an online backup to recover the database.

Create separate subclients to backup log files because they are mandatory for recovering data.

Before You Begin

  1. Configure an instance for the Oracle database.
  2. Optional: You can have data and log backups use different compression. If you want to use the MediaAgent for compression for log backups, see Enabling MediaAgent Compression for Oracle or Oracle RAC Log Backups.

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 a name for the subclient.
  4. When you have not enabled control files as part of all subclient backups, on the Content tab, clear the Data check box and then select the Backup Control File check box.
  5. On the Log Backups tab, select the Backup Archive Log check box.
  6. On the Storage Device tab, in the Storage Policy list, select the storage policy name for the log backups.

    Note: You must provide a storage policy even though the log backups do not use the subclient storage policy. Log backups always use the storage policy that you define for the Oracle instance (Instance Properties dialog box, Storage Device tab, Log Backup tab, Storage Policy used for all Archive Log backups).

  7. Optional: Manage log file backup options, see Managing Oracle Log Files on a Subclient.
  8. Optional: Select the subclient options.
    Expand All

    Run scripts before or after the backup

    You can choose to run the post-process script even if the backup job failed.

    To pass the database instance name to the script, see Passing the Instance Name to Pre and Post Scripts for Databases.

    On the Pre/Post tab:

    1. In the Pre-Backup Command box, type the full path name for the script.
    2. In the PostBackup Command box, type the full path name for the script.
    3. To run the post backup process regardless of the job's outcome, select the Run Post Process for all attempts check box.

    Uniquely identify the backup

    On the Backup Arguments tab, select the Oracle Tag check box.

    Enter a backup tag in the box.

    You can include variables in the tag. See supported Oracle tag variables.

    Have the SnapProtect software automatically validate backup jobs performed on this subclient

    Backup validation checks for the following conditions:

    • There is no physical and logical block corruption in the datafiles
    • The database files exist and are in the correct location

    RMAN simulates the backup job without the media to determine whether the backup can be successfully performed.

    On the Backup Arguments tab, click the Options tab and then select the Validate check box.

    Use MediaAgent compression for log backups

    You can use the MediaAgent for log backup compression when you use a non-deduplication storage policy.

    1. Click Storage Device.
    2. Click Data Transfer Option.
    3. Select Use Storage Policy Settings.
  9. Click OK to close the Creating New Subclient dialog box.

What to Do Next