Restore of Oracle server

Oracle Server Restore

The IBackup for Windows 'Oracle server Restore' wizard guides you through a simple step-by-step approach to restore the Oracle server databases from your computer to the Oracle server.

Note: To perform Oracle server database restore, download the 'Advanced Backup Plug-in' after installing the 'IBackup for Windows' application.

General Features

Authentication of Oracle server database for restore
Provision to restore the Oracle database using Complete and Incomplete recovery methods
Provision to report the progress of the restore process
Restores are secured with the highest level of 128-bit SSL encryption on transmission
Provision to generate the log files for each restore session

Resources

Download

Advanced Backup Plug-in

Oracle Server Backup

To view the steps to backup the Oracle server databases, click here.

Related Links

User manual (PDF)

Business Solutions

Requirements for restore
Following are the prerequisites for Oracle server restore:

Install the IBackup for Windows application on the computer where the Oracle 9i/10g server/client is available
The 'IBOracleBackup' folder selected for restore should be in the same path as it was while performing the backup operation
The database must be in ARCHIVELOG Mode
The Oracle server user should have SYSDBA privilege
Oracle Recovery Manager (RMAN) should be available on the computer where the IBackup for Windows application has been installed

Consult your Oracle DBA before you perform the Oracle server restore operation.

Enabling ARCHIVELOG Mode
To enable ARCHIVELOG Mode using Oracle Recovery Manager (RMAN), follow the steps given below:

RMAN> connect target <username>/<PWD>@<SID> [connect to your Oracle database];
RMAN> shutdown immediate;
RMAN> startup mount;
RMAN> sql 'alter database archivelog';
RMAN> alter database open;

To restore the Oracle server database, follow the steps listed below:

Step 1

Select the 'Oracle Server Restore' option

From the 'Backup-Restore' menu option > Oracle Server > Oracle Server Restore
OR
From the 'Wizards' icon on the toolbar > Advanced Backup > Oracle Server > Oracle Server Restore

Step 2

A welcome window appears as shown below. Click the 'Next' button.

Step 3

Enter the authentication information and log on to the Oracle server database.

Oracle Server Restore

Note: Ensure that the Oracle server user who is currently logged in has the SYSDBA privileges.

To grant the SYSDBA privileges to the user:
SQL>grant sysdba to <user>

Step 4

Using the 'Browse' button, select the 'IBOracleBackup' folder where the Oracle server database files were backed up.

Note: The restore folder 'IBOracleBackup' that you have selected should be in the same path as it was while performing the backup operation. In case you have deleted the folder, then create a folder with the same name and in the same path, as it existed during the backup operation.

Step 5

Click the 'Restore' button to commence the restore process. A message, as shown below appears. Click 'Yes' to proceed with the operation.

Incomplete Recovery

Incomplete Recovery is a time-based recovery of the Oracle databases, which restores the files as of a particular date and time, specified during the operation.

To perform the Incomplete Recovery of your Oracle database(s).

Perform the above-mentioned steps till Step 3

Step 4

On the Oracle restore screen, select the option 'Incomplete Recovery' and double-click the database name. A dialog appears from which you can choose the date and time.

Click the drop-down arrow, a Calendar appears. Here, select the date and then the time using the up-down arrow keys or by just entering the time and click the 'OK' button.

The date and time selected for 'Incomplete Recovery' of the databases should not be less than the database creation time or reset logs creation time.

Click the 'Restore' button and follow the procedure as detailed in Step 5.