Recovering Protected Databases Using Cloud Control

Cloud Control provides the following techniques to recover protected databases:

  • User Directed Recovery

    This technique performs manual recovery based on the specified criteria. You must provide information such as the objects that must be recovered (database, data files, tablespaces, archived redo logs), whether to perform complete recovery or point-in-time recovery, location to which database files must be recovered, and so on.

    See Also:

    Oracle Database Backup and Recovery User's Guide for more information about performing user-directed recovery

Prerequisites for Recovering Protected Databases Using Cloud Control

  • The protected database must be enrolled and registered with the target Recovery Appliance.

  • Backups required for the recovery process must be stored on the Recovery Appliance. When performing point-in-time recovery, you can recover to any point within the recovery window defined for a protected database.

Recovering an Entire Database Using Cloud Control

This section describes how to recover the entire protected database to the current time using the user-directed recovery process in Cloud Control.

To perform complete recovery of the protected database:

  1. Access the home page for the protected database as described in "Accessing the Protected Database Home Page Using Cloud Control".
  2. Ensure that the prerequisites described in "Prerequisites for Recovering Protected Databases Using Cloud Control" are met.
  3. From the Availability menu, select Backup & Recovery, and then select Perform Recovery.

    The Perform Recovery page is displayed.

  4. In the User Directed Recovery section, select the following options:

    • In Recovery Scope, select Whole Database.

    • In Operation Type, select Recover to the current time or a previous point-in-time.

  5. Click Recover to display the Perform Whole Database Recovery: Point-in-time page.
  6. Select Recover to the current time and click Next.

    The Perform Whole Database Recovery: Rename page is displayed.

  7. Select No. Restore the files to the default location and click Next.

    The Perform Whole Database Recovery: Schedule page is displayed.

  8. (Optional) Modify the default names provided for the Job Name and Job Description.
  9. Click Next to display the Perform Whole Database Recovery: Review page.
  10. (Optional) To edit the RMAN script generated for this recovery job, click Edit RMAN Script.
  11. Click Submit Job.

    A message is displayed indicting that the job is submitted successfully.

  12. Click View Job.

    The Job page containing the job execution details is displayed. The Summary section provides information such as the type of job, protected database name, SID, and Recovery Appliance catalog user name. The table at the bottom of the Summary page displays the execution steps and their status.