Redirecting an Oracle RAC Backup to a New Location

Recover a missing or corrupted datafile and tablespace when:

• A datafile or tablespace is corrupted after you have restored the database

• A datafile or tablespace is the only lost data that must be restored. You can restore the datafile or tablespace instead of the entire database.

Before You Begin

• Perform a full backup with a subclient configured for Oracle datafiles and tablespaces.

• When you do not want to update the control file with the restore, follow Disabling the Oracle Datafile Switch.

Procedure

1. From the CommCell Browser, expand Client Computers > client.

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 then click View Content.

4. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

5. Click Restore out of place, and then click Next.

   The Oracle Out of Place Restore Options dialog box appears.

6. Click Advanced.

   The Advanced Restore Options dialog box appears.

7. On the Redirect tab:

   1. Select the Redirect check box.

   2. Select each object and type the new path in New Path box. Repeat for all objects you want to change. To confirm the new path, click Apply.

   3. Select the tablespaces to redirect.

      To redirect all the objects displayed in the Object column to a new location, select the Redirect All Table Spaces.

      To select individual tablespaces, click the New Path column associated with the tablespace type the path in the New Path box.

      To redirect multiple tablespaces, click Find & Replace, and enter the new path in the New Path box.

8. To automatically move the database to the correct mode before the restore, on the Options tab select the Switch Database Mode for Restore check box.

9. On the Stream tab, specify the number of streams to use for each Oracle RAC instance in the Stream column.

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.

If your restore includes system tablespaces, switch the database mode to MOUNT.