V11 SP8
Loading...

Performing a SAP for Oracle Database Copy for a Different Windows Configuration

You can use this procedure to restore a backup to a Windows configuration that has different disk layout from the source.

Note: The existing log and data summary files are overwritten. Detail files that have the same name as the ones you are restoring are overwritten.

Before You Begin

  1. Perform a full backup with an online or offline subclient.
  2. Verify the following in both the source and destination hosts:
    1. The connection specifications (host, service name, port) in the tnsnames.ora file on both the source and destination hosts must be different.
    2. There must be enough disk space on the destination host for the restored database.
    3. The source and destination hosts must have the same:
      • Operating systems
      • Oracle version
      • Processor (32-bit or 64-bit)
  3. The following Oracle initialization files must be present on the destination client:
    • init<SID>.ora
    • init<SID>.sap
    • spfile<SID>.ora
  4. On the destination host, install the SAP on Oracle application and then create an empty instance.
  5. On the destination host, create a SAP for Oracle instance in the CommCell Console.

    Note: You must have the source and destination hosts configured as clients in the same CommCell Console.

  6. On the destination host, create the SPFILE (spfile<SID>.ora) from the Oracle initialization file. Go to the $ORACLE_HOME (for UNIX configurations) directory or %ORACLE_HOME%\database folder (on Windows configuration) and type the following command:

    Note: Do not modify this file after you create it.

    ssqlplus / as sysdba
    SQL> startup nomount pfile= init .ora;
    SQL> create spfile from pfile;

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box is displayed.

  6. On the General tab:
    1. From the Destination Client list, select a client computer that is different from the source computer.

      When you select a client computer that is different from the source computer, the software automatically makes all checkboxes in the Restore Options section unavailable and automatically selects the Database Copy check box.

    2. From the Destination Instance list, select the instance that the software uses for the restore.
    3. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  7. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. On the Options tab:
    • Select the Open DB check box.
    • Select Yes from the Reset Logs list.
    • When you restore from an offline backup, select the Reset Database check box.
  9. On the Redirect tab, map the drives to the new destination.

    The software display a table that contains a row for each source drive.

    For each source drive:

    1. Select the row that represents the source drive.
    2. In the New Path box, type the destination drive that corresponds to the source drive.
    3. Click Apply.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box and start the restore.

Example

In this example, the source client is named 'client1' and the instance is named 'original' and the destination client is named 'client2' and the instance is named 'original'. The drives on each client are in the following table.

Source Drives Destination Drives
R:

S:

J:

K:

  1. From the CommCell Browser, expand Client Computers > client1 > SAP for Oracle.
  2. Right-click original, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. On the General tab:
    1. From the Destination Client list, select client2.
    2. From the Destination Instance list, select  original.
    3. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  6. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  7. On the Options tab:
    • Select the Open DB check box.
    • Select Yes from the Reset Logs list.
    • When you restore from an offline backup, select the Reset Database check box.
  8. On the Redirect tab, map the drives to the new destination.

    The software displays a row for R: and S:.

    1. Select the row that represents R:.
    2. In the New Path box, type the J:.
    3. Click Apply.
    4. Select the row that represents S:.
    5. In the New Path box, type the K:.
    6. Click Apply.
  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box and start the restore.