ASM Rebalancing for Oracle Databases

Updated

Create a permanent Oracle clone so that you can quickly migrate or duplicate the database to a different host, or to restore the database in the case of a hardware failure.

You can create a clone from an IntelliSnap backup, or a disk image copy. Both the source and destination must be on an ASM diskgroup. You can specify the destination ASM diskgroup layout by using an xml file.

When you use this feature, the Commvault software automatically adds the new disk that you specify to the permanent clone instance. After the diskgroup is rebalanced, the software drops the database snapshot from the new diskgroup so that the clone resides on the new disks. The clone is marked as permanent and becomes a regular Oracle database and Commvault no longer manages the database.

ASM Diskgroup Requirements

The ASM diskgroup that gets snapped must have one of the following redundancy types:

  • External group

  • External redundancy

  • Normal (2 failure groups)

  • High (3 failure groups)

Before You Begin

  • To the Oracle destination client, add the additional setting as shown in the following table.

    For instructions on how to add additional settings from the CommCell Console, see Add or Modify an Additional Setting.

Property

Value

Name

sINSTANTCLONE_ASMREBALANCE_INPUTFILE_FOR_CLONESID

Note: The additional setting must be in upper case. CLONESID is the SID of the clone database.

Example

If the clone job SID is "newdb", then the additional setting is: sINSTANTCLONE_ASMREBALANCE_INPUTFILE_FOR_NEWDB

Category

OracleAgent

Type

String

Value

The full path to the xml file that specifies the diskgroup layout that the software uses for the rebalance operation.

Procedure

  1. Download the asm_mirror.xml file to the destination computer.

    For more information, see Oracle XML Parameters for ASM Rebalancing.

  2. Place the file in the folder that you specified in the additional setting Value parameter.

  3. Create a backup by using one of the following methods:

    Note

    The SID that you use for these procedures must match the one that you set in the sINSTANTCLONE_ASMREBALANCE_INPUTFILE_FOR_CLONESID additional setting.

    IntelliSnap

    Image Copy

Result

The Commvault software creates a clone that gets marked as an Oracle database.

You can use the database as you would any other Oracle database.