Restore Oracle database

You can only restore the Oracle database to the same host where the backup was created. For a RAC database, the data is restored to the on-premises node where the backup was created.

Only full database with control file restore is supported. If the archive logs are not present in the AFS, you should specify the location that contains the archive logs required for recovery.

Important Single File Restore (SFR) is not supported.

Steps

  1. In BlueXP UI, click Protection > Backup and recovery > Applications.

  2. In the Filter By field, select the filter Type and from the drop-down select Oracle.

  3. Click View Details corresponding to the database that you want to restore and click Restore.

  4. On the Restore Type page, perform the following actions:

    1. Select Database State if you want to change the state of the database to the state required to perform restore and recovery operations.

      The various states of a database from higher to lower are open, mounted, started, and shutdown.

      • If the database is in a higher state but the state must be changed to a lower state to perform a restore operation, you must select this check box.

      • If the database is in a lower state but the state must be changed to a higher state to perform the restore operation, the database state is changed automatically even if you do not select the check box.

      • If a database is in the open state, and for restore the database needs to be in the mounted state, then the database state is changed only if you select this check box.

    2. Select Control files if you want to restore control file along with full database.

    3. If the snapshot is in archival storage, specify the priority to restore your data from the archival storage.

  5. On the Recovery Scope page, perform the following actions:

    1. Specify the recovery scope.

      If you…​ Do this…​

      Want to recover to the last transaction

      Select All Logs.

      Want to recover to a specific System Change Number (SCN)

      Select Until SCN (System Change Number).

      Want to recover to a specific data and time

      Select Date and Time.

      You must specify the date and time of the database host’s time zone.

      Do not want to recover

      Select No recovery.

      Want to specify any external archive log locations

      If the archive logs are not present in the active file system, you should specify the location that contains the archive logs required for recovery.

    2. Select the check box if you want to open the database after recovery.

      In a RAC setup, only the RAC instance that is used for recovery is opened after recovery.

  6. Review the details and click Restore.