Loading...

Backing Up Oracle Databases by Using Image Copy to Secondary Storage

Use the Oracle Image Copy feature to create a snapshot of an Oracle database without having to create the snapshot on the primary storage. You can use this feature in the following cases:

  • When the primary database storage resides on volumes that cannot be snapped.
  • When you want to use less expensive storage for the copy.

The Oracle Image Copy feature:

  • Protects any database independent of the primary storage type, or server type (physical or virtual machine)
  •  Creates backups in the native format, which means that you can rapidly recover the data
  • Does not force users to place the database in hot backup mode

When you use this feature, the SnapProtect software uses RMAN to back up the incremental database changes to an image copy volume that can be snapped, and then takes a snap of the volume.

During the backup copy operation, the SnapProtect software uses the block-level interface so that you can use the data for Instant Application Recovery.

Best Practice: For enhanced performance, enable Block Change Tracking on the Oracle database because RMAN generates an incremental backup to the image copy location, and then applies that backup to the image copy files that were generated in the first full backup.

Procedure

  1. If you have not done so already, configure a storage policy for the database.
  2. If you have not done so already, configure a storage policy for the logs.
  3. Create a separate schedule for:
    • The incremental database backups
    • The log backups - Use an automatic log backup schedule for the log backups.

      For information on how to configure an automatic schedule, see Creating an Automatic Schedule for Database Log Backups.

    • The synthetic full database backups

      Synthetic full backups are typically performed on a weekly or monthly basis.

  4. Create a subclient for the database.

    Note: You must select the Use RMAN Image Copy check box and specify the location in the Path box (Create New Subclient dialog box, SnapProtect Operations tab).  The software automatically selects the  Volume Copy (Block-Level Backup - Support Instant Database Recover) option.

  5. Perform an incremental backup of the database subclient.

    Use the schedule option and select the schedule that you configured for the database backup (Backup Options dialog box, Schedule).

  6. Schedule a synthetic full backup. For more information, see Performing a synthetic full backup.

    Use the schedule option and select the schedule that you configured for the synthetic full database backup (Backup Options dialog box, Schedule)

  7. You can create database clones for test purposes, create a clone for instant application recovery.