Loading...

Recovering an Oracle Database

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

When you choose the option to recover from the latest backup time or from the latest SCN with a secondary copy, the software only considers the time or SCN from the latest job available on the secondary copy, even when the primary copy or other copies have a more recent backup job.

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

    Relative to System Date Recover to the number of days or hours relative to the current system date. The default option is to recover relative to the days,.

    If you select the Days option, the valid values are 0-7.

    If you select the Hours option, the valid values are 0-23.

  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.