Restoring SAP on Oracle Individual Datafiles and Tablespaces

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 datafiles and tablespaces.

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. Select the Restore Data check box.

   2. Optional: Select the Restore Archive Logs check box.

   3. Optional: Select the Recover check box.

   4. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

7. On the Options tab, select the Switch Database mode for Restore check box.

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

9. Optional: Select the restore options.

   Open the database after the restore

   After a restore, set the Commvault software to automatically open the database. When the database is open, it records transactions.

   On the Options tab, select the Open DB check box.

   Validate the restore

   Validation verifies that the backup copies of the data and logs are intact and usable for restores. BR*Tools simulates the restore job without the media to determine whether the restore can be successfully performed.

   When a validate job is complete, you can view the job log files to identify and correct any issues.

   On the Options tab, select the Backup Validations Only check box.

   Select one verification option.

   • DB Verify - The Commvault software performs a temporary database restore and then verifies the files for database block consistency.

   • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.

   • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

   Restore the control file to an alternate location

   You can use this option when the database is in the MOUNT, SHUTDOWN or OPEN state.

   The Commvault software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

   On the Ctrl Files tab:

   1. Select the Restore Control File check box.

   2. Select the Restore Control File As check box.

   3. Type the full path where you want to restore the control file.

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.