Loading...

Oracle RAC Instant Database Clones That Use IntelliSnap with Image Copy

Use the Image Copy feature to create a snapshot of an Oracle RAC 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 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 so 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 Commvault 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 Commvault software uses the block-level interface.

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.

To check the status of the block change tracking, run the following query as a sysdba user:

SELECT * FROM v$block_change_tracking
STATUS     FILENAME                  BYTES     CON_ID
---------- -------------------- ---------- ----------
DISABLED

If the status is DISABLED, you can enable block change tracking by running the following SQL*Plus command:

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/path/to/block_change_tracking_file.bct';

Note: The Oracle Express Edition and the Oracle Standard Edition do not support block change tracking.

Configure an Oracle RAC client for IntelliSnap and a subclient that has image copy, create a image copy for the database.

The procedure flow is:

  • Perform a full backup of the database.
  • You can manually run a backup copy job, or configure the Commvault software to run a backup copy job after the backup completes.

    This operation copies the snapshot to the media and provides an additional standby copy.

  • Create the clone

Before You Begin

  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. Select and configure the IntelliSnap array.
  4. Configure the Oracle RAC client for IntelliSnap.
  5. If you have not done so already, configure a storage policy for the database.
  6. If you have not done so already, configure a storage policy for the logs.
  7. Create a separate schedule for:
    • The database backups
    • The log backups
  8. Create a subclient for the database.

Procedure

  1. Perform a backup.
  2. Create the clone.

Last modified: 2/27/2018 12:29:24 AM