Recovering a Database

By default, the database is recovered along with the restore. However, you can also restore the data and then recover the database to a later point-in-time.

Recovering a Database to the Current Time

You can recover a database to the current time either to the original host or to a different host. Use the following steps to recover a database to the current time:

1. From the CommCell Browser, go to Client Computers > RAC client.

2. Right-click the instance, then go to All Tasks > Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. Select Latest Backup, and then click the View Content button.

4. Select the database, and then click the Recover All Selected button.

   The Oracle Restore Options dialog box appears.

5. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

   The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

6. On the General tab, clear the Restore Data check box, and then click the Advanced button.

   The Advanced Restore Options dialog box appears.

7. On the Recover tab, click Current Time.

8. Click OK.

9. Click OK.

Recovering a Database to a Point-in-Time

You can apply archived logs and recover a database to a previous point-in-time where it is consistent and stable. Use the following steps to recover a database to a point-in-time:

1. From the CommCell Browser, go to Client Computers > RAC client.

2. Right-click the instance, then go to All Tasks > Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. Select Latest Backup, and then click the View Content button.

4. Select the database, and then click the Recover All Selected button.

   The Oracle Restore Options dialog box appears.

5. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

   The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

6. On the General tab, clear the Restore Data check box and click the Advanced button.

   The Advanced Restore Options dialog box appears.

7. On the Recover tab, select the Point-in-Time option and enter the date and time.

   The time selected is specific to the CommServe time zone.

8. On the Options tab, from the Reset Logs list, select Yes.

9. From the Time Zone list, select the time zone of the client computer. This is required if the time zone is different for the client and CommServe.

10. Click OK.

11. Click OK.

Recovering a Database Using the System Change Number

The latest backup job's completion time is passed to the recover operation. This is the Completion Time on the General tab of the Job Details dialog box, which you can see by right-clicking the job and selecting View Job Details.

Use the following steps to recover a database using the SCN:

1. From the CommCell Browser, go to Client Computers > RAC client.

2. Right-click the instance, then go to All Tasks > Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. Select Latest Backup, and then click the View Content button.

4. Select the database, and then click the Recover All Selected button.

   The Oracle Restore Options dialog box appears.

5. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

   The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

6. On the General tab, clear the Restore Data check box, and then click the Advanced button.

   The Advanced Restore Options dialog box appears.

7. On the Recover tab, click the SCN button and then enter the System Change Number.

8. On the Options tab, from the Reset Logs list, select Yes.

9. Click OK.

10. Click OK.

Recovering a Database Using the Latest Backup Time

The latest backup job's completion time is passed to the recover operation. This is the Completion Time on the General tab of the Job Details dialog box, which you can see by right-clicking the job and selecting View Job Details.

1. From the CommCell Browser, go to Client Computers > RAC client.

2. Right-click the instance, then go to All Tasks > Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. Select Latest Backup, and then click the View Content button.

4. Select the database, and then click the Recover All Selected button.

   The Oracle Restore Options dialog box appears.

5. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

   The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

6. On the General tab, clear the Restore Data check box and then click the Advanced button.

   The Advanced Restore Options dialog box appears.

7. On the Recover tab, click the Latest Backup Time button.

8. Click OK.

9. Click OK.

Recovering a Database Using the Latest SCN Number

You can recover the database to the last existing SCN number in the latest backup. This is the lowest Next SCN number between all the threads in the General tab of the Job Details dialog box, which you can see by right-clicking the job and selecting View Job Details.

Use the following steps to recover a database to the last backup time.

1. From the CommCell Browser, go to Client Computers > RAC client.

2. Right-click the instance, then go to All Tasks > Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. Select Latest Backup, and then click the View Content button.

4. Select the database, and then click the Recover All Selected button.

   The Oracle Restore Options dialog box appears.

5. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

   The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

6. On the General tab, clear the Restore Data check box, and then click the Advanced button.

7. On the Recover tab, click the Latest SCN Number button.

8. Click OK.

9. Click OK.