Creating a Subclient to Back Up Oracle Individual Datafiles and Tablespaces

Updated

You can create subclients to backup specific datafiles and tablespaces, which undergo frequent changes in the Oracle database.

Before You Begin

If you want to use the Oracle RMAN backup copy option by using a proxy server, you must contact Oracle for their required licensing.

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, enter the Subclient Name.

  4. On the Content tab.

    • Select the Online Subset option.

    • Click Yes on the Warning dialog box.

    • From the Current Database View, select the database objects to include.

    • Select the Backup Control File check box to include the control file in the backup.

    • Select the Backup SP File check box to include the SP file in the backup

  5. On the Storage Device tab from the Data Storage Policy list, select the storage policy that the software uses for data backups.

  6. Configure the IntelliSnap options.

    1. On the IntelliSnap Operations tab, select the IntelliSnap check box.

      A message appears that tells you that the next backup will be a full backup.

    2. Click OK.

    3. From the Available Snap Engines list, select the appropriate engine.

      Note

      If your Oracle database is hosted by an Amazon EC2 account, you must select Amazon as the Available Snap Engine value. For information on how to manage the Amazon array, see Getting Started for Amazon.

    4. To use a proxy server, from the Use Proxy list, select the appropriate MediaAgent.

      This is the MediaAgent that is used to perform the IntelliSnap backup copy operations. For information on how to configure a proxy server for backup copy operations, see Configuring Proxy Clients for Backup Copy Operations.

      Note

      When you perform an IntelliSnap backup using a proxy, make sure that the operating system on the proxy server is either same version or later than the operating system on the client computer.

    5. To have the backup copy operation fall back to the source if the proxy is unreachable, select the Use source if proxy is unreachable check box.

      This prevents the interruption of the backup schedule when the proxy cannot be reached.

    6. Determine the copy option.

      For more information on the backup copy options, see Oracle IntelliSnap - Backup Copy.

      • To use the File system copy, select File System.

      • To use the RMAN backup copy, select RMAN.

      • To use Volume Copy, select Volume Copy (Block-Level Backup - Support Instant Database Recover).

        Note: You must select this option when you want to use the Copy Data Management feature.

        The option is automatically selected when you select the Snap Image Copy check box.

    7. Optional: To perform an integrity check of the hardware, select the Enable Snap Integrity Check check box.

  7. Optional: Run scripts before or after the backup

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

    On the Pre/Post tab:

    1. In the PreSnap Command box, type the full path name for the script.

    2. In the PostSnap 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.

  8. Click OK.

Was this page helpful?