> CommCell Console > Backup and Restore Agents > Databases > Oracle RAC > Oracle RAC Restore Operations > Restoring and Recovering an Entire Oracle RAC Database

Restoring an Oracle RAC Database to a Previous Point-in-Time

The point-in-time restore is useful in the following scenarios:

  • If any undesired transaction occurs in the database, you can revert the database to a state just before the transaction.

  • If a database fails, you can restore to the state just before the point of failure.

When you restore and recover an entire database to a previous point-in-time from an online backup or offline backup (depending on how the subclient was configured for backups) to the original host, it is recommended to use the control files.

Note

When you perform a point-in-time restore for a database, the next scheduled backup for that database will automatically convert to a full backup.

Procedure

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

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

  3. Select Latest Backup and click View Content.

  4. Select the database and click Recover All Selected.

  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 Oracle Restore Options dialog box, navigate to the General tab, select the Restore Control File check box to restore the control files.

  7. On the Stream tab of the Restore Options for Client dialog box:

    1. Specify the number of streams to use for each Oracle RAC instance in the Stream column.

    2. Click Advanced.

  8. On the Advanced Restore Options dialog box, on the Restore tab, select the To Point-in-Time option and enter the data and time.

  9. On the Advanced Restore Options dialog box, on the Recover tab, select the To Point-in-Time option and enter the data and time.

  10. On the Advanced Restore Options dialog box, on the Ctrl&SP Files tab, when you selected that option, select the To Point-in-Time option and enter the data and time.

    You must restore the control files to a point-in-time later than or equal to the point-in-time set in the Restore tab.

  11. On the Advanced Restore Options dialog box, on the Options tab, in the Time Zone box, select the time zone of the client computer. Use this when the client and CommServe computer are in different time zones.

  12. Click OK to start the restore.

Page contents

×

Loading...