Recovering an 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 > 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 and click the Advanced button.
  7. On the Recover tab of the Advanced Restore Options dialog box, select the database recover option:
    Choice Description
    Current Time Recover to the current time.

    Note: If the database is in NORACHIVELOG mode, select this option when you want to perform a point-in-time restore from an offline incremental backup

    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.

    SCN The System Change Number (SCN) tracks the timing of transactions in the Oracle database. The SCNs are stored in the control files and the datafile headers. You can recover the database to the last existing SCN number in the control file, which is the last consistent database state.
    Latest Backup Time Recover to the latest backup job's completion time, which gets passed to the recover operation.

    This value is the Completion Time on the General Tab of the Job Details dialog box. To view the value, right-click the job, and then select View Job Details. For instructions, see Job Controller - Getting Started.

    Latest SCN Number Recover to the latest SCN.

    The latest backup job's Next SCN number is passed to the recover operation. This is the Next SCN on the General Tab of the Job Details dialog box. To view the value, right-click the job and then select View Job Details. For instructions, see Job Controller - Getting Started.

  8. Click OK to close the Advanced Restore Options dialog box.
  9. 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.
  10. Click OK to close the Restore Options dialog box and start the restore.