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.

Online_cons backups and offline backups are only for database resets. You cannot use these backup types for a point-in-time recovery operation.

If you do not want to open the database after the restore (Restore Options dialog box, Options tab, clear the Open DB check box), then the Commvault software uses the -DOD option with the brrecover command. When you choose this option, you must use BR*Tools 7.40 patch 30 or higher.

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;

7. If you have more than 1000 logs, then to the SAP Oracle client add the nBRRECOVER_NUMOFLOGSTORESTORE additional setting as shown in the following table.

   For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

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. To open the database after the restore, on the Options tab, make the following selections:

   • 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.

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.

What to Do Next

If the job fails with the following error in the ClSapAgent.log file, then perform the following configuration, and then retry the job.

::AcceptIdleCallbackForOracleAgent() - Maximum idle time [180] is reached. Failing the job...

• To the SAP Oracle client add the nOraAgentSessionServerIdleTimeoutMaxCnt additional setting as shown in the following table.

  For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.