Recovering a SAP on Oracle Database

You can recover the database to a point other than the current time when the current database is inconsistent.

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

6. On the Restore Options dialog box, clear the Restore Data check box, select the Restore Control File check box and then click the Advanced button.

7. On Recover tab of the Advanced Restore Options dialog box, select the database recover option:

   Choice	Description
   Current Time	Recover to the current time
   Point-in-Time	Enter the date and time. Note If the time zone is different on the CommServe computer and client, in the Time Zone box, select the client computer time zone.

8. Optional: Restore the control file to a different location.

   Click the Ctrl Files tab and then select the Restore Control File and Restore Control File check boxes and then enter the full path where you want to restore the control file.

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.

   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, RMAN searches archived redo logs after applying the incremental backup data during a restore. When you set No Re-do Logs, the data is restored from the incremental backup and not the archived redo logs.

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

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.