Loading...

Restoring an Oracle Database to a Point-in-Time

Use a point-in-time restore to revert the database to a state before an undesired transaction or before a point of failure.

Restore the control files when you restore and recover an entire database to a previous point-in-time from an online backup or offline backup to the original host.

Before You Begin

  1. Perform an online full backup if one is not available.
  2. Clear the Oracle Flashback area which forces RMAN to use the Commvault objects when performing the restore.
  3. Set the database to the correct mode defined in the table, or select the Switch Database Mode for Restore check box (Options tab), to set the Commvault software to automatically move the database to the correct mode before the restore.

    Control File in the Restore

    Required Database Mode

    Control file is included in the restore

    NOMOUNT

    Control file not included in the restore

    MOUNT

  4. Optional: When the backup pieces are unknown to the RMAN repository, catalog the backup pieces. For more information, see Cataloging RMAN Backup Pieces.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click Time Range.
  4. Select the Absolute Time option and enter the End Time date and time.

    For Oracle agents the default Time Zone is the client's time zone. For all other agents the default Time Zone is the CommServe computer's time zone.

  5. On the Browse view, select the data to restore in the right pane and click Recover All Selected.
  6. 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.

  7. On the General tab of the Oracle Restore Options dialog box:
    1. Select the name of the client computer from the Destination Client list.
    2. Select the Restore Control File check box.
    3. Click Advanced.

      The Advanced Restore Options dialog box appears.

  8. On the Restore tab, select the To Point-in-Time option and enter the date and time.

    Note: The selected time is specific to the CommServe computer's time zone.

  9. On the Recover tab, select the To Point-in-Time option and enter the date and time.
  10. When you restore the control file, on the Ctrl&SP Files tab:
    • Select the Restore From check box.
    • Select the Point-in-Time option and enter the date 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. When the time zone is different for the client and CommServe computer, on the Options tab, in the Time Zone box, select the time zone of the client computer.
  12. 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.
  13. Optional: Select the restore options.

    Set the Oracle Database ID

    Reset the database and logs.

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

    Prevent RMAN failovers to the previous backup for Oracle 10g databases or higher

    Validate the restore

    Configuring Pre- and Post-Processes

    Restore from a copy precedence

    Restore from a specific backup

  14. Click OK to close the Advanced Restore Options dialog box.
  15. Optional: View or customize the RMAN script that is generated from the selected options, see Viewing Oracle Restore RMAN Scripts and Customizing Oracle Restore RMAN Scripts.
  16. Click OK to close the Restore Options dialog box and start the restore.

Last modified: 6/4/2019 4:46:05 PM