You are here: Oracle Protection > Oracle for Windows restore from the replication target > Replicated Oracle restore considerations

Replicated Oracle restore considerations and procedures

Consider the following before restoring from the replication target:

• Free space equivalent to twice the size of the backup is required on the local share for restore processing. If adequate space is not available, the restore will fail.
• A replicated backup of the source client taken after the database was deployed is required. To perform DR using Windows integrated recovery, the replicated backup must have been run using version 7.3 or higher for BIOS-based clients, or version 7.4 or higher for UEFI-based clients. To perform DR using legacy Windows hot bare metal, the backup must be a bare metal backup.
• A replicated Oracle database backup is required.
• Only one restore or backup operation per database can run at any given time. Any backup or restore initiated while another is in progress will fail.
• The Oracle backup is unfolded to a remote share. When you are finished restoring, you must tear down the share. Subsequent backup or restore operations for the given instance will fail until the restore share has been torn down.
ClosedTo restore a replicated Windows Oracle database at the target site
1 Perform disaster recovery (DR) of the Oracle client from the replication target as described in Bare metal recovery from a replication target.
2 On the replication target, enter Replication View. See Viewing replicated backups for details.
3 Select the Oracle instance under the Oracle client in the Navigation pane, and click Restore.
4 Select a Recovery Point Day from which the backup will be restored by clicking on the calendar. Available days display in bold.
5 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.

6 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 database, proceed to the next step in this procedure.
• If a share exists for this database, 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 certain 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.

7 Click Create. The system creates a share for this database and starts the restore. A row for this restore displays in the grid.
8 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.
9 Log in to the target client you created in step 1.
10 Open Explorer and navigate to the network path you noted in step 8.
11 Read the contents of the file unitrends-<database>.env. Note the following values:
• Oracle SID
• Oracle Home
• Backup #
12 Open a command prompt and run the following commands:

set ORACLE_SID=<SIDfromLastStep>

set ORACLE_HOME=<HomefromLastStep>

%ORACLE_HOME%\bin\rman target /

shutdown immediate;

startup nomount;

restore controlfile from '<pathFromStep8>\unitrends-<database>.ctf';

alter database mount;

crosscheck backup;

catalog start with '<pathFromStep8>\unitrends';

list backup tag 'unitrends-<backup#FromLastStep>';

13 Run the following commands:

restore database;

recover database;

alter database open resetlogs;

quit;

14 At this point your Oracle restore is complete. On the replication target, disconnect any network mapping to the share, then tear down the restore share using one of the following procedures:
• If the restore from Backup screen is still open in the replication target system, select the image in the Images available for recovery area, 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. Make sure to run this procedure from the replication target system.

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.