> CommCell Console > Backup and Restore Agents > Databases > Oracle > Oracle Backup Administrator Guide > Oracle Restores

Recovering an Oracle Database

You can recover the database to a point other than the current time, if 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.

Note

You can only use a dynamic listener if this operation is for a control file restore.

Procedure

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

  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. Optional: Use non-default browse and restore options. For more information, see Browse and Restore.

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

    The Oracle Restore Options dialog box appears.

  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, clear the Restore Data check box, and then click the Advanced button.

    The Advanced Restore Options dialog box appears.

  8. On the Recover tab, 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.

Click OK to close the Advanced Restore Options dialog box.

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

  2. Click OK to close the Restore Options dialog box and start the restore.

×

Loading...