Restoring Individual SAP Oracle 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

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

2. If the backup you want to restore is a third party command line backup, edit the initSID.sap file and add the following line to set the BLKSIZE parameter to 1048576.

    
   RMAN_PARMS="SBT_LIBRARY=/opt/software name/Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName=client_name,CvInstanceName=Instance001)"

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. Select Latest Backup and click View Content.

4. In the right pane of the CommCell Browser window, select the datafiles and tablespaces to restore, and click Recover All Selected.

5. On the Restore Options dialog box:

   1. Select the Restore Data check box.

   2. Select the Recover check box.

   3. Click Advanced.

      The Advanced Restore Options dialog box appears.

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

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. Optional: Select the restore options.

   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 Validate check box.

   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.

   Reset the database and logs.

   By default, the database is automatically set to open, and the logs are reset.

   If you reset the logs to an open state, you can then reset the database.

   On the Options tab, select the Reset Database check box and one of the following Reset Log options:

   • To open the database without the RESETLOGS option, select None.

   • To open the database with the RESETLOGS option, select Yes.

   • To open the database with the NORESETLOGS option, select No.

   Perform a point-in-time restore of a database that was backed up in NOARCHIVELOG mode

   If the database was backed up in NOARCHIVELOG mode, enable the redo logs.

   When the no redo log is disabled, BR*Tools searches archived redo logs after applying the incremental backup data during a restore. When you set No Re-do Logs, BR*Tools restores the data from the incremental backup and not the archived redo logs.

   On the Options tab, select the No Re-do Logs check box.

   Restore the control file to an alternate location

   You can use this option when the database is in the MOUNT 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.

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.

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