Restore Oracle database

12/13/2024 Contributors

You can restore Oracle database either to the original location or to the alternate location. 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.

Single File Restore (SFR) is not supported.

Steps

In BlueXP UI, click Protection > Backup and recovery > Applications.
In the Filter By field, select the filter Type and from the drop-down select Oracle.
Click View Details corresponding to the database that you want to restore and click Restore.

In the Restore options page, specify the location where you want to restore the database files.

If you…	Do this…
Want to restore to the original location	Select Restore to original location. If the snapshot is in archival storage, select the priority to restore your data from the archival storage. Click Next. 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. Specify the recovery scope. Select All Logs if you want to recover to the last transaction. Select Until SCN (System Change Number) if you want to recover to a specific SCN. Select Date and Time if you want to recover to a specific data and time. You must specify the date and time of the database host's time zone. Select No recovery if you do not want to recover. 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. 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.
Want to temporarily restore to another storage and then copy the restored files to the original location	Select Restore to original location. If the snapshot is in archival storage, select the priority to restore your data from the archival storage. Select Change storage location. If you select Change storage location, you can append a suffix to the destination volume. If you have not selected the checkbox, then by default _restore is appended to the destination volume. Click Next. In the Storage mapping page, specify the alternate storage location details where the data restored from the object store will be stored temporarily. If you select an on-premises ONTAP system and if you haven not configured the cluster connection to the object storage, you are prompted for additional information regarding the object store. Click Next. 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. Specify the recovery scope. Select All Logs if you want to recover to the last transaction. Select Until SCN (System Change Number) if you want to recover to a specific SCN. Select Date and Time if you want to recover to a specific data and time. You must specify the date and time of the database host's time zone. Select No recovery if you do not want to recover. 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. 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.
Want to restore to an alternate location	Select Restore to alternate location. If the snapshot is in archival storage, select the priority to restore your data from the archival storage. If you want to restore to alternate storage, perform the following: Select Change storage location. If you select Change storage location, you can append a suffix to the destination volume. If you have not selected the checkbox, then by default _restore is appended to the destination volume. Click Next. In the Storage mapping page, specify the alternate storage location details where the data from the object store needs to be restored. Click Next. In the Destination host page, select the host on which the database will be mounted. (Optional) For NAS environment, specify the FQDN or IP address of the host to which the volumes restored from object store are to be exported. (Optional) For SAN environment, specify the initiators of the host to which LUNs of the volumes restored from object store are to be mapped. Click Next.

If you…

Do this…

Want to restore to the original location

Select Restore to original location.
If the snapshot is in archival storage, select the priority to restore your data from the archival storage.
Click Next.
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.
Specify the recovery scope.
- Select All Logs if you want to recover to the last transaction.
- Select Until SCN (System Change Number) if you want to recover to a specific SCN.
- Select Date and Time if you want to recover to a specific data and time.
  
  You must specify the date and time of the database host's time zone.
- Select No recovery if you do not want to recover.
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.
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.

Want to temporarily restore to another storage and then copy the restored files to the original location

Select Restore to original location.
If the snapshot is in archival storage, select the priority to restore your data from the archival storage.
Select Change storage location.

If you select Change storage location, you can append a suffix to the destination volume. If you have not selected the checkbox, then by default _restore is appended to the destination volume.
Click Next.
In the Storage mapping page, specify the alternate storage location details where the data restored from the object store will be stored temporarily.

If you select an on-premises ONTAP system and if you haven not configured the cluster connection to the object storage, you are prompted for additional information regarding the object store.
Click Next.
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.
Specify the recovery scope.
- Select All Logs if you want to recover to the last transaction.
- Select Until SCN (System Change Number) if you want to recover to a specific SCN.
- Select Date and Time if you want to recover to a specific data and time.
  
  You must specify the date and time of the database host's time zone.
- Select No recovery if you do not want to recover.
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.
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.

Want to restore to an alternate location

Select Restore to alternate location.
If the snapshot is in archival storage, select the priority to restore your data from the archival storage.
If you want to restore to alternate storage, perform the following:
1. Select Change storage location.
  
  If you select Change storage location, you can append a suffix to the destination volume. If you have not selected the checkbox, then by default _restore is appended to the destination volume.
2. Click Next.
3. In the Storage mapping page, specify the alternate storage location details where the data from the object store needs to be restored.
Click Next.
In the Destination host page, select the host on which the database will be mounted.
1. (Optional) For NAS environment, specify the FQDN or IP address of the host to which the volumes restored from object store are to be exported.
2. (Optional) For SAN environment, specify the initiators of the host to which LUNs of the volumes restored from object store are to be mapped.
Click Next.

Review the details and click Restore.

Results

The Restore to alternate location option mounts the selected backup on the given host. You should manually bring up the database.

After mounting the backup, you cannot mount it again until it is unmounted. You can use the Unmount option from the UI to unmount the backup.

For information on how to bring up the Oracle database see, Knowledge base article.

If the restore operation does not complete, do not try the restore process again until the Job Monitor shows that the restore operation has failed. If you try the restore process again before the Job Monitor shows that the restore operation has failed, the restore operation will fail again. When you see the Job Monitor status as "Failed," you can try the restore process again.

Restore Oracle database

Creating your file...