You are here: Oracle Protection > Oracle restore from the backup system > Restoring Oracle backups

Restoring Oracle backups

Use these procedures to restore Oracle backups:

ClosedTo restore an Oracle backup

Use this procedure to restore a database to the original location. Note that the existing database is deleted from the Oracle instance as part of the restore process.

1 Select an Oracle instance under the Oracle client in the Navigation pane and click Restore.
2 Select a Recovery Point Day from which the backup will be restored by clicking on the calendar. Available days display in bold.
3 Select a restore time and click Next (Select Options).

Select from available times in the Recovery Point Times table or by clicking a wedge of time on the 24-hour circle. The database instance to restore displays in the Type column.

4 In the Restore from Backup of Client pane, select Restore to Original Oracle Server, and click Restore.
5 To confirm you understand that the existing database will be deleted and a new one created on the target server, check the I understand... box, and click Confirm.

The Restore Status page indicates whether the restore has been queued successfully. Click Okay to close.

6 To monitor the restore job, select Settings > System Monitoring > Jobs.
• The restore job displays in the grid. In a successful restore, status changes from Queued to Active to Successful.
• If you see a Cancelled status and a Share is unavailable job comment, the restore could not run because a share has already been created for this instance and is in use by another backup or restore job. See Oracle share is unavailable to determine what process is using the share and how to proceed.
ClosedTo restore items from an Oracle backup

Use this procedure to unfold the backup to a share on the source backup system. Once unfolded, use an Oracle or third-party tool to restore desired items.

1 Select the Oracle instance under the Oracle client in the Navigation pane, and click Restore.
2 Select a Recovery Point Day from which the backup will be restored by clicking on the calendar. Available days display in bold.
3 Select a restore time and click Next (Select Files/Items).

Select from available times in the Recovery Point Times table or by clicking a wedge of time on the 24-hour circle. The database instance to restore displays in the Database column.

4 On the Restore from Backup of Client page, if you see A file share is available, check the shares in the grid below to see if one exists for this database instance. Instance name displays at the end of the Network Path column.
• If no share exists for this instance, proceed to the next step in this procedure.
• If a share exists for this instance, it is either in use by another backup or restore process, or it has not been torn down after a prior item restore. You cannot perform the item restore until the share becomes available. If you are sure no active job is using the share, tear it down by selecting it in the grid and clicking Tear Down. Be sure to disconnect any network drive mappings to this share before tearing down. For details on checking for active jobs, see Oracle share is unavailable.
5 Click Create. The system creates a share for this database and starts the restore. A row for this restore displays in the grid.
6 Click Refresh to display the full path of the share, \\<SourceSystemIP>\<ClientName>-<Instance>. Note or copy the Network Path supplied as you will need it to access files to restore.
7 On the workstation you will use to restore files, map a network drive to \\<SourceSystemIP>\<ClientName>-<Instance>. For example, on a Windows workstation:
• Launch Explorer, right-click Computer and select Map Network Drive.
• In the Folder field, enter the share displayed in the Network Path field in step 6, then click Finish.
8 Restore the desired items using an Oracle or third-party tool.
9 Disconnect the network share once files have been restored by right-clicking the share and selecting Disconnect.
10 On the source backup system, tear down the restore image using one of the following procedures:
• If the Restore from Backup screen is still open in the backup system, select the image in the Images available for recoveryarea, and click Tear Down. Click Yes to confirm that you would like to proceed. The share is removed.
• If you have closed the Restore from the Backup screen, follow the instructions described in About the Oracle restore session.

Important!  Tear down the share as soon as possible. Subsequent backups and restores cannot run for this instance until the share has been manually torn down.

ClosedOracle share is unavailable

If an Oracle backup or restore operation fails with the Share is unavailable message, use this procedure to identify the process using the share and determine how to proceed. Only one restore or backup job per instance can run at any given time.

1 Select the Oracle instance under the Oracle client in the Navigation pane.
2 Select Settings >System Monitoring > Restore Disk images.
3 Select Application Restore Images. A list of restore images displays.
4 Click Refresh to ensure that the list is current.
5 If you see In use for backup in the Message column, a backup or full database restore is currently running for this instance. Once it completes, you can tear down the share and then perform the next backup or restore operation.
• Check running jobs on the Status > Present blind to see whether this is a backup or full restore. See Monitoring running backup jobs for details.
• If a backup is running, either wait for the backup to complete or terminate the backup.
• If a restore is running, you must wait for it to complete. Terminating a restore in process can leave the database in an inconsistent state.
6 If you see restore in the Message column, the share has not yet been torn down from a prior item-level restore. Disconnect any network drive mappings to the share, then tear it down by selecting it in the grid, and clicking Tear Down. Once the share is torn down, you can run the next backup or restore operation.